APPS.OE_COGS_GRP dependencies on OE_ORDER_LINES_ALL

Line 37: FROM oe_order_lines_all

33:
34: --9811795 start
35: SELECT ato_line_id
36: INTO l_ato_line_id_cogs
37: FROM oe_order_lines_all
38: WHERE line_id=l_line_id;
39:
40: IF l_ato_line_id_cogs IS NOT NULL THEN
41:

Line 65: FROM oe_order_lines_all

61: IF x_revenue_event_line_id <> -1 THEN
62:
63: SELECT ato_line_id
64: INTO l_ato_line_id_rev
65: FROM oe_order_lines_all
66: WHERE line_id=x_revenue_event_line_id;
67:
68: IF l_ato_line_id_rev <> l_ato_line_id_cogs THEN
69:

Line 217: FROM oe_order_lines_all l,

213:
214: BEGIN
215: SELECT 'Y' INTO l_notify_costing
216: FROM DUAL WHERE EXISTS (SELECT l.line_id
217: FROM oe_order_lines_all l,
218: mtl_system_items msi
219: WHERE link_to_line_id = p_line_id
220: AND l.inventory_item_id=msi.inventory_item_id
221: AND msi.organization_id= l_master_org_id