DBA Data[Home] [Help]

APPS.CSE_PROJ_ITEM_IN_SRV_PKG dependencies on PA_TRANSACTION_INTERFACE_ALL

Line 195: FROM pa_transaction_interface_all

191: AND dist.cr_code_combination_id IS NOT NULL
192: AND dist.dr_code_combination_id IS NOT NULL
193: AND exp.expenditure_id = item.expenditure_id
194: AND item.expenditure_item_id NOT IN (SELECT NVL(adjusted_expenditure_item_id,0) --Added for bug 9263804 expenditures already reversed should not be considered
195: FROM pa_transaction_interface_all
196: WHERE transaction_source IN ('CSE_PO_RECEIPT','CSE_INV_ISSUE')
197: AND attribute8 IS null
198: AND attribute9 IS null
199: AND attribute10 IS null);