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

96: nvl(pcr.new_amount, prd.req_line_amount),
97: prd.nonrecoverable_tax
98: INTO l_old_dist_total, l_new_dist_total, l_nonrec_tax
99: FROM po_change_requests pcr,
100: po_req_distributions_all prd
101: WHERE prd.distribution_id = p_distribution_id
102: AND pcr.document_line_id(+) = prd.requisition_line_id
103: AND pcr.document_distribution_id(+) = prd.distribution_id
104: AND pcr.request_status(+) NOT IN ('ACCEPTED','REJECTED');

Line 116: po_req_distributions_all prd

112: INTO l_old_dist_total, l_new_dist_total, l_nonrec_tax
113: FROM po_change_requests pcr,
114: po_change_requests pcr1,
115: po_requisition_lines_all prl,
116: po_req_distributions_all prd
117: WHERE prd.distribution_id = p_distribution_id
118: AND pcr1.document_distribution_id(+) = prd.distribution_id
119: AND pcr1.document_line_id(+) = prd.requisition_line_id
120: AND pcr1.request_status(+) NOT IN ('ACCEPTED','REJECTED')