DBA Data[Home] [Help]

APPS.PA_WORK_TYPE_UPGRADE dependencies on RCV_TRANSACTIONS

Line 661: rcv_transactions rcv

657: rcv.destination_type_code doc_type,
658: rcv.transaction_type dist_type
659: FROM pa_cost_distribution_lines_all cdl,
660: pa_expenditure_items_all ei,
661: rcv_transactions rcv
662: WHERE cdl.expenditure_item_id = ei.expenditure_item_id
663: AND rcv.transaction_id = to_number(NVL2(LTRIM(cdl.system_reference4, '0123456789'), NULL, cdl.system_reference4))
664: AND rcv.po_distribution_id = to_number(cdl.system_reference3)
665: AND cdl.system_reference2 IS NOT NULL