DBA Data[Home] [Help]

APPS.CST_REVENUECOGSMATCH_PVT dependencies on MTL_TRANSACTIONS_INTERFACE

Line 7497: FROM mtl_transactions_interface mti , cst_revenue_cogs_match_lines crcml

7493: WHERE CRCML.revenue_om_line_id = CRRL.revenue_om_line_id
7494: AND CRCML.ledger_id = p_ledger_id)
7495: OR EXISTS
7496: (SELECT 1
7497: FROM mtl_transactions_interface mti , cst_revenue_cogs_match_lines crcml
7498: WHERE mti.trx_source_line_id = crcml.cogs_om_line_id
7499: AND crcml.revenue_om_line_id=crrl.revenue_om_line_id
7500: UNION
7501: SELECT 1

Line 7534: FROM mtl_transactions_interface mti , cst_revenue_cogs_match_lines crcml

7530: WHERE CRCML.revenue_om_line_id = CRRL.revenue_om_line_id
7531: AND CRCML.ledger_id = p_ledger_id)
7532: and not exists
7533: (SELECT 1
7534: FROM mtl_transactions_interface mti , cst_revenue_cogs_match_lines crcml
7535: WHERE mti.trx_source_line_id = crcml.cogs_om_line_id
7536: AND crcml.revenue_om_line_id=crrl.revenue_om_line_id
7537: UNION
7538: SELECT 1