APPS.PO_RCOTOLERANCE_PVT dependencies on PO_REQ_DISTRIBUTIONS

Line 21: * Effects: Get revised line quantity from po_req_distributions and po_change_requests.

17: * Requisition Header Id
18: * Requisition Line Id
19: * Change Request Group Id
20: * Modifies: None.
21: * Effects: Get revised line quantity from po_req_distributions and po_change_requests.
22: * Returns:
23: * Revised line quantity
24: * If there is an exception returns 0
25: */

Line 39: FROM po_req_distributions prd,

35: SELECT nvl(SUM(get_new_distribution_qty(prl.requisition_header_id, p_grp_id, prl.requisition_line_id,
36: prd.distribution_id)),
37: 0)
38: INTO l_new_line_qty
39: FROM po_req_distributions prd,
40: po_requisition_lines prl
41: WHERE prl.requisition_header_id = p_req_id
42: AND prl.requisition_line_id = p_req_line_id
43: AND prl.requisition_line_id = prd.requisition_line_id

Line 59: * Else Return the req_line_quantity from po_req_distributions

55: * Change Request Group Id
56: * Requisition Line Id
57: * Modifies: None.
58: * Effects: Return updated distribution qty from po_change_requests if any
59: * Else Return the req_line_quantity from po_req_distributions
60: * If line was cancelled return 0
61: * Returns:
62: * Revised distribution quantity
63: * If something fails returns 0

Line 96: FROM po_req_distributions

92: AND request_status = 'SYSTEMSAVE';
93: ELSE
94: SELECT req_line_quantity
95: INTO l_new_qty
96: FROM po_req_distributions
97: WHERE distribution_id = p_req_dist_id;
98: END IF;
99:
100: RETURN l_new_qty;

Line 681: po_req_distributions_all prd

677: WHERE EXISTS (SELECT 'N'
678: FROM po_change_requests pcr,
679: po_change_requests pcr1,
680: po_requisition_lines_all prl,
681: po_req_distributions_all prd
682: WHERE prd.requisition_line_id = prl.requisition_line_id
683: AND pcr.change_request_group_id = p_reqgrp_id
684: AND pcr.action_type (+ ) = 'MODIFICATION'
685: AND pcr.request_status (+ ) NOT IN ('ACCEPTED',

Line 749: po_req_distributions_all prd

745: INTO l_return_val
746: FROM po_change_requests pcr,
747: po_change_requests pcr1,
748: po_requisition_lines_all prl,
749: po_req_distributions_all prd
750: WHERE prl.requisition_line_id = prd.requisition_line_id
751: AND pcr.change_request_group_id (+ ) = p_reqgrp_id
752: AND pcr.action_type (+ ) = 'MODIFICATION'
753: AND pcr.request_status (+ ) NOT IN ('ACCEPTED',