APPS.CTO_UPDATE_ITEMS_PK dependencies on OE_ORDER_LINES_ALL

Line 232: from oe_order_lines_all oel,

228: begin
229:
230: select oeh.order_number
231: into l_order_number
232: from oe_order_lines_all oel,
233: oe_order_headers_all oeh
234: where oel.line_id = v_lines.ato_line_id
235: and oel.header_id = oeh.header_id;
236:

Line 331: from oe_order_lines_all oel,

327: -- Bugfix 13362916
328: BEGIN
329: select oeh.order_number
330: into l_order_number
331: from oe_order_lines_all oel,
332: oe_order_headers_all oeh
333: where oel.line_id = v_lines.ato_line_id
334: and oel.header_id = oeh.header_id;
335: EXCEPTION

Line 596: from oe_order_lines_all oel,

592: -- bug 13362916
593: BEGIN
594: select oeh.order_number
595: into l_order_number
596: from oe_order_lines_all oel,
597: oe_order_headers_all oeh
598: where oel.line_id = v_lines.ato_line_id
599: and oel.header_id = oeh.header_id;
600: EXCEPTION

Line 715: from oe_order_lines_all oel,

711: -- bug 13362916
712: BEGIN
713: select oeh.order_number
714: into l_order_number
715: from oe_order_lines_all oel,
716: oe_order_headers_all oeh
717: where oel.line_id = v_lines.ato_line_id
718: and oel.header_id = oeh.header_id;
719: EXCEPTION

Line 779: from oe_order_lines_all oel,

775: -- bug 13362916
776: BEGIN
777: select oeh.order_number
778: into l_order_number
779: from oe_order_lines_all oel,
780: oe_order_headers_all oeh
781: where oel.line_id = v_lines.ato_line_id
782: and oel.header_id = oeh.header_id;
783: EXCEPTION

Line 3071: from oe_order_lines_all ol

3067: select nvl(costing_group_id,1)
3068: into l_cst_grp
3069: from pjm_project_parameters ppp
3070: where ppp.project_id = ( select project_id
3071: from oe_order_lines_all ol
3072: where ol.line_id = pLineId )
3073: and ppp.organization_id = pOrgId;
3074:
3075: if (l_cst_grp = 0) then