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.PJI_FM_SUM_PSI dependencies on DUAL

Line 1377: select 'ENT' INVERT_ID from dual union all

1373: cls.ITEM_CATEGORY_SET_ID = cat.CATEGORY_SET_ID
1374: ) inv,
1375: PA_EXPENDITURE_CATEGORIES exp_cat, -- (+)
1376: (
1377: select 'ENT' INVERT_ID from dual union all
1378: select 'GL' INVERT_ID from dual union all
1379: select 'PA' INVERT_ID from dual
1380: ) invert
1381: where

Line 1378: select 'GL' INVERT_ID from dual union all

1374: ) inv,
1375: PA_EXPENDITURE_CATEGORIES exp_cat, -- (+)
1376: (
1377: select 'ENT' INVERT_ID from dual union all
1378: select 'GL' INVERT_ID from dual union all
1379: select 'PA' INVERT_ID from dual
1380: ) invert
1381: where
1382: tmp2.RECVR_GL_CALENDAR_ID = gl_cal.CALENDAR_ID and

Line 1379: select 'PA' INVERT_ID from dual

1375: PA_EXPENDITURE_CATEGORIES exp_cat, -- (+)
1376: (
1377: select 'ENT' INVERT_ID from dual union all
1378: select 'GL' INVERT_ID from dual union all
1379: select 'PA' INVERT_ID from dual
1380: ) invert
1381: where
1382: tmp2.RECVR_GL_CALENDAR_ID = gl_cal.CALENDAR_ID and
1383: tmp2.RECVR_GL_PERIOD_NAME = gl_cal.NAME and

Line 2301: select 'ENT' INVERT_ID from dual union all

2297: ) tmp2,
2298: PJI_TIME_CAL_PERIOD_V gl_cal,
2299: PJI_TIME_CAL_PERIOD_V pa_cal,
2300: (
2301: select 'ENT' INVERT_ID from dual union all
2302: select 'GL' INVERT_ID from dual union all
2303: select 'PA' INVERT_ID from dual
2304: ) invert
2305: where

Line 2302: select 'GL' INVERT_ID from dual union all

2298: PJI_TIME_CAL_PERIOD_V gl_cal,
2299: PJI_TIME_CAL_PERIOD_V pa_cal,
2300: (
2301: select 'ENT' INVERT_ID from dual union all
2302: select 'GL' INVERT_ID from dual union all
2303: select 'PA' INVERT_ID from dual
2304: ) invert
2305: where
2306: tmp2.GL_CALENDAR_ID = gl_cal.CALENDAR_ID and

Line 2303: select 'PA' INVERT_ID from dual

2299: PJI_TIME_CAL_PERIOD_V pa_cal,
2300: (
2301: select 'ENT' INVERT_ID from dual union all
2302: select 'GL' INVERT_ID from dual union all
2303: select 'PA' INVERT_ID from dual
2304: ) invert
2305: where
2306: tmp2.GL_CALENDAR_ID = gl_cal.CALENDAR_ID and
2307: tmp2.GL_PERIOD_NAME = gl_cal.NAME and