APPS.PO_CALCULATEREQTOTAL_PVT dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 38: po_req_distributions_all prd,

34: pcr.change_request_group_id
35: INTO l_matching_basis, l_action_type, l_dist_total,
36: l_change_request_group_id
37: FROM po_requisition_lines_all prl,
38: po_req_distributions_all prd,
39: po_change_requests pcr
40: WHERE prl.requisition_line_id = p_line_id
41: AND prl.requisition_line_id = prd.requisition_line_id
42: AND prd.distribution_id = p_distribution_id

Line 108: po_req_distributions_all prd,

104: pcr.change_request_group_id
105: INTO l_matching_basis, l_action_type, l_dist_total,
106: l_change_request_group_id
107: FROM po_requisition_lines_all prl,
108: po_req_distributions_all prd,
109: po_change_requests pcr
110: WHERE prl.requisition_line_id = p_line_id
111: AND prl.requisition_line_id = prd.requisition_line_id
112: AND prd.distribution_id = p_distribution_id

Line 171: po_req_distributions_all prd

167: nvl(pcr.new_amount, prd.req_line_amount),
168: prd.nonrecoverable_tax
169: INTO l_old_dist_total, l_new_dist_total, l_nonrec_tax
170: FROM po_change_requests pcr,
171: po_req_distributions_all prd
172: WHERE prd.distribution_id = p_distribution_id
173: AND pcr.document_line_id(+) = prd.requisition_line_id
174: AND pcr.document_distribution_id(+) = prd.distribution_id
175: AND pcr.request_status(+) NOT IN ('ACCEPTED','REJECTED');

Line 187: po_req_distributions_all prd

183: INTO l_old_dist_total, l_new_dist_total, l_nonrec_tax
184: FROM po_change_requests pcr,
185: po_change_requests pcr1,
186: po_requisition_lines_all prl,
187: po_req_distributions_all prd
188: WHERE prd.distribution_id = p_distribution_id
189: AND pcr1.document_distribution_id(+) = prd.distribution_id
190: AND pcr1.document_line_id(+) = prd.requisition_line_id
191: AND pcr1.request_status(+) NOT IN ('ACCEPTED','REJECTED')