APPS.PO_PDOI_MAINPROC_UTL_PVT dependencies on PO_LINE_LOCATIONS_DRAFT_ALL

Line 691: FROM po_line_locations_draft_all

687: SELECT l_key,
688: p_po_line_id_tbl(i),
689: v.max_shipment_num
690: FROM (SELECT max(shipment_num) AS max_shipment_num
691: FROM po_line_locations_draft_all
692: WHERE draft_id = p_draft_id_tbl(i)
693: AND po_line_id = p_po_line_id_tbl(i)
694: AND NVL(delete_flag, 'N') = 'N') v
695: WHERE v.max_shipment_num IS NOT NULL;

Line 937: FROM po_line_locations_draft_all

933: FORALL i IN 1..l_index_tbl.COUNT
934: INSERT INTO po_session_gt(key, num1)
935: SELECT l_key,
936: l_index_tbl(i)
937: FROM po_line_locations_draft_all
938: WHERE po_line_id = p_po_line_id_tbl(i)
939: AND draft_id = p_draft_id_tbl(i)
940: AND shipment_type = 'STANDARD'
941: AND shipment_num = p_shipment_num_tbl(i);