[Home] [Help]
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
1792: NOT EXISTS (SELECT 'Dist Exist'
1793: FROM PO_REQ_DISTRIBUTIONS_GT PRD
1794: WHERE PRD.requisition_line_id = PRL.requisition_line_id);
1795:
1796: --Increment the p_sequence with number of errors reported in last query
1797: p_sequence := p_sequence + SQL%ROWCOUNT;
1822: , l_line_amt_tbl --
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
1835: AND PRL.line_type_id = PLT.line_type_id --
1836: AND --
1837: ( ( ( PLT.order_type_lookup_code IN ('QUANTITY','AMOUNT')
1838: AND ( PRL.quantity <> ( SELECT nvl(sum(PRD2.req_line_quantity),0)
1839: FROM PO_REQ_DISTRIBUTIONS_GT PRD2
1840: WHERE PRD2.requisition_line_id = PRL.requisition_line_id ) ) )
1841: OR ( ( PLT.order_type_lookup_code IN ('RATE','FIXED PRICE') )
1842: AND ( PRL.amount <> ( SELECT nvl(sum(PRD2.req_line_amount),0)
1843: FROM PO_REQ_DISTRIBUTIONS_GT PRD2
1839: FROM PO_REQ_DISTRIBUTIONS_GT PRD2
1840: WHERE PRD2.requisition_line_id = PRL.requisition_line_id ) ) )
1841: OR ( ( PLT.order_type_lookup_code IN ('RATE','FIXED PRICE') )
1842: AND ( PRL.amount <> ( SELECT nvl(sum(PRD2.req_line_amount),0)
1843: FROM PO_REQ_DISTRIBUTIONS_GT PRD2
1844: WHERE PRD2.requisition_line_id = PRL.requisition_line_id ) ) ) )
1845: )
1846: GROUP BY
1847: PRL.line_num
1949: PRL.source_type_code = 'INVENTORY' AND
1950: nvl(PRL.cancel_flag,'N') = 'N' AND
1951: nvl(PRL.closed_code, 'OPEN') <> 'FINALLY CLOSED' AND
1952: 1 < (SELECT count(PRD.requisition_line_id)
1953: FROM PO_REQ_DISTRIBUTIONS_GT PRD
1954: WHERE PRD.requisition_line_id = PRL.requisition_line_id);
1955:
1956: --Increment the p_sequence with number of errors reported in last query
1957: p_sequence := p_sequence + SQL%ROWCOUNT;
4198: FROM PO_REQUISITION_LINES_ALL PRL, --
4199: PO_LINE_LOCATIONS_GT POLL,
4200: PO_LINES POL,
4201: PO_DISTRIBUTIONS PD,
4202: PO_REQ_DISTRIBUTIONS_ALL PRD --
4204: AND POLL.po_line_id = POL.po_line_id
4205: AND PRL.unit_price >= 0
4206: AND POLL.line_location_id = PD.line_location_id
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:
10146: PO_CORE_S.get_document_ids(
12276: || l_progress,'Populate Req Distributions');
12277: END IF;
12278: END IF;
12279:
12280: INSERT INTO po_req_distributions_gt(
12281: DISTRIBUTION_ID ,
12282: LAST_UPDATE_DATE ,
12283: LAST_UPDATED_BY ,
12284: REQUISITION_LINE_ID ,
12404: PRD.RECOVERY_RATE ,
12405: PRD.TAX_RECOVERY_OVERRIDE_FLAG ,
12406: PRD.OKE_CONTRACT_LINE_ID ,
12407: PRD.OKE_CONTRACT_DELIVERABLE_ID
12408: FROM po_req_distributions PRD, po_requisition_lines PRL
12409: WHERE PRD.requisition_line_id = PRL.requisition_line_id AND
12410: PRL.requisition_header_id = p_document_id;
12411:
12412: l_progress := '001';
14773: , l_line_num_tbl
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