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_CHANGE_REQUESTS

Line 526: FROM po_change_requests

522: nvl(cancel_flag, 'N') = 'N' AND
523: nvl(modified_by_agent_flag, 'N') = 'N' AND
524: requisition_line_id NOT IN
525: (SELECT DISTINCT document_line_id
526: FROM po_change_requests
527: WHERE document_header_id = reqheaderid
528: AND request_level = 'LINE'
529: AND action_type = 'CANCELLATION');
530:

Line 557: FROM po_change_requests

553: WHERE
554: requisition_header_id = reqheaderid
555: AND requisition_line_id NOT IN
556: (SELECT DISTINCT document_line_id
557: FROM po_change_requests
558: WHERE document_header_id = reqheaderid
559: AND request_level = 'LINE'
560: AND action_type = 'CANCELLATION');
561:

Line 572: * unit price change exist in po_change_requests table, it returns *

568:
569:
570: /**************************************************************************
571: * This function returns unit price of a given line. If there is any *
572: * unit price change exist in po_change_requests table, it returns *
573: * that value otherwise returns unit_price from po_requisition_lines *
574: **************************************************************************/
575: FUNCTION get_unit_price(reqlineid NUMBER, chgreqgrpid IN NUMBER)
576: RETURN NUMBER IS

Line 586: FROM po_change_requests

582: IF (unit_price IS NULL) THEN
583:
584: SELECT new_price
585: INTO unit_price
586: FROM po_change_requests
587: WHERE
588: document_line_id = reqlineid AND
589: document_type = 'REQ' AND
590: action_type = 'MODIFICATION' AND

Line 632: po_change_requests pcr

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
636: AND pcr.request_status = 'SYSTEMSAVE';

Line 645: po_change_requests

641: BEGIN
642: SELECT new_quantity
643: INTO line_qty
644: FROM
645: po_change_requests
646: WHERE
647: document_line_id = reqlineid AND
648: change_request_group_id = grp_id AND
649: document_type = 'REQ' AND

Line 691: po_change_requests pcr

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
695: AND pcr.request_status = 'SYSTEMSAVE';

Line 766: po_change_requests pcr

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
770: AND pcr.request_status = 'SYSTEMSAVE';

Line 910: po_change_requests pcr

906:
907: CURSOR status_cursor(groupid NUMBER, documentlineid NUMBER) IS
908: SELECT DISTINCT(request_status)
909: FROM
910: po_change_requests pcr
911: WHERE
912: pcr.document_type = 'REQ' AND
913: pcr.document_line_id = documentlineid AND
914: pcr.action_type IN ('MODIFICATION', 'CANCELLATION') AND

Line 974: po_change_requests pcr

970:
971: CURSOR status_cursor(groupid NUMBER, documentlineid NUMBER) IS
972: SELECT DISTINCT(request_status)
973: FROM
974: po_change_requests pcr
975: WHERE
976: pcr.document_type = 'REQ' AND
977: pcr.document_line_id = documentlineid AND
978: pcr.action_type IN ('MODIFICATION', 'CANCELLATION') AND

Line 1035: po_change_requests pcr

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
1039: AND pcr.request_status = 'SYSTEMSAVE';

Line 1091: FROM po_change_requests

1087: BEGIN
1088:
1089: SELECT new_price
1090: INTO new_price
1091: FROM po_change_requests
1092: WHERE
1093: change_request_group_id = chgreqgrpid AND
1094: document_line_id = reqlineid AND
1095: document_type = 'REQ' AND

Line 1146: po_change_requests

1142:
1143: SELECT DISTINCT(old_price)
1144: INTO line_price
1145: FROM
1146: po_change_requests
1147: WHERE
1148: document_line_id = reqlineid AND
1149: change_request_group_id = chgreqgrpid AND
1150: document_type = 'REQ' AND

Line 1176: po_change_requests

1172:
1173: SELECT DISTINCT(old_currency_unit_price)
1174: INTO cur_line_price
1175: FROM
1176: po_change_requests
1177: WHERE
1178: document_line_id = reqlineid AND
1179: change_request_group_id = chgreqgrpid AND
1180: document_type = 'REQ' AND

Line 1217: po_change_requests

1213:
1214: SELECT DISTINCT(new_currency_unit_price)
1215: INTO cur_line_price
1216: FROM
1217: po_change_requests
1218: WHERE
1219: document_line_id = reqlineid AND
1220: change_request_group_id = chgreqgrpid AND
1221: document_type = 'REQ' AND

Line 1262: po_change_requests

1258:
1259: SELECT old_quantity
1260: INTO line_qty
1261: FROM
1262: po_change_requests
1263: WHERE
1264: document_line_id = reqlineid AND
1265: change_request_group_id = chgreqgrpid AND
1266: document_type = 'REQ' AND

Line 1299: po_change_requests

1295:
1296: SELECT new_quantity
1297: INTO line_qty
1298: FROM
1299: po_change_requests
1300: WHERE
1301: document_line_id = reqlineid AND
1302: change_request_group_id = chgreqgrpid AND
1303: document_type = 'REQ' AND

Line 1316: * This function returns the price break price from po_change_requests *

1312: END get_hist_changed_line_qty;
1313:
1314:
1315: /**************************************************************************
1316: * This function returns the price break price from po_change_requests *
1317: * for a given requisition line id and change request group id *
1318: * if there is no price break price, it returns NULL *
1319: **************************************************************************/
1320: FUNCTION get_price_break_price(reqlineid IN NUMBER, chgreqgrpid IN NUMBER)

Line 1328: po_change_requests

1324:
1325: SELECT new_price
1326: INTO new_price
1327: FROM
1328: po_change_requests
1329: WHERE
1330: document_line_id = reqlineid AND
1331: change_request_group_id = chgreqgrpid AND
1332: document_type = 'REQ' AND

Line 1344: * This function returns the price break price from po_change_requests *

1340:
1341: END get_price_break_price;
1342:
1343: /**************************************************************************
1344: * This function returns the price break price from po_change_requests *
1345: * for a given requisition line id and change request group id *
1346: * if there is no price break price, it returns NULL *
1347: **************************************************************************/
1348: FUNCTION get_price_break_cur_price(reqlineid IN NUMBER, chgreqgrpid IN NUMBER)

Line 1356: po_change_requests

1352:
1353: SELECT new_currency_unit_price
1354: INTO new_cur_price
1355: FROM
1356: po_change_requests
1357: WHERE
1358: document_line_id = reqlineid AND
1359: change_request_group_id = chgreqgrpid AND
1360: document_type = 'REQ' AND

Line 1373: * po_change_requests *

1369: END get_price_break_cur_price;
1370:
1371: /**************************************************************************
1372: * This function returns the price break currency unit price from *
1373: * po_change_requests *
1374: * for a given requisition line id and change request group id *
1375: * if there is no price break price, it returns NULL *
1376: **************************************************************************/
1377: FUNCTION get_price_break_trx_price(reqlineid IN NUMBER, chgreqgrpid IN NUMBER)

Line 1385: po_change_requests

1381:
1382: SELECT nvl(new_currency_unit_price, new_price)
1383: INTO new_price
1384: FROM
1385: po_change_requests
1386: WHERE
1387: document_line_id = reqlineid AND
1388: change_request_group_id = chgreqgrpid AND
1389: document_type = 'REQ' AND

Line 1411: FROM po_change_requests

1407: chggroupid NUMBER := 0;
1408: BEGIN
1409: SELECT MAX(change_request_group_id)
1410: INTO chggroupid
1411: FROM po_change_requests
1412: WHERE document_header_id = reqheaderid AND
1413: document_type = 'REQ';
1414:
1415: RETURN get_hist_changed_line_qty(reqlineid, chggroupid);

Line 1429: FROM po_change_requests

1425: chggroupid NUMBER := 0;
1426: BEGIN
1427: SELECT MAX(change_request_group_id)
1428: INTO chggroupid
1429: FROM po_change_requests
1430: WHERE document_header_id = reqheaderid AND
1431: document_type = 'REQ';
1432:
1433: RETURN get_hist_changed_line_amount(reqlineid, chggroupid);

Line 1447: FROM po_change_requests

1443: amount NUMBER := 0;
1444: BEGIN
1445: SELECT new_amount
1446: INTO amount
1447: FROM po_change_requests
1448: WHERE
1449: document_line_id = reqlineid AND
1450: change_request_group_id = chgreqgrpid AND
1451: document_type = 'REQ' AND

Line 1474: FROM po_change_requests

1470: amount NUMBER := 0;
1471: BEGIN
1472: SELECT old_amount
1473: INTO amount
1474: FROM po_change_requests
1475: WHERE
1476: document_line_id = reqlineid AND
1477: change_request_group_id = chgreqgrpid AND
1478: document_type = 'REQ' AND

Line 1533: FROM po_change_requests

1529: amount NUMBER := 0;
1530: BEGIN
1531: SELECT old_currency_amount
1532: INTO amount
1533: FROM po_change_requests
1534: WHERE
1535: document_line_id = reqlineid AND
1536: change_request_group_id = chgreqgrpid AND
1537: document_type = 'REQ' AND

Line 1559: * If there is any currency unit price change exist in po_change_requests *

1555: END get_hist_cur_line_amount;
1556:
1557: /**************************************************************************
1558: * This function returns currency unit price of a given line. *
1559: * If there is any currency unit price change exist in po_change_requests *
1560: * table, it returns that value otherwise returns currency_unit_price *
1561: * from po_requisition_lines *
1562: **************************************************************************/
1563: FUNCTION get_currency_unit_price(reqlineid NUMBER, chgreqgrpid IN NUMBER)

Line 1574: FROM po_change_requests

1570: IF (cur_unit_price IS NULL) THEN
1571:
1572: SELECT new_currency_unit_price
1573: INTO cur_unit_price
1574: FROM po_change_requests
1575: WHERE
1576: document_line_id = reqlineid AND
1577: document_type = 'REQ' AND
1578: action_type = 'MODIFICATION' AND

Line 1636: FROM po_change_requests

1632: amount NUMBER := 0;
1633: BEGIN
1634: SELECT new_currency_amount
1635: INTO amount
1636: FROM po_change_requests
1637: WHERE
1638: document_line_id = reqlineid AND
1639: change_request_group_id = chgreqgrpid AND
1640: document_type = 'REQ' AND

Line 1662: FROM po_change_requests

1658: BEGIN
1659:
1660: SELECT old_currency_amount
1661: INTO amount
1662: FROM po_change_requests
1663: WHERE
1664: document_distribution_id = reqdistid AND
1665: change_request_group_id = chgreqgrpid AND
1666: document_type = 'REQ';

Line 1682: FROM po_change_requests

1678: amount NUMBER := 0;
1679: BEGIN
1680: SELECT new_currency_amount
1681: INTO amount
1682: FROM po_change_requests
1683: WHERE
1684: document_distribution_id = reqdistid AND
1685: change_request_group_id = chgreqgrpid AND
1686: document_type = 'REQ';