eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_REQ_DISTRIBUTIONS

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 6148: PO_REQ_DISTRIBUTIONS_ALL PRD --

6144: FROM PO_REQUISITION_LINES_ALL PRL, --
6145: PO_LINE_LOCATIONS_GT POLL,
6146: PO_LINES POL,
6147: PO_DISTRIBUTIONS PD,
6148: PO_REQ_DISTRIBUTIONS_ALL PRD --
6149: WHERE POLL.line_location_id = p_line_location_id
6150: AND POLL.po_line_id = POL.po_line_id
6151: AND PRL.unit_price >= 0
6152: AND POLL.line_location_id = PD.line_location_id

Line 6170: PO_REQ_DISTRIBUTIONS_ALL PRD --

6166: FROM PO_REQUISITION_LINES_ALL PRL, --
6167: PO_LINE_LOCATIONS_GT POLL,
6168: PO_LINES POL,
6169: PO_DISTRIBUTIONS PD,
6170: PO_REQ_DISTRIBUTIONS_ALL PRD --
6171: WHERE POLL.line_location_id = p_line_location_id
6172: AND POLL.po_line_id = POL.po_line_id
6173: AND PRL.unit_price >= 0
6174: AND POLL.line_location_id = PD.line_location_id

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 15926: FROM po_req_distributions PRD, po_requisition_lines PRL

15922: PRD.RECOVERY_RATE ,
15923: PRD.TAX_RECOVERY_OVERRIDE_FLAG ,
15924: PRD.OKE_CONTRACT_LINE_ID ,
15925: PRD.OKE_CONTRACT_DELIVERABLE_ID
15926: FROM po_req_distributions PRD, po_requisition_lines PRL
15927: WHERE PRD.requisition_line_id = PRL.requisition_line_id AND
15928: PRL.requisition_header_id = p_document_id;
15929:
15930: l_progress := '001';

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

Line 25824: po_req_distributions_all PRD,

25820: POL.line_num_display,
25821: POLL.shipment_num,
25822: POD.distribution_num
25823: FROM po_distributions_gt POD,
25824: po_req_distributions_all PRD,
25825: po_requisition_lines_all PRL,
25826: po_requisition_headers_all PRH,
25827: po_line_locations_gt POLL,
25828: po_lines_gt POL