APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_REQ_HEADERS_GT

Line 3528: FROM PO_REQ_HEADERS_GT PRH

3524: 0,
3525: p_sequence + ROWNUM,
3526: substr(l_textline,1,240),
3527: 'PO_SUB_REQ_HEADER_NO_LINES'
3528: FROM PO_REQ_HEADERS_GT PRH
3529: WHERE PRH.requisition_header_id = p_document_id
3530: AND NOT EXISTS (SELECT 'Lines Exist'
3531: FROM PO_REQ_LINES_GT PRL
3532: WHERE PRL.requisition_header_id = PRH.requisition_header_id

Line 13489: DELETE FROM po_req_headers_gt;

13485: DELETE FROM po_lines_gt;
13486: DELETE FROM po_line_locations_gt;
13487: DELETE FROM po_distributions_gt;
13488: DELETE FROM po_releases_gt;
13489: DELETE FROM po_req_headers_gt;
13490: DELETE FROM po_req_lines_gt;
13491: DELETE FROM po_req_distributions_gt;
13492: DELETE FROM po_online_report_text_gt;
13493:

Line 15288: INSERT INTO po_req_headers_gt(

15284: || l_progress,'Populate Req Headers');
15285: END IF;
15286: END IF;
15287:
15288: INSERT INTO po_req_headers_gt(
15289: PROGRAM_UPDATE_DATE ,
15290: INTERFACE_SOURCE_CODE ,
15291: INTERFACE_SOURCE_LINE_ID ,
15292: CLOSED_CODE ,

Line 18382: , PO_REQ_HEADERS_GT PRH

18378: , l_distribution_num_tbl
18379: FROM
18380: PO_REQ_DISTRIBUTIONS_GT PRD
18381: , PO_REQ_LINES_GT PRL
18382: , PO_REQ_HEADERS_GT PRH
18383: WHERE PRL.requisition_line_id = PRD.requisition_line_id --JOIN
18384: AND PRH.requisition_header_id = PRL.requisition_header_id --JOIN
18385: AND PRL.line_location_id IS NULL
18386: AND

Line 23440: FROM po_req_headers_gt prh,

23436: l_text_line||
23437: ' on line ' ||
23438: prl.line_num,
23439: 'PO_CLOSE_WIP_JOB'
23440: FROM po_req_headers_gt prh,
23441: po_req_lines_gt prl
23442: WHERE prh.requisition_header_id = prl.requisition_header_id
23443: AND nvl(prh.authorization_status,'INCOMPLETE') <> 'APPROVED'
23444: AND nvl(prl.cancel_flag,'N') = 'N'