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 1750: po_req_distributions_all prd

1746: l_rec_tax,
1747: l_nonrec_tax
1748: FROM
1749: po_requisition_lines_all prl,
1750: po_req_distributions_all prd
1751: WHERE prd.distribution_id = p_dist_id
1752: AND prd.requisition_line_id = prl.requisition_line_id;
1753:
1754: -- Calcualte new tax only if existing total tax amount is

Line 1823: FROM po_req_distributions_all

1819: CURSOR l_dist_id_csr(line_id NUMBER) IS
1820: SELECT
1821: distribution_id,
1822: req_line_quantity
1823: FROM po_req_distributions_all
1824: WHERE requisition_line_id = l_line_id;
1825:
1826:
1827: CURSOR l_dist_exist_chn_csr(dist_id NUMBER, grp_id NUMBER) IS

Line 1873: FROM po_req_distributions_all

1869: calculate_disttax(1.0, l_cal_disttax_status, l_dist_id, l_price, l_new_quantity, NULL, l_rec_tax, l_nonrec_tax);
1870: ELSE
1871: SELECT req_line_quantity
1872: INTO l_quantity
1873: FROM po_req_distributions_all
1874: WHERE distribution_id = l_dist_id;
1875: calculate_disttax(1.0, l_cal_disttax_status, l_dist_id, l_price, l_quantity, NULL, l_rec_tax, l_nonrec_tax);
1876: END IF;
1877: UPDATE po_change_requests

Line 1977: FROM po_req_distributions_all

1973: CURSOR l_dist_id_csr(line_id NUMBER) IS
1974: SELECT
1975: distribution_id,
1976: req_line_quantity
1977: FROM po_req_distributions_all
1978: WHERE requisition_line_id = l_line_id;
1979:
1980:
1981: CURSOR l_dist_exist_chn_csr(dist_id NUMBER, grp_id NUMBER) IS

Line 2209: po_req_distributions_all prda,

2205: FROM
2206: po_headers_all pha,
2207: po_lines_all pla,
2208: po_line_locations_all plla,
2209: po_req_distributions_all prda,
2210: po_requisition_lines_all prla,
2211: po_requisition_headers_all prha,
2212: po_distributions_all pda
2213: WHERE

Line 2381: po_req_distributions_all prda,

2377: po_releases_all pra,
2378: po_lines_all pla,
2379: po_line_locations_all plla,
2380: po_distributions_all pda,
2381: po_req_distributions_all prda,
2382: po_requisition_lines_all prla,
2383: po_requisition_headers_all prha
2384: WHERE
2385: prda.distribution_id = req_change_record_tbl(req_index).document_distribution_id

Line 2830: po_req_distributions_all prda,

2826: IF (p_origin IS NULL) THEN
2827: SELECT COUNT(DISTINCT nvl(prda.requisition_line_id, - 1))
2828: INTO l_count
2829: FROM
2830: po_req_distributions_all prda,
2831: po_distributions_all pda,
2832: po_requisition_lines_all prla
2833: WHERE pda.line_location_id = prla.line_location_id
2834: AND prla.requisition_line_id = p_req_line_id

Line 3539: po_req_distributions_all prda,

3535: l_progress := '004';
3536: SELECT COUNT(DISTINCT nvl(prda.requisition_line_id, - 1))
3537: INTO l_count
3538: FROM
3539: po_req_distributions_all prda,
3540: po_distributions_all pda,
3541: po_requisition_lines_all prla
3542: WHERE pda.line_location_id = prla.line_location_id
3543: AND prla.requisition_line_id = p_req_line_id

Line 3692: FROM po_req_distributions_all

3688: IF(p_change_table.req_dist_id(x) IS NULL) THEN
3689: BEGIN
3690: SELECT distribution_id
3691: INTO l_req_dist_id
3692: FROM po_req_distributions_all
3693: WHERE requisition_line_id = p_change_table.req_line_id(x);
3694: l_req_change_table(y).document_line_id := p_change_table.req_line_id(x);
3695: l_req_change_table(y).document_distribution_id := l_req_dist_id;
3696: l_req_change_table(y).new_budget_amount := p_change_table.amount(x);

Line 3740: FROM po_req_distributions_all

3736: IF(p_change_table.req_dist_id(x) IS NULL) THEN
3737: BEGIN
3738: SELECT distribution_id
3739: INTO l_req_dist_id
3740: FROM po_req_distributions_all
3741: WHERE requisition_line_id = p_change_table.req_line_id(x);
3742: l_req_change_table(y).document_line_id := p_change_table.req_line_id(x);
3743: l_req_change_table(y).document_distribution_id := l_req_dist_id;
3744: l_req_change_table(y).new_quantity := p_change_table.quantity(x);

Line 4145: po_req_distributions_all prda,

4141: prda.distribution_id dist_id,
4142: prla.requisition_header_id hdr_id,
4143: prha.segment1 req_num
4144: FROM
4145: po_req_distributions_all prda,
4146: po_requisition_lines_all prla,
4147: po_change_requests pcr,
4148: po_requisition_headers_all prha
4149: WHERE

Line 4163: po_req_distributions_all prda,

4159: SELECT -- any quantity or amount change
4160: pda.po_distribution_id
4161: FROM
4162: po_change_requests pcr,
4163: po_req_distributions_all prda,
4164: po_distributions_all pda,
4165: po_headers_all pha
4166: WHERE
4167: pcr.change_request_group_id = grp_id AND

Line 4180: po_req_distributions_all prda,

4176: pda.po_distribution_id
4177: FROM
4178: po_change_requests pcr,
4179: po_requisition_lines_all prla,
4180: po_req_distributions_all prda,
4181: po_distributions_all pda,
4182: po_headers_all pha
4183: WHERE
4184: pcr.change_request_group_id = grp_id AND

Line 4199: po_req_distributions_all prda,

4195: SELECT -- any quantity or amount change
4196: pda.po_distribution_id
4197: FROM
4198: po_change_requests pcr,
4199: po_req_distributions_all prda,
4200: po_distributions_all pda,
4201: po_requisition_lines_all prla,
4202: po_line_locations_all plla
4203: WHERE

Line 4218: po_req_distributions_all prda,

4214: pda.po_distribution_id
4215: FROM
4216: po_change_requests pcr,
4217: po_requisition_lines_all prla,
4218: po_req_distributions_all prda,
4219: po_distributions_all pda,
4220: po_line_locations_all plla
4221: WHERE
4222: pcr.change_request_group_id = grp_id AND

Line 4391: po_req_distributions_all prda,

4387: l_old_need_by_date,
4388: l_ship_to_org_id,
4389: l_ship_to_loc_id
4390: FROM
4391: po_req_distributions_all prda,
4392: po_requisition_lines_all prla,
4393: po_line_locations_all plla,
4394: po_distributions_all pda,
4395: po_lines_all pla,

Line 4593: po_req_distributions_all prda,

4589: l_fc_req_line_id,
4590: l_fc_req_line_num
4591: FROM
4592: po_requisition_lines_all prla,
4593: po_req_distributions_all prda,
4594: po_distributions_all pda
4595: WHERE
4596: pda.po_distribution_id = l_fc_out_tbl.distribution_id(x)
4597: AND pda.req_distribution_id = prda.distribution_id

Line 5511: po_req_distributions_all prda

5507: l_preparer_id
5508: FROM
5509: po_requisition_lines_all prla,
5510: po_requisition_headers_all prha,
5511: po_req_distributions_all prda
5512: WHERE
5513: prha.requisition_header_id = p_req_hdr_id
5514: AND prha.requisition_header_id = prla.requisition_header_id
5515: AND prla.requisition_line_id = p_change_table.req_line_id(x)

Line 6269: po_req_distributions_all prda,

6265: prda.distribution_id dist_id,
6266: prla.requisition_header_id hdr_id,
6267: prha.segment1 req_num
6268: FROM
6269: po_req_distributions_all prda,
6270: po_requisition_lines_all prla,
6271: po_change_requests pcr,
6272: po_requisition_headers_all prha
6273: WHERE

Line 6299: po_req_distributions_all prda

6295: SELECT -- any quantity or amount change
6296: prda.distribution_id
6297: FROM
6298: po_change_requests pcr,
6299: po_req_distributions_all prda
6300: WHERE
6301: pcr.change_request_group_id = grp_id AND
6302: pcr.new_quantity IS NOT NULL AND
6303: pcr.action_type = 'MODIFICATION' AND

Line 6311: po_req_distributions_all prda

6307: prda.distribution_id
6308: FROM
6309: po_change_requests pcr,
6310: po_requisition_lines_all prla,
6311: po_req_distributions_all prda
6312: WHERE
6313: pcr.change_request_group_id = grp_id AND
6314: pcr.action_type = 'MODIFICATION' AND
6315: pcr.new_need_by_date IS NOT NULL AND

Line 6329: po_req_distributions_all prda,

6325: prla.unit_price,
6326: nvl(pcr.new_quantity, pcr.old_quantity)
6327: FROM
6328: po_change_requests pcr,
6329: po_req_distributions_all prda,
6330: po_requisition_lines_all prla
6331: WHERE
6332: pcr.change_request_group_id = grp_id AND
6333: pcr.new_quantity IS NOT NULL AND

Line 6597: po_req_distributions_all prda,

6593: l_fc_req_line_id,
6594: l_fc_req_line_num
6595: FROM
6596: po_requisition_lines_all prla,
6597: po_req_distributions_all prda,
6598: po_distributions_all pda
6599: WHERE
6600: pda.po_distribution_id = l_fc_out_tbl.distribution_id(x)
6601: AND pda.req_distribution_id = prda.distribution_id