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 1356: select 'ENT' INVERT_ID from dual union all

1352: cls.ITEM_CATEGORY_SET_ID = cat.CATEGORY_SET_ID
1353: ) inv,
1354: PA_EXPENDITURE_CATEGORIES exp_cat, -- (+)
1355: (
1356: select 'ENT' INVERT_ID from dual union all
1357: select 'GL' INVERT_ID from dual union all
1358: select 'PA' INVERT_ID from dual
1359: ) invert
1360: where

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

1353: ) inv,
1354: PA_EXPENDITURE_CATEGORIES exp_cat, -- (+)
1355: (
1356: select 'ENT' INVERT_ID from dual union all
1357: select 'GL' INVERT_ID from dual union all
1358: select 'PA' INVERT_ID from dual
1359: ) invert
1360: where
1361: tmp2.RECVR_GL_CALENDAR_ID = gl_cal.CALENDAR_ID and

Line 1358: select 'PA' INVERT_ID from dual

1354: PA_EXPENDITURE_CATEGORIES exp_cat, -- (+)
1355: (
1356: select 'ENT' INVERT_ID from dual union all
1357: select 'GL' INVERT_ID from dual union all
1358: select 'PA' INVERT_ID from dual
1359: ) invert
1360: where
1361: tmp2.RECVR_GL_CALENDAR_ID = gl_cal.CALENDAR_ID and
1362: tmp2.RECVR_GL_PERIOD_NAME = gl_cal.NAME and

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

2275: ) tmp2,
2276: PJI_TIME_CAL_PERIOD_V gl_cal,
2277: PJI_TIME_CAL_PERIOD_V pa_cal,
2278: (
2279: select 'ENT' INVERT_ID from dual union all
2280: select 'GL' INVERT_ID from dual union all
2281: select 'PA' INVERT_ID from dual
2282: ) invert
2283: where

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

2276: PJI_TIME_CAL_PERIOD_V gl_cal,
2277: PJI_TIME_CAL_PERIOD_V pa_cal,
2278: (
2279: select 'ENT' INVERT_ID from dual union all
2280: select 'GL' INVERT_ID from dual union all
2281: select 'PA' INVERT_ID from dual
2282: ) invert
2283: where
2284: tmp2.GL_CALENDAR_ID = gl_cal.CALENDAR_ID and

Line 2281: select 'PA' INVERT_ID from dual

2277: PJI_TIME_CAL_PERIOD_V pa_cal,
2278: (
2279: select 'ENT' INVERT_ID from dual union all
2280: select 'GL' INVERT_ID from dual union all
2281: select 'PA' INVERT_ID from dual
2282: ) invert
2283: where
2284: tmp2.GL_CALENDAR_ID = gl_cal.CALENDAR_ID and
2285: tmp2.GL_PERIOD_NAME = gl_cal.NAME and