APPS.ICX_REQ_COPY_REQ dependencies on PO_REQ_DISTRIBUTIONS

Line 863: FROM po_req_distributions rd,

859: v_org_id,
860: nvl(rd.allocation_type, 'PERCENT'),
861: nvl(rd.allocation_value, round(rd.req_line_quantity / rl.quantity * 100, 5)),
862: rd.req_line_quantity
863: FROM po_req_distributions rd,
864: po_requisition_lines rl
865: WHERE rd.requisition_line_id = prec.requisition_line_id
866: AND rl.requisition_header_id = l_req_header_id
867: AND rl.requisition_line_id = rd.requisition_line_id;

Line 888: -- available from po_req_distributions table.

884: AND distribution_id = distribution.distribution_id;
885:
886: -- Update the invidual segments from the account id.
887: -- This need to done because the invidual segments are not
888: -- available from po_req_distributions table.
889: icx_req_acct2.update_account_by_id( v_cart_id => v_cart_id,
890: v_cart_line_id => v_cart_line_id,
891: v_oo_id => v_org_id,
892: v_distribution_id => distribution.distribution_id,