APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_REQ_LINES_GT

Line 1743: FROM PO_REQ_LINES_GT PRL

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
1745: AND nvl(PRL.cancel_flag,'N') = 'N');
1746:
1747: --Increment the p_sequence with number of errors reported in last query

Line 1787: FROM PO_REQ_LINES_GT PRL

1783: 0,
1784: p_sequence + ROWNUM,
1785: substr(g_linemsg||g_delim||PRL.line_num||g_delim||l_textline,1,240),
1786: 'PO_SUB_REQ_LINE_NO_DIST'
1787: FROM PO_REQ_LINES_GT PRL
1788: WHERE PRL.requisition_header_id = p_document_id AND
1789: nvl(PRL.cancel_flag,'N') = 'N' AND
1790: nvl(PRL.closed_code,'OPEN') <> 'FINALLY CLOSED' AND
1791: nvl(PRL.modified_by_agent_flag,'N') = 'N' AND

Line 1827: , PO_REQ_LINES_GT PRL

1823: , l_dist_qty_tbl --
1824: , l_dist_amt_tbl --
1825: FROM
1826: PO_REQ_DISTRIBUTIONS_GT PRD
1827: , PO_REQ_LINES_GT PRL
1828: , PO_LINE_TYPES_B PLT --
1829: WHERE
1830: PRL.requisition_line_id = PRD.requisition_line_id
1831: AND PRL.requisition_header_id = p_document_id

Line 1947: FROM PO_REQ_LINES_GT PRL

1943: 0,
1944: p_sequence + ROWNUM,
1945: substr(g_linemsg||g_delim||PRL.line_num||g_delim||l_textline,1,240),
1946: 'PO_SUB_REQ_SOURCE_ONE_DIST'
1947: FROM PO_REQ_LINES_GT PRL
1948: WHERE PRL.requisition_header_id = p_document_id AND
1949: PRL.source_type_code = 'INVENTORY' AND
1950: nvl(PRL.cancel_flag,'N') = 'N' AND
1951: nvl(PRL.closed_code, 'OPEN') <> 'FINALLY CLOSED' AND

Line 1995: FROM PO_REQ_LINES_GT PRL, FINANCIALS_SYSTEM_PARAMETERS FSP,

1991: 0,
1992: p_sequence + ROWNUM,
1993: substr(g_linemsg||g_delim||PRL.line_num||g_delim||l_textline,1,240),
1994: 'PO_SUB_REQ_RATE_NULL'
1995: FROM PO_REQ_LINES_GT PRL, FINANCIALS_SYSTEM_PARAMETERS FSP,
1996: GL_SETS_OF_BOOKS SOB
1997: WHERE PRL.requisition_header_id = p_document_id AND
1998: nvl(PRL.cancel_flag, 'N') = 'N' AND
1999: nvl(PRL.closed_code, 'OPEN') <> 'FINALLY CLOSED' AND

Line 2083: FROM PO_REQ_LINES_GT PRL, FINANCIALS_SYSTEM_PARAMETERS FSP,

2079: 0,
2080: p_sequence + ROWNUM,
2081: substr(g_linemsg||g_delim||PRL.line_num||g_delim||l_textline,1,240),
2082: 'PO_ATO_ITEM_NA'
2083: FROM PO_REQ_LINES_GT PRL, FINANCIALS_SYSTEM_PARAMETERS FSP,
2084: MTL_SYSTEM_ITEMS MSI
2085: WHERE PRL.requisition_header_id = p_document_id AND
2086: nvl(PRL.cancel_flag, 'N') = 'N' AND
2087: nvl(PRL.closed_code, 'OPEN') <> 'FINALLY CLOSED' AND

Line 10141: DELETE FROM po_req_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:
10145:

Line 11945: INSERT INTO po_req_lines_gt(

11941: || l_progress,'Populate Req Lines');
11942: END IF;
11943: END IF;
11944:
11945: INSERT INTO po_req_lines_gt(
11946: REQUEST_ID ,
11947: PROGRAM_APPLICATION_ID ,
11948: PROGRAM_ID ,
11949: PROGRAM_UPDATE_DATE ,

Line 14778: , PO_REQ_LINES_GT PRL

14774: , l_shipment_num_tbl
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