APPS.PO_R12_CAT_UPG_FINAL_GRP dependencies on PO_LINES_ALL

Line 832: FROM PO_LINES_ALL

828: FORALL i IN 1 .. p_po_header_ids.COUNT
829: INSERT INTO PO_SESSION_GT(key, num1)
830: SELECT l_key,
831: po_line_id
832: FROM PO_LINES_ALL
833: WHERE po_header_id = p_po_header_ids(i);
834:
835: l_progress := '040';
836: -- SQL What: Transfer from session GT table to local array

Line 1165: FROM PO_LINES_ALL POL

1161: svc_amount_notif_sent,
1162: svc_completion_notif_sent,
1163: 'Y', -- latest_external_flag
1164: 0 -- revision_num
1165: FROM PO_LINES_ALL POL
1166: WHERE POL.po_line_id = l_po_line_ids(i)
1167: AND NOT EXISTS
1168: (SELECT 'Archive record for Line already exists'
1169: FROM PO_LINES_ARCHIVE_ALL POLA2