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 684: po_req_distributions_all prd

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

Line 752: po_req_distributions_all prd

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