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_RM_SUM_ROLLUP_RES dependencies on FII_TIME_DAY

Line 830: FII_TIME_DAY time,

826: sum(tmp1.UNASSIGNED_HRS_S) UNASSIGNED_HRS_S,
827: sum(tmp1.CONF_OVERCOM_HRS_S) CONF_OVERCOM_HRS_S,
828: sum(tmp1.PROV_OVERCOM_HRS_S) PROV_OVERCOM_HRS_S
829: from
830: FII_TIME_DAY time,
831: PJI_RM_AGGR_RES1 tmp1
832: where
833: tmp1.WORKER_ID = p_worker_id and
834: tmp1.RECORD_TYPE <> 'N' and

Line 1242: FII_TIME_DAY time,

1238: sum(tmp1.UNASSIGNED_HRS_S) UNASSIGNED_HRS_S,
1239: sum(tmp1.CONF_OVERCOM_HRS_S) CONF_OVERCOM_HRS_S,
1240: sum(tmp1.PROV_OVERCOM_HRS_S) PROV_OVERCOM_HRS_S
1241: from
1242: FII_TIME_DAY time,
1243: PJI_RM_AGGR_RES1 tmp1
1244: where
1245: tmp1.WORKER_ID = p_worker_id and
1246: tmp1.RECORD_TYPE <> 'N' and

Line 1434: FII_TIME_DAY time,

1430: sum(tmp2.AVAILABLE_RES_COUNT_BKT4_S) AVAILABLE_RES_COUNT_BKT4_S,
1431: sum(tmp2.AVAILABLE_RES_COUNT_BKT5_S) AVAILABLE_RES_COUNT_BKT5_S,
1432: sum(tmp2.TOTAL_RES_COUNT) TOTAL_RES_COUNT
1433: from
1434: FII_TIME_DAY time,
1435: PJI_RM_AGGR_RES2 tmp2
1436: where
1437: tmp2.WORKER_ID = p_worker_id and
1438: tmp2.PERIOD_TYPE_ID = 1 and

Line 2017: FII_TIME_DAY time,

2013: sum(tmp2.AVAILABLE_RES_COUNT_BKT4_S) AVAILABLE_RES_COUNT_BKT4_S,
2014: sum(tmp2.AVAILABLE_RES_COUNT_BKT5_S) AVAILABLE_RES_COUNT_BKT5_S,
2015: sum(tmp2.TOTAL_RES_COUNT) TOTAL_RES_COUNT
2016: from
2017: FII_TIME_DAY time,
2018: PJI_RM_AGGR_RES2 tmp2
2019: where
2020: tmp2.WORKER_ID = p_worker_id and
2021: tmp2.PERIOD_TYPE_ID = 1 and