DBA Data[Home] [Help]

APPS.INV_RCV_TXN_MATCH dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 891: from po_req_distributions_all prd

887: AND Nvl(rsh.shipped_date,Nvl(v_txn_date-1,Sysdate-1)) < Nvl(v_txn_date,Sysdate)
888: AND ((rsl.source_document_code = 'REQ'
889: and exists
890: ( select '1'
891: from po_req_distributions_all prd
892: where rsl.requisition_line_id = prd.requisition_line_id
893: and Nvl(rsl.req_distribution_id,prd.distribution_id) = prd.distribution_id--BUG4930681
894: and (v_project_id is null or
895: (v_project_id = -9999 and prd.project_id is null) or -- bug2669021

Line 939: from po_req_distributions_all prd

935: --the correct rsl can be picked up
936: AND ((rsl.source_document_code = 'REQ'
937: and exists
938: ( select '1'
939: from po_req_distributions_all prd
940: where rsl.requisition_line_id = prd.requisition_line_id
941: and Nvl(rsl.req_distribution_id,prd.distribution_id) = prd.distribution_id--BUG4930681
942: and (v_project_id is null or
943: (v_project_id = -9999 and prd.project_id is null) or -- bug2669021