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.POR_CHANGE_REQUEST_PKG dependencies on PO_REQUISITION_LINES_ALL

Line 602: FROM po_requisition_lines_all

598:
599: WHEN no_data_found THEN
600: SELECT unit_price
601: INTO unit_price
602: FROM po_requisition_lines_all
603: WHERE
604: requisition_line_id = reqlineid;
605:
606: RETURN unit_price;

Line 631: po_requisition_lines_all prl,

627:
628: SELECT MIN(pcr.change_request_group_id)
629: INTO grp_id
630: FROM
631: po_requisition_lines_all prl,
632: po_change_requests pcr
633: WHERE
634: pcr.document_header_id = prl.requisition_header_id
635: AND prl.requisition_line_id = reqlineid

Line 690: po_requisition_lines_all prl,

686:
687: SELECT MIN(pcr.change_request_group_id)
688: INTO grp_id
689: FROM
690: po_requisition_lines_all prl,
691: po_change_requests pcr
692: WHERE
693: pcr.document_header_id = prl.requisition_header_id
694: AND prl.requisition_line_id = reqlineid

Line 704: po_requisition_lines_all prl

700: -- get matching basis
701: SELECT prl.matching_basis
702: INTO matching_basis
703: FROM
704: po_requisition_lines_all prl
705: WHERE
706: prl.requisition_line_id = reqlineid;
707:
708:

Line 765: po_requisition_lines_all prl,

761:
762: SELECT MIN(pcr.change_request_group_id)
763: INTO grp_id
764: FROM
765: po_requisition_lines_all prl,
766: po_change_requests pcr
767: WHERE
768: pcr.document_header_id = prl.requisition_header_id
769: AND prl.requisition_line_id = reqlineid

Line 776: po_requisition_lines_all prl

772: -- get matching basis
773: SELECT prl.matching_basis
774: INTO matching_basis
775: FROM
776: po_requisition_lines_all prl
777: WHERE
778: prl.requisition_line_id = reqlineid;
779:
780: -- quantity based item

Line 833: po_requisition_lines_all prl,

829: -- get old line total
830: SELECT SUM(decode(prl.matching_basis, 'AMOUNT', prd.req_line_amount, prd.req_line_quantity * prl.unit_price))
831: INTO old_line_total
832: FROM
833: po_requisition_lines_all prl,
834: po_req_distributions prd
835: WHERE
836: prl.requisition_line_id = reqlineid AND
837: prl.requisition_line_id = prd.requisition_line_id;

Line 869: po_requisition_lines_all prl,

865: -- get old line total
866: SELECT SUM(decode(prl.matching_basis, 'AMOUNT', prd.req_line_amount, prd.req_line_quantity * prl.unit_price))
867: INTO old_line_total
868: FROM
869: po_requisition_lines_all prl,
870: po_req_distributions_all prd
871: WHERE
872: prl.requisition_line_id = reqlineid AND
873: prl.requisition_line_id = prd.requisition_line_id;

Line 1034: po_requisition_lines_all prl,

1030:
1031: SELECT MIN(pcr.change_request_group_id)
1032: INTO grp_id
1033: FROM
1034: po_requisition_lines_all prl,
1035: po_change_requests pcr
1036: WHERE
1037: pcr.document_header_id = prl.requisition_header_id
1038: AND prl.requisition_line_id = reqlineid

Line 1043: FROM po_requisition_lines_all prl

1039: AND pcr.request_status = 'SYSTEMSAVE';
1040:
1041: SELECT nvl(po_rcotolerance_pvt.get_new_line_quantity(prl.requisition_header_id, prl.requisition_line_id, grp_id), 0)
1042: INTO changed_quantity
1043: FROM po_requisition_lines_all prl
1044: WHERE prl.requisition_line_id = reqlineid ;
1045:
1046: RETURN changed_quantity;
1047:

Line 1064: FROM po_requisition_lines_all

1060: BEGIN
1061:
1062: SELECT matching_basis
1063: INTO matching_basis
1064: FROM po_requisition_lines_all
1065: WHERE requisition_line_id = reqlineid;
1066:
1067: IF (matching_basis = 'QUANTITY') THEN
1068: RETURN (nvl(nvl(get_price_break_price(reqlineid, chgreqgrpid), get_hist_changed_line_price(reqlineid, chgreqgrpid)), nvl(get_hist_line_price(reqlineid, chgreqgrpid), 0)) *

Line 1119: FROM po_requisition_lines_all

1115: BEGIN
1116:
1117: SELECT matching_basis
1118: INTO matching_basis
1119: FROM po_requisition_lines_all
1120: WHERE requisition_line_id = reqlineid;
1121:
1122: IF (matching_basis = 'QUANTITY') THEN
1123: RETURN nvl(get_hist_line_price(reqlineid, chgreqgrpid), 0) * get_hist_line_qty(reqlineid, chgreqgrpid);

Line 1189: FROM po_requisition_lines_all

1185: EXCEPTION
1186: WHEN OTHERS THEN
1187:
1188: SELECT rate INTO l_req_rate
1189: FROM po_requisition_lines_all
1190: WHERE requisition_line_id = reqlineid;
1191:
1192: IF (l_req_rate IS NOT NULL ) THEN
1193:

Line 1236: FROM po_requisition_lines_all

1232: END IF;
1233:
1234: -- if req is created in txn currency, need to convert with rate
1235: SELECT rate INTO l_req_rate
1236: FROM po_requisition_lines_all
1237: WHERE requisition_line_id = reqlineid;
1238:
1239: IF (l_req_rate IS NOT NULL) THEN
1240: RETURN cur_line_price / l_req_rate;

Line 1276: FROM po_requisition_lines_all

1272: EXCEPTION
1273: WHEN no_data_found THEN
1274: SELECT quantity
1275: INTO line_qty
1276: FROM po_requisition_lines_all
1277: WHERE requisition_line_id = reqlineid;
1278:
1279: RETURN line_qty;
1280:

Line 1488: FROM po_requisition_lines_all

1484: EXCEPTION
1485: WHEN no_data_found THEN
1486: SELECT amount
1487: INTO amount
1488: FROM po_requisition_lines_all
1489: WHERE requisition_line_id = reqlineid;
1490:
1491: RETURN amount;
1492:

Line 1510: FROM po_requisition_lines_all

1506: BEGIN
1507:
1508: SELECT matching_basis
1509: INTO matching_basis
1510: FROM po_requisition_lines_all
1511: WHERE requisition_line_id = reqlineid;
1512:
1513: IF (matching_basis = 'QUANTITY') THEN
1514: RETURN nvl(get_hist_cur_line_price(reqlineid, chgreqgrpid), 0) * get_hist_line_qty(reqlineid, chgreqgrpid);

Line 1547: FROM po_requisition_lines_all

1543: EXCEPTION
1544: WHEN no_data_found THEN
1545: SELECT nvl(currency_amount, amount)
1546: INTO amount
1547: FROM po_requisition_lines_all
1548: WHERE requisition_line_id = reqlineid;
1549:
1550: RETURN amount;
1551:

Line 1590: FROM po_requisition_lines_all

1586:
1587: WHEN no_data_found THEN
1588: SELECT currency_unit_price
1589: INTO cur_unit_price
1590: FROM po_requisition_lines_all
1591: WHERE
1592: requisition_line_id = reqlineid;
1593:
1594: RETURN cur_unit_price;

Line 1613: FROM po_requisition_lines_all

1609: BEGIN
1610:
1611: SELECT matching_basis
1612: INTO matching_basis
1613: FROM po_requisition_lines_all
1614: WHERE requisition_line_id = reqlineid;
1615:
1616: IF (matching_basis = 'QUANTITY') THEN
1617: RETURN get_hist_chng_cur_line_price(reqlineid, chgreqgrpid) * get_hist_changed_line_qty(reqlineid, chgreqgrpid);

Line 1713: po_requisition_lines_all prl,

1709: --SELECT SUM(decode(prl.matching_basis, 'AMOUNT', prd.req_line_amount,prd.req_line_quantity*prl.unit_price))
1710: SELECT SUM(prd.req_line_quantity * prl.unit_price)
1711: INTO old_line_total
1712: FROM
1713: po_requisition_lines_all prl,
1714: po_req_distributions prd
1715: WHERE
1716: prl.requisition_line_id = reqlineid AND
1717: prl.requisition_line_id = prd.requisition_line_id;

Line 1750: po_requisition_lines_all prl,

1746: -- SELECT SUM(decode(prl.matching_basis, 'AMOUNT', prd.req_line_amount,prd.req_line_quantity*prl.unit_price))
1747: SELECT SUM(prd.req_line_quantity * prl.unit_price)
1748: INTO old_line_total
1749: FROM
1750: po_requisition_lines_all prl,
1751: po_req_distributions_all prd
1752: WHERE
1753: prl.requisition_line_id = reqlineid AND
1754: prl.requisition_line_id = prd.requisition_line_id;