212: PORD.distribution_id))
213: into l_req_total
214: FROM
215: PO_REQ_DISTRIBUTIONS_ALL PORD, --
216: PO_REQUISITION_LINES PORL
217: WHERE PORL.requisition_header_id = ReqHeaderId
218: AND PORL.requisition_line_id = PORD.requisition_line_id
219: AND nvl(PORL.cancel_flag, 'N') = 'N'
220: AND nvl(PORL.modified_by_agent_flag, 'N') = 'N';