SELECT ooh.order_number, ool.line_number, ool.ordered_item, ool.ordered_quantity * ool.unit_selling_price, rcta.trx_number invoice_number, rcta.trx_date, rctl.line_number, rctl.unit_selling_price, ooh.org_id FROM oe_order_headers_all ooh, oe_order_lines_all ool, ra_customer_trx_all rcta, ra_customer_trx_lines_all rctl WHERE ooh.header_id = ool.header_id AND rcta.interface_header_context = 'ORDER ENTRY' AND rctl.interface_line_context = 'ORDER ENTRY' AND rctl.interface_line_attribute1 = TO_CHAR (ooh.order_number) AND rctl.interface_line_attribute6 = TO_CHAR (ool.line_id) AND rctl.customer_trx_id = rcta.customer_trx_id AND ooh.order_number = NVL (:p_order_number, ooh.order_number) --AND ooh.org_id=nvl(:p_org_id,ooh.org_id)
Friday, November 18, 2016
Query for link between OM to Receivables
Subscribe to:
Post Comments (Atom)
Oracle Fusion - Cost Lines and Expenditure Item link in Projects
SELECT ccd.transaction_id,ex.expenditure_item_id,cacat.serial_number FROM fusion.CST_INV_TRANSACTIONS cit, fusion.cst_cost_distribution_...
-
P2P(Procure-to-Pay) Cycle Tables with Joins Pre Requisites for Purchase Order: 1.Item Creation: 2.Supplier Creation: 3.Buy...
-
LookUps In Oracle Apps Lookups in Oracle are a collection of values. Lookups are a static collection of codes which are used by o...
-
SELECT TO_CHAR(PPA.PROJECT_ID) PROJECT_ID ,TO_CHAR(PPA.SEGMENT1) PROJECT_NUMBER ,PPA.NAME PROJECT_NAME ,PPA.DESCRIPTION ,PPA.START_DATE ,PP...
No comments:
Post a Comment