APPS.PO_AUTOCREATE_POSTPROC_PVT dependencies on PO_LINE_LOCATIONS_DRAFT_ALL

Line 2384: FROM po_lines_draft_all pld, po_lines_interface PLI, po_line_locations_draft_all pll

2380: CURSOR c_shipments
2381: IS
2382:
2383: SELECT pll.line_location_id
2384: FROM po_lines_draft_all pld, po_lines_interface PLI, po_line_locations_draft_all pll
2385: WHERE pll.uda_template_id IS NULL
2386: AND PLI.interface_header_id = po_autocreate_params.g_interface_header_id
2387: AND PLD.po_header_id = po_autocreate_params.g_po_header_id
2388: AND pld. line_num =PLI.line_num

Line 2509: UPDATE po_line_locations_draft_all

2505: ELSIF x_doc_level_tbl(i) = 'SHIPMENT' THEN
2506: FOR l_ship_rec IN c_shipments
2507: LOOP
2508: l_progress := '120';
2509: UPDATE po_line_locations_draft_all
2510: SET uda_template_id = l_ship_uda_tmpl_id
2511: WHERE line_location_id = l_ship_rec.line_location_id
2512: AND draft_id = po_autocreate_params.g_draft_id;
2513: END LOOP;