APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_REQ_DISTRIBUTIONS_GT

Line 3587: FROM PO_REQ_DISTRIBUTIONS_GT PRD

3583: nvl(PRL.cancel_flag,'N') = 'N' AND
3584: nvl(PRL.closed_code,'OPEN') <> 'FINALLY CLOSED' AND
3585: nvl(PRL.modified_by_agent_flag,'N') = 'N' AND
3586: NOT EXISTS (SELECT 'Dist Exist'
3587: FROM PO_REQ_DISTRIBUTIONS_GT PRD
3588: WHERE PRD.requisition_line_id = PRL.requisition_line_id)
3589: AND Nvl(l_clm_req,'N') = 'N';
3590:
3591: --Increment the p_sequence with number of errors reported in last query

Line 3623: PO_REQ_DISTRIBUTIONS_GT PRD

3619: , l_line_amt_tbl --
3620: , l_dist_qty_tbl --
3621: , l_dist_amt_tbl --
3622: FROM
3623: PO_REQ_DISTRIBUTIONS_GT PRD
3624: , PO_REQ_LINES_GT PRL
3625: , PO_LINE_TYPES_B PLT --
3626: WHERE
3627: PRL.requisition_line_id = PRD.requisition_line_id

Line 3638: FROM PO_REQ_DISTRIBUTIONS_GT PRD2

3634: ( ( ( PLT.order_type_lookup_code IN ('QUANTITY','AMOUNT')
3635: --Start Bug 13065293
3636: AND ( round(PRL.quantity,15) <> ( SELECT round(nvl(sum(PRD2.req_line_quantity),0),15)
3637: --End Bug 13065293
3638: FROM PO_REQ_DISTRIBUTIONS_GT PRD2
3639: WHERE PRD2.requisition_line_id = PRL.requisition_line_id ) ) )
3640: OR ( ( PLT.order_type_lookup_code IN ('RATE','FIXED PRICE') )
3641: AND ( PRL.amount <> ( SELECT nvl(sum(PRD2.req_line_amount),0)
3642: FROM PO_REQ_DISTRIBUTIONS_GT PRD2

Line 3642: FROM PO_REQ_DISTRIBUTIONS_GT PRD2

3638: FROM PO_REQ_DISTRIBUTIONS_GT PRD2
3639: WHERE PRD2.requisition_line_id = PRL.requisition_line_id ) ) )
3640: OR ( ( PLT.order_type_lookup_code IN ('RATE','FIXED PRICE') )
3641: AND ( PRL.amount <> ( SELECT nvl(sum(PRD2.req_line_amount),0)
3642: FROM PO_REQ_DISTRIBUTIONS_GT PRD2
3643: WHERE PRD2.requisition_line_id = PRL.requisition_line_id ) ) ) )
3644: )
3645: GROUP BY
3646: PRL.line_num

Line 3752: FROM PO_REQ_DISTRIBUTIONS_GT PRD

3748: PRL.source_type_code = 'INVENTORY' AND
3749: nvl(PRL.cancel_flag,'N') = 'N' AND
3750: nvl(PRL.closed_code, 'OPEN') <> 'FINALLY CLOSED' AND
3751: 1 < (SELECT count(PRD.requisition_line_id)
3752: FROM PO_REQ_DISTRIBUTIONS_GT PRD
3753: WHERE PRD.requisition_line_id = PRL.requisition_line_id);
3754:
3755: --Increment the p_sequence with number of errors reported in last query
3756: p_sequence := p_sequence + SQL%ROWCOUNT;

Line 13491: DELETE FROM po_req_distributions_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:
13494:
13495: PO_CORE_S.get_document_ids(

Line 15798: INSERT INTO po_req_distributions_gt(

15794: || l_progress,'Populate Req Distributions');
15795: END IF;
15796: END IF;
15797:
15798: INSERT INTO po_req_distributions_gt(
15799: DISTRIBUTION_ID ,
15800: LAST_UPDATE_DATE ,
15801: LAST_UPDATED_BY ,
15802: REQUISITION_LINE_ID ,

Line 18380: PO_REQ_DISTRIBUTIONS_GT PRD

18376: , l_line_num_tbl
18377: , l_shipment_num_tbl
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

Line 23665: po_req_distributions_gt PRD,

23661: PRL.line_num, 1, 240
23662: ),
23663: Nvl2( PRD.code_combination_id, 'PO_RI_INVALID_CHARGE_ACC_ID','PO_CHARGE_NOT_NULL' )
23664: FROM
23665: po_req_distributions_gt PRD,
23666: po_req_lines_gt PRL,
23667: gl_sets_of_books sob
23668: WHERE
23669: PRD.requisition_line_id = PRL.requisition_line_id

Line 23722: po_req_distributions_gt PRD,

23718: PRL.line_num, 1, 240
23719: ),
23720: Nvl2( prd.budget_account_id, 'PO_RI_INVALID_BUDGET_ACC_ID', 'PO_BUDGET_NOT_NULL' )
23721: FROM
23722: po_req_distributions_gt PRD,
23723: po_req_lines_gt PRL,
23724: gl_sets_of_books sob
23725: WHERE
23726: PRD.requisition_line_id = PRL.requisition_line_id

Line 23779: po_req_distributions_gt PRD,

23775: PRL.line_num, 1, 240
23776: ),
23777: Nvl2( prd.variance_account_id, 'PO_RI_INVALID_VARIANCE_ACC_ID', 'PO_VARIANCE_NOT_NULL' )
23778: FROM
23779: po_req_distributions_gt PRD,
23780: po_req_lines_gt PRL,
23781: gl_sets_of_books sob
23782: WHERE
23783: PRD.requisition_line_id = PRL.requisition_line_id

Line 23835: po_req_distributions_gt PRD,

23831: PRL.line_num, 1, 240
23832: ),
23833: Nvl2( prd.accrual_account_id, 'PO_RI_INVALID_ACCRUAL_ACC_ID', 'PO_ACCRUAL_NOT_NULL' )
23834: FROM
23835: po_req_distributions_gt PRD,
23836: po_req_lines_gt PRL,
23837: gl_sets_of_books sob
23838: WHERE
23839: PRD.requisition_line_id = PRL.requisition_line_id