APPS.PO_PDOI_MAINPROC_UTL_PVT dependencies on PO_LINE_LOCATIONS_DRAFT_ALL

Line 688: FROM po_line_locations_draft_all

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

Line 934: FROM po_line_locations_draft_all

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