DBA Data[Home] [Help]

APPS.CSTPACDP dependencies on CST_REVENUE_COGS_MATCH_LINES

Line 1923: cst_revenue_cogs_match_lines crcml

1919: -- the Revenue / COGS Matching data model.
1920: SELECT max(ool.reference_line_id)
1921: INTO l_ref_om_line_id
1922: FROM oe_order_lines_all ool,
1923: cst_revenue_cogs_match_lines crcml
1924: WHERE ool.line_id = i_cogs_om_line_id
1925: AND ool.reference_line_id = crcml.cogs_om_line_id
1926: AND crcml.pac_cost_type_id IS NULL;
1927:

Line 4775: cst_revenue_cogs_match_lines crcml

4771: -- the Revenue / COGS Matching data model.
4772: SELECT max(ool.reference_line_id)
4773: INTO l_ref_om_line_id
4774: FROM oe_order_lines_all ool,
4775: cst_revenue_cogs_match_lines crcml
4776: WHERE ool.line_id = i_cogs_om_line_id
4777: AND ool.reference_line_id = crcml.cogs_om_line_id
4778: AND crcml.pac_cost_type_id IS NULL
4779: AND i_txn_type_id = 16;