DBA Data[Home] [Help]

APPS.CSTPACDP dependencies on OE_ORDER_LINES_ALL

Line 1922: FROM oe_order_lines_all ool,

1918: -- whether the original sales order issue was inserted into
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;

Line 4774: FROM oe_order_lines_all ool,

4770: -- whether the original sales order issue was inserted into
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