APPS.POR_CHANGE_REQUEST_PKG dependencies on PO_REQ_DISTRIBUTIONS

Line 404: po_req_distributions prd,

400: start_date_diff,
401: end_date_diff
402: FROM
403: po_requisition_lines prl,
404: po_req_distributions prd,
405: po_line_locations_all pll,
406: po_headers_all poh,
407: po_lines_all pol,
408: po_distributions_all pod

Line 834: po_req_distributions prd

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

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 1714: po_req_distributions prd

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

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: