DBA Data[Home] [Help]

APPS.PA_WORK_TYPE_UPGRADE dependencies on RCV_TRANSACTIONS

Line 682: rcv_transactions rcv

678: rcv.destination_type_code doc_type,
679: rcv.transaction_type dist_type
680: FROM pa_cost_distribution_lines_all cdl,
681: pa_expenditure_items_all ei,
682: rcv_transactions rcv
683: WHERE cdl.expenditure_item_id = ei.expenditure_item_id
684: AND rcv.transaction_id = to_number(NVL2(LTRIM(cdl.system_reference4, '0123456789'), NULL, cdl.system_reference4))
685: AND rcv.po_distribution_id = to_number(cdl.system_reference3)
686: AND cdl.system_reference2 IS NOT NULL