APPS.PO_OM_INTEGRATION_GRP dependencies on PO_HEADERS_ALL

Line 128: l_cur_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;

124: l_processed_pos INDEXED_TBL_NUMBER;
125: l_processed_releases INDEXED_TBL_NUMBER;
126: l_processed_reqs INDEXED_TBL_NUMBER;
127:
128: l_cur_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
129: l_cur_po_release_id PO_RELEASES_ALL.po_release_id%TYPE;
130: l_cur_req_header_id PO_REQUISITION_HEADERS_ALL.requisition_header_id%TYPE;
131: l_start_index NUMBER;
132:

Line 732: from PO_HEADERS_ALL

728: SELECT TYPE_LOOKUP_CODE,
729: org_id -- Bug 3362534
730: INTO l_doc_subtype,
731: l_document_org_id
732: from PO_HEADERS_ALL
733: WHERE po_header_id = p_po_header_id(i);
734: l_doc_type := 'PO';
735: END IF;
736:

Line 977: FROM po_headers_all

973: WHERE po_release_id = p_chg.po_release_id;
974: ELSE -- PO
975: SELECT org_id, authorization_status
976: INTO l_document_org_id, l_authorization_status
977: FROM po_headers_all
978: WHERE po_header_id = p_chg.po_header_id;
979: END IF;
980:
981: l_progress := '010';

Line 1378: po_headers_all PH,

1374: 'Y', 'Y', -- po is cancelled
1375: 'N')))
1376: BULK COLLECT INTO x_purge_allowed_tbl
1377: FROM po_session_gt PSG,
1378: po_headers_all PH,
1379: po_line_locations_all PLL
1380: WHERE PSG.key = l_seq_id
1381: AND PSG.num1 = PLL.line_location_id (+)
1382: AND PLL.po_header_id = PH.po_header_id (+)