0

oracle configurator tables R12 - CZ Schema

posted on , by Adarsh

 1)     CZ_ADDRESSES 2)     CZ_ADDRESS_USES 3)     CZ_ARCHIVES 4)     CZ_ARCHIVE_REFS 5)     CZ_ATP_REQUESTS 6)     CZ_BATCH_VAL_SESSION_DATA 7)     CZ_COMBO_FEATURES 8)     CZ_CONFIG_ATTRIBUTES 9)     CZ_CONFIG_EXT_ATTRIBUTES 10)  CZ_CONFIG_HDRS 11)  CZ_CONFIG_INPUTS 12)  CZ_CONFIG_ITEMS 13)  ...

0

Query for sales order details in R12

posted on , by Adarsh

 SELECT   ooha.header_id order_header_id, ottt.NAME order_type_name,ooha.order_number, ooha.ordered_date,ooha.transactional_curr_code order_currency, hp.party_id,hp.party_number, hp.party_name customer_name,hca.cust_account_id customer_id, hca.account_number customer_number,oola.line_id order_line_id, oola.line_number, oola.inventory_item_id,msib.segment1 item_number, msib.description item_desc,oola.attribute15 superseded_item, oola.order_quantity_uom,oola.ordered_quantity, oola.unit_selling_price  ...