APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_REQ_HEADERS_GT

Line 1740: FROM PO_REQ_HEADERS_GT PRH

1736: 0,
1737: p_sequence + ROWNUM,
1738: substr(l_textline,1,240),
1739: 'PO_SUB_REQ_HEADER_NO_LINES'
1740: FROM PO_REQ_HEADERS_GT PRH
1741: WHERE PRH.requisition_header_id = p_document_id
1742: AND NOT EXISTS (SELECT 'Lines Exist'
1743: FROM PO_REQ_LINES_GT PRL
1744: WHERE PRL.requisition_header_id = PRH.requisition_header_id

Line 10140: DELETE FROM po_req_headers_gt;

10136: DELETE FROM po_lines_gt;
10137: DELETE FROM po_line_locations_gt;
10138: DELETE FROM po_distributions_gt;
10139: DELETE FROM po_releases_gt;
10140: DELETE FROM po_req_headers_gt;
10141: DELETE FROM po_req_lines_gt;
10142: DELETE FROM po_req_distributions_gt;
10143: DELETE FROM po_online_report_text_gt;
10144:

Line 11770: INSERT INTO po_req_headers_gt(

11766: || l_progress,'Populate Req Headers');
11767: END IF;
11768: END IF;
11769:
11770: INSERT INTO po_req_headers_gt(
11771: PROGRAM_UPDATE_DATE ,
11772: INTERFACE_SOURCE_CODE ,
11773: INTERFACE_SOURCE_LINE_ID ,
11774: CLOSED_CODE ,

Line 14779: , PO_REQ_HEADERS_GT PRH

14775: , l_distribution_num_tbl
14776: FROM
14777: PO_REQ_DISTRIBUTIONS_GT PRD
14778: , PO_REQ_LINES_GT PRL
14779: , PO_REQ_HEADERS_GT PRH
14780: WHERE PRL.requisition_line_id = PRD.requisition_line_id --JOIN
14781: AND PRH.requisition_header_id = PRL.requisition_header_id --JOIN
14782: AND PRL.line_location_id IS NULL
14783: AND