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) ...
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 ...