DBA Data[Home] [Help]

APPS.CSTPACDP dependencies on OE_ORDER_LINES_ALL

Line 2013: FROM oe_order_lines_all ool,

2009: -- whether the original sales order issue was inserted into
2010: -- the Revenue / COGS Matching data model.
2011: SELECT max(ool.reference_line_id)
2012: INTO l_ref_om_line_id
2013: FROM oe_order_lines_all ool,
2014: cst_revenue_cogs_match_lines crcml
2015: WHERE ool.line_id = i_cogs_om_line_id
2016: AND ool.reference_line_id = crcml.cogs_om_line_id
2017: AND crcml.pac_cost_type_id IS NULL;

Line 4865: FROM oe_order_lines_all ool,

4861: -- whether the original sales order issue was inserted into
4862: -- the Revenue / COGS Matching data model.
4863: SELECT max(ool.reference_line_id)
4864: INTO l_ref_om_line_id
4865: FROM oe_order_lines_all ool,
4866: cst_revenue_cogs_match_lines crcml
4867: WHERE ool.line_id = i_cogs_om_line_id
4868: AND ool.reference_line_id = crcml.cogs_om_line_id
4869: AND crcml.pac_cost_type_id IS NULL