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_REQ_DISTRIBUTIONS_ALL

Line 870: po_req_distributions_all prd

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;
874:

Line 1013: FROM po_req_distributions_all

1009: no_of_values NUMBER := 0;
1010: BEGIN
1011: SELECT COUNT(distribution_id)
1012: INTO no_of_values
1013: FROM po_req_distributions_all
1014: WHERE requisition_line_id = req_line_id;
1015:
1016: IF (no_of_values > 1) THEN
1017: RETURN 'MULTIPLE_VALUE';

Line 1751: po_req_distributions_all prd

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;
1755: