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 858: from PO_HEADERS_ALL

854: SELECT TYPE_LOOKUP_CODE,
855: org_id -- Bug 3362534
856: INTO l_doc_subtype,
857: l_document_org_id
858: from PO_HEADERS_ALL
859: WHERE po_header_id = p_po_header_id(i);
860: l_doc_type := 'PO';
861: END IF;
862:

Line 1103: FROM po_headers_all

1099: WHERE po_release_id = p_chg.po_release_id;
1100: ELSE -- PO
1101: SELECT org_id, authorization_status
1102: INTO l_document_org_id, l_authorization_status
1103: FROM po_headers_all
1104: WHERE po_header_id = p_chg.po_header_id;
1105: END IF;
1106:
1107: l_progress := '010';

Line 1504: po_headers_all PH,

1500: 'Y', 'Y', -- po is cancelled
1501: 'N')))
1502: BULK COLLECT INTO x_purge_allowed_tbl
1503: FROM po_session_gt PSG,
1504: po_headers_all PH,
1505: po_line_locations_all PLL
1506: WHERE PSG.key = l_seq_id
1507: AND PSG.num1 = PLL.line_location_id (+)
1508: AND PLL.po_header_id = PH.po_header_id (+)