eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_WORK_TYPE_UPGRADE dependencies on PA_EXPENDITURES_ALL

Line 342: FROM pa_expenditure_items_all EI, pa_expenditures_all EXP

338: ,reference1
339: )
340: SELECT /*+ parallel(ei) */ EI.ROWID, EI.expenditure_item_id, null
341: , EI.orig_transaction_reference, EI.transaction_source, 'CCO'
342: FROM pa_expenditure_items_all EI, pa_expenditures_all EXP
343: WHERE EI.transaction_source = NVL(P_Txn_Src, EI.transaction_source)
344: AND EI.transaction_source IN ('Inventory Misc', 'Inventory', 'PJM_CSTBP_INV_ACCOUNTS'
345: ,'PJM_CSTBP_INV_NO_ACCOUNTS', 'Work In Process'
346: ,'PJM_CSTBP_ST_ACCOUNTS', 'PJM_CSTBP_ST_NO_ACCOUNTS'

Line 356: FROM pa_expenditure_items_all EI, pa_expenditures_all EXP

352: AND EXP.orig_exp_txn_reference1 is null
353: UNION ALL
354: SELECT /*+ parallel(ei) */ EI.ROWID, EI.expenditure_item_id, null
355: , EXP.orig_exp_txn_reference1, EI.transaction_source, 'PODIST'
356: FROM pa_expenditure_items_all EI, pa_expenditures_all EXP
357: WHERE EI.transaction_source IN ('Inventory Misc', 'Inventory', 'PJM_CSTBP_INV_ACCOUNTS'
358: ,'PJM_CSTBP_INV_NO_ACCOUNTS', 'Work In Process'
359: ,'PJM_CSTBP_ST_ACCOUNTS', 'PJM_CSTBP_ST_NO_ACCOUNTS'
360: ,'PJM_CSTBP_WIP_ACCOUNTS', 'PJM_CSTBP_WIP_NO_ACCOUNTS'

Line 370: FROM pa_expenditure_items_all EI, pa_expenditures_all EXP, pa_cost_distribution_lines_all CDL

366: AND EXP.orig_exp_txn_reference2 is not null
367: UNION ALL
368: SELECT /*+ parallel(ei) */ EI.ROWID, EI.expenditure_item_id, null
369: , CDL.system_reference1, EI.transaction_source, 'PODIST'
370: FROM pa_expenditure_items_all EI, pa_expenditures_all EXP, pa_cost_distribution_lines_all CDL
371: WHERE EI.transaction_source IN ('Inventory Misc', 'Inventory', 'PJM_CSTBP_INV_ACCOUNTS'
372: ,'PJM_CSTBP_INV_NO_ACCOUNTS', 'Work In Process'
373: ,'PJM_CSTBP_ST_ACCOUNTS', 'PJM_CSTBP_ST_NO_ACCOUNTS'
374: ,'PJM_CSTBP_WIP_ACCOUNTS', 'PJM_CSTBP_WIP_NO_ACCOUNTS'

Line 725: FROM pa_expenditures_all e,

721: IS
722: SELECT ei.rowid,
723: ei.expenditure_item_id,
724: e.vendor_id
725: FROM pa_expenditures_all e,
726: pa_expenditure_items_all ei
727: WHERE e.expenditure_id =ei.expenditure_id
728: and ei.document_header_id is null
729: AND ei.cost_distributed_flag = 'Y'