[Home] [Help]
327: ,reference1
328: )
329: SELECT /*+ parallel(ei) */ EI.ROWID, EI.expenditure_item_id, null
330: , EI.orig_transaction_reference, EI.transaction_source, 'CCO'
331: FROM pa_expenditure_items_all EI, pa_expenditures_all EXP
332: WHERE EI.transaction_source = NVL(P_Txn_Src, EI.transaction_source)
333: AND EI.transaction_source IN ('Inventory Misc', 'Inventory', 'PJM_CSTBP_INV_ACCOUNTS'
334: ,'PJM_CSTBP_INV_NO_ACCOUNTS', 'Work In Process'
335: ,'PJM_CSTBP_ST_ACCOUNTS', 'PJM_CSTBP_ST_NO_ACCOUNTS'
341: AND EXP.orig_exp_txn_reference1 is null
342: UNION ALL
343: SELECT /*+ parallel(ei) */ EI.ROWID, EI.expenditure_item_id, null
344: , EXP.orig_exp_txn_reference1, EI.transaction_source, 'PODIST'
345: FROM pa_expenditure_items_all EI, pa_expenditures_all EXP
346: WHERE EI.transaction_source IN ('Inventory Misc', 'Inventory', 'PJM_CSTBP_INV_ACCOUNTS'
347: ,'PJM_CSTBP_INV_NO_ACCOUNTS', 'Work In Process'
348: ,'PJM_CSTBP_ST_ACCOUNTS', 'PJM_CSTBP_ST_NO_ACCOUNTS'
349: ,'PJM_CSTBP_WIP_ACCOUNTS', 'PJM_CSTBP_WIP_NO_ACCOUNTS'
355: AND EXP.orig_exp_txn_reference2 is not null
356: UNION ALL
357: SELECT /*+ parallel(ei) */ EI.ROWID, EI.expenditure_item_id, null
358: , CDL.system_reference1, EI.transaction_source, 'PODIST'
359: FROM pa_expenditure_items_all EI, pa_expenditures_all EXP, pa_cost_distribution_lines_all CDL
360: WHERE EI.transaction_source IN ('Inventory Misc', 'Inventory', 'PJM_CSTBP_INV_ACCOUNTS'
361: ,'PJM_CSTBP_INV_NO_ACCOUNTS', 'Work In Process'
362: ,'PJM_CSTBP_ST_ACCOUNTS', 'PJM_CSTBP_ST_NO_ACCOUNTS'
363: ,'PJM_CSTBP_WIP_ACCOUNTS', 'PJM_CSTBP_WIP_NO_ACCOUNTS'