APPS.CTO_UPDATE_ITEMS_PK dependencies on OE_ORDER_HEADERS_ALL

Line 213: oe_order_headers_all oeh

209:
210: select oeh.order_number
211: into l_order_number
212: from oe_order_lines_all oel,
213: oe_order_headers_all oeh
214: where oel.line_id = v_lines.ato_line_id
215: and oel.header_id = oeh.header_id;
216:
217: exception

Line 305: oe_order_headers_all oeh

301: WriteToLog('ERROR: Populate_src_orgs_upg returned with exp error',1);
302: select oeh.order_number
303: into l_order_number
304: from oe_order_lines_all oel,
305: oe_order_headers_all oeh
306: where oel.line_id = v_lines.ato_line_id
307: and oel.header_id = oeh.header_id;
308:
309: WriteToLog('++++++++++++++++++++++++++++++++++++++++++', 1);

Line 536: oe_order_headers_all oeh

532: WriteToLog('ERROR: Create_oss_sourcing_rules returned with exp error',1);
533: select oeh.order_number
534: into l_order_number
535: from oe_order_lines_all oel,
536: oe_order_headers_all oeh
537: where oel.line_id = v_lines.ato_line_id
538: and oel.header_id = oeh.header_id;
539:
540: WriteToLog('++++++++++++++++++++++++++++++++++++++++++', 1);

Line 594: oe_order_headers_all oeh

590: WriteToLog('ERROR: Create_sourcing_rules returned with exp error',1);
591: select oeh.order_number
592: into l_order_number
593: from oe_order_lines_all oel,
594: oe_order_headers_all oeh
595: where oel.line_id = v_lines.ato_line_id
596: and oel.header_id = oeh.header_id;
597:
598: WriteToLog('++++++++++++++++++++++++++++++++++++++++++', 1);

Line 647: oe_order_headers_all oeh

643: WriteToLog('ERROR: Create_type3_sourcing_rules returned with exp error',1);
644: select oeh.order_number
645: into l_order_number
646: from oe_order_lines_all oel,
647: oe_order_headers_all oeh
648: where oel.line_id = v_lines.ato_line_id
649: and oel.header_id = oeh.header_id;
650:
651: WriteToLog('++++++++++++++++++++++++++++++++++++++++++', 1);