DBA Data[Home] [Help]

APPS.INV_RCV_TXN_MATCH dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 969: from po_req_distributions_all prd

965: AND ( (
966: rsl.source_document_code = 'REQ'
967: and exists
968: ( select '1'
969: from po_req_distributions_all prd
970: where rsl.requisition_line_id = prd.requisition_line_id
971: and Nvl(rsl.req_distribution_id,prd.distribution_id) = prd.distribution_id--BUG4930681
972: and (v_project_id is null or
973: (v_project_id = -9999 and prd.project_id is null) or -- bug2669021

Line 1065: from po_req_distributions_all prd

1061: AND ( (
1062: rsl.source_document_code = 'REQ'
1063: and exists
1064: ( select '1'
1065: from po_req_distributions_all prd
1066: where rsl.requisition_line_id = prd.requisition_line_id
1067: and Nvl(rsl.req_distribution_id,prd.distribution_id) = prd.distribution_id--BUG4930681
1068: and (v_project_id is null or
1069: (v_project_id = -9999 and prd.project_id is null) or -- bug2669021