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_RCO_VALIDATION_PVT dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 242: FROM po_req_distributions_all

238: AND request_level = 'DISTRIBUTION';
239:
240: SELECT nvl(SUM(req_line_quantity), 0)
241: INTO l_old_qty
242: FROM po_req_distributions_all
243: WHERE requisition_line_id = l_req_line_id
244: AND distribution_id NOT IN(SELECT document_distribution_id
245: FROM po_change_requests
246: WHERE new_quantity IS NOT NULL

Line 474: FROM po_req_distributions_all

470: AND new_amount IS NOT NULL
471: AND request_level = 'DISTRIBUTION'
472: UNION ALL
473: SELECT req_line_amount amount
474: FROM po_req_distributions_all
475: WHERE requisition_line_id = l_line_id
476: AND distribution_id NOT IN
477: (SELECT document_distribution_id
478: FROM po_change_requests

Line 496: FROM po_req_distributions_all

492: AND new_currency_amount IS NOT NULL
493: AND request_level = 'DISTRIBUTION'
494: UNION ALL
495: SELECT req_line_currency_amount amount
496: FROM po_req_distributions_all
497: WHERE requisition_line_id = l_line_id
498: AND distribution_id NOT IN
499: (SELECT document_distribution_id
500: FROM po_change_requests

Line 535: FROM po_req_distributions_all

531: AND new_quantity IS NOT NULL
532: AND request_level = 'DISTRIBUTION'
533: UNION ALL
534: SELECT req_line_quantity quantity
535: FROM po_req_distributions_all
536: WHERE requisition_line_id = l_line_id
537: AND distribution_id NOT IN
538: (SELECT document_distribution_id
539: FROM po_change_requests

Line 697: po_req_distributions_all prda

693: po_lines_all pla,
694: po_line_locations_all plla,
695: po_distributions_all pda,
696: po_requisition_lines_all prla,
697: po_req_distributions_all prda
698: WHERE
699: pla.po_header_id = p_header_id
700: AND pla.po_line_id = p_po_change_table(s).document_line_id
701: AND plla.po_line_id = pla.po_line_id

Line 723: po_req_distributions_all prda

719: FROM
720: po_line_locations_all plla,
721: po_distributions_all pda,
722: po_requisition_lines_all prla,
723: po_req_distributions_all prda
724: WHERE
725: plla.po_release_id = p_release_id
726: AND plla.line_location_id = p_po_change_table(s).document_line_location_id
727: AND pda.line_location_id = plla.line_location_id

Line 794: po_req_distributions_all prda

790: po_lines_all pla,
791: po_line_locations_all plla,
792: po_distributions_all pda,
793: po_requisition_lines_all prla,
794: po_req_distributions_all prda
795: WHERE
796: pla.po_header_id = p_header_id
797: AND pla.po_line_id = p_po_change_table(s).document_line_id
798: AND plla.po_line_id = pla.po_line_id

Line 820: po_req_distributions_all prda

816: FROM
817: po_line_locations_all plla,
818: po_distributions_all pda,
819: po_requisition_lines_all prla,
820: po_req_distributions_all prda
821: WHERE
822: plla.po_release_id = p_release_id
823: AND plla.line_location_id = p_po_change_table(s).document_line_location_id
824: AND pda.line_location_id = plla.line_location_id

Line 1787: po_req_distributions_all prd

1783: l_rec_tax,
1784: l_nonrec_tax
1785: FROM
1786: po_requisition_lines_all prl,
1787: po_req_distributions_all prd
1788: WHERE prd.distribution_id = p_dist_id
1789: AND prd.requisition_line_id = prl.requisition_line_id;
1790:
1791: -- Calcualte new tax only if existing total tax amount is

Line 1860: FROM po_req_distributions_all

1856: CURSOR l_dist_id_csr(line_id NUMBER) IS
1857: SELECT
1858: distribution_id,
1859: req_line_quantity
1860: FROM po_req_distributions_all
1861: WHERE requisition_line_id = l_line_id;
1862:
1863:
1864: CURSOR l_dist_exist_chn_csr(dist_id NUMBER, grp_id NUMBER) IS

Line 1910: FROM po_req_distributions_all

1906: calculate_disttax(1.0, l_cal_disttax_status, l_dist_id, l_price, l_new_quantity, NULL, l_rec_tax, l_nonrec_tax);
1907: ELSE
1908: SELECT req_line_quantity
1909: INTO l_quantity
1910: FROM po_req_distributions_all
1911: WHERE distribution_id = l_dist_id;
1912: calculate_disttax(1.0, l_cal_disttax_status, l_dist_id, l_price, l_quantity, NULL, l_rec_tax, l_nonrec_tax);
1913: END IF;
1914: UPDATE po_change_requests

Line 2014: FROM po_req_distributions_all

2010: CURSOR l_dist_id_csr(line_id NUMBER) IS
2011: SELECT
2012: distribution_id,
2013: req_line_quantity
2014: FROM po_req_distributions_all
2015: WHERE requisition_line_id = l_line_id;
2016:
2017:
2018: CURSOR l_dist_exist_chn_csr(dist_id NUMBER, grp_id NUMBER) IS

Line 2246: po_req_distributions_all prda,

2242: FROM
2243: po_headers_all pha,
2244: po_lines_all pla,
2245: po_line_locations_all plla,
2246: po_req_distributions_all prda,
2247: po_requisition_lines_all prla,
2248: po_requisition_headers_all prha,
2249: po_distributions_all pda
2250: WHERE

Line 2418: po_req_distributions_all prda,

2414: po_releases_all pra,
2415: po_lines_all pla,
2416: po_line_locations_all plla,
2417: po_distributions_all pda,
2418: po_req_distributions_all prda,
2419: po_requisition_lines_all prla,
2420: po_requisition_headers_all prha
2421: WHERE
2422: prda.distribution_id = req_change_record_tbl(req_index).document_distribution_id

Line 2894: po_req_distributions_all prda,

2890: IF (p_origin IS NULL) THEN
2891: SELECT COUNT(DISTINCT nvl(prda.requisition_line_id, - 1))
2892: INTO l_count
2893: FROM
2894: po_req_distributions_all prda,
2895: po_distributions_all pda,
2896: po_requisition_lines_all prla
2897: WHERE pda.line_location_id = prla.line_location_id
2898: AND prla.requisition_line_id = p_req_line_id

Line 3620: po_req_distributions_all prda,

3616: l_progress := '004';
3617: SELECT COUNT(DISTINCT nvl(prda.requisition_line_id, - 1))
3618: INTO l_count
3619: FROM
3620: po_req_distributions_all prda,
3621: po_distributions_all pda,
3622: po_requisition_lines_all prla
3623: WHERE pda.line_location_id = prla.line_location_id
3624: AND prla.requisition_line_id = p_req_line_id

Line 3773: FROM po_req_distributions_all

3769: IF(p_change_table.req_dist_id(x) IS NULL) THEN
3770: BEGIN
3771: SELECT distribution_id
3772: INTO l_req_dist_id
3773: FROM po_req_distributions_all
3774: WHERE requisition_line_id = p_change_table.req_line_id(x);
3775: l_req_change_table(y).document_line_id := p_change_table.req_line_id(x);
3776: l_req_change_table(y).document_distribution_id := l_req_dist_id;
3777: l_req_change_table(y).new_budget_amount := p_change_table.amount(x);

Line 3821: FROM po_req_distributions_all

3817: IF(p_change_table.req_dist_id(x) IS NULL) THEN
3818: BEGIN
3819: SELECT distribution_id
3820: INTO l_req_dist_id
3821: FROM po_req_distributions_all
3822: WHERE requisition_line_id = p_change_table.req_line_id(x);
3823: l_req_change_table(y).document_line_id := p_change_table.req_line_id(x);
3824: l_req_change_table(y).document_distribution_id := l_req_dist_id;
3825: l_req_change_table(y).new_quantity := p_change_table.quantity(x);

Line 4228: po_req_distributions_all prda,

4224: prda.distribution_id dist_id,
4225: prla.requisition_header_id hdr_id,
4226: prha.segment1 req_num
4227: FROM
4228: po_req_distributions_all prda,
4229: po_requisition_lines_all prla,
4230: po_change_requests pcr,
4231: po_requisition_headers_all prha
4232: WHERE

Line 4246: po_req_distributions_all prda,

4242: SELECT -- any quantity or amount change
4243: pda.po_distribution_id
4244: FROM
4245: po_change_requests pcr,
4246: po_req_distributions_all prda,
4247: po_distributions_all pda,
4248: po_headers_all pha
4249: WHERE
4250: pcr.change_request_group_id = grp_id AND

Line 4263: po_req_distributions_all prda,

4259: pda.po_distribution_id
4260: FROM
4261: po_change_requests pcr,
4262: po_requisition_lines_all prla,
4263: po_req_distributions_all prda,
4264: po_distributions_all pda,
4265: po_headers_all pha
4266: WHERE
4267: pcr.change_request_group_id = grp_id AND

Line 4282: po_req_distributions_all prda,

4278: SELECT -- any quantity or amount change
4279: pda.po_distribution_id
4280: FROM
4281: po_change_requests pcr,
4282: po_req_distributions_all prda,
4283: po_distributions_all pda,
4284: po_requisition_lines_all prla,
4285: po_line_locations_all plla
4286: WHERE

Line 4301: po_req_distributions_all prda,

4297: pda.po_distribution_id
4298: FROM
4299: po_change_requests pcr,
4300: po_requisition_lines_all prla,
4301: po_req_distributions_all prda,
4302: po_distributions_all pda,
4303: po_line_locations_all plla
4304: WHERE
4305: pcr.change_request_group_id = grp_id AND

Line 4474: po_req_distributions_all prda,

4470: l_old_need_by_date,
4471: l_ship_to_org_id,
4472: l_ship_to_loc_id
4473: FROM
4474: po_req_distributions_all prda,
4475: po_requisition_lines_all prla,
4476: po_line_locations_all plla,
4477: po_distributions_all pda,
4478: po_lines_all pla,

Line 4729: po_req_distributions_all prda,

4725: l_fc_req_line_id,
4726: l_fc_req_line_num
4727: FROM
4728: po_requisition_lines_all prla,
4729: po_req_distributions_all prda,
4730: po_distributions_all pda
4731: WHERE
4732: pda.po_distribution_id = l_fc_out_tbl.distribution_id(x)
4733: AND pda.req_distribution_id = prda.distribution_id

Line 5669: po_req_distributions_all prda

5665: l_preparer_id
5666: FROM
5667: po_requisition_lines_all prla,
5668: po_requisition_headers_all prha,
5669: po_req_distributions_all prda
5670: WHERE
5671: prha.requisition_header_id = p_req_hdr_id
5672: AND prha.requisition_header_id = prla.requisition_header_id
5673: AND prla.requisition_line_id = p_change_table.req_line_id(x)

Line 6320: po_req_distributions_all prda,

6316: prda.distribution_id dist_id,
6317: prla.requisition_header_id hdr_id,
6318: prha.segment1 req_num
6319: FROM
6320: po_req_distributions_all prda,
6321: po_requisition_lines_all prla,
6322: po_change_requests pcr,
6323: po_requisition_headers_all prha
6324: WHERE

Line 6350: po_req_distributions_all prda

6346: SELECT -- any quantity or amount change
6347: prda.distribution_id
6348: FROM
6349: po_change_requests pcr,
6350: po_req_distributions_all prda
6351: WHERE
6352: pcr.change_request_group_id = grp_id AND
6353: pcr.new_quantity IS NOT NULL AND
6354: pcr.action_type = 'MODIFICATION' AND

Line 6362: po_req_distributions_all prda

6358: prda.distribution_id
6359: FROM
6360: po_change_requests pcr,
6361: po_requisition_lines_all prla,
6362: po_req_distributions_all prda
6363: WHERE
6364: pcr.change_request_group_id = grp_id AND
6365: pcr.action_type = 'MODIFICATION' AND
6366: pcr.new_need_by_date IS NOT NULL AND

Line 6380: po_req_distributions_all prda,

6376: prla.unit_price,
6377: nvl(pcr.new_quantity, pcr.old_quantity)
6378: FROM
6379: po_change_requests pcr,
6380: po_req_distributions_all prda,
6381: po_requisition_lines_all prla
6382: WHERE
6383: pcr.change_request_group_id = grp_id AND
6384: pcr.new_quantity IS NOT NULL AND

Line 6648: po_req_distributions_all prda,

6644: l_fc_req_line_id,
6645: l_fc_req_line_num
6646: FROM
6647: po_requisition_lines_all prla,
6648: po_req_distributions_all prda,
6649: po_distributions_all pda
6650: WHERE
6651: pda.po_distribution_id = l_fc_out_tbl.distribution_id(x)
6652: AND pda.req_distribution_id = prda.distribution_id