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_AVL dependencies on FII_TIME_CAL_DAY_MV

Line 1452: FII_TIME_CAL_DAY_MV and PJI_ORG_EXTR_INFO to get appropriate

1448: So, for Enterprise periods, we select from PJI_RM_AGGR_RES2
1449: and join it to FII_TIME_DAY to get appropriate distinct records
1450: for the periods/quarters/weeks affected. Similarly, for GL periods,
1451: we select from PJI_RM_AGGR_RES2 and join it to
1452: FII_TIME_CAL_DAY_MV and PJI_ORG_EXTR_INFO to get appropriate
1453: distinct records for the periods/quarters affected.
1454: */
1455: /*
1456: Populate AVL1 only for old fact records

Line 1542: index(fiit, FII_TIME_CAL_DAY_MV_U1) */

1538: ) rt2
1539: UNION ALL
1540: SELECT /*+ ordered
1541: index(tmp2, PJI_RM_AGGR_RES2_N1)
1542: index(fiit, FII_TIME_CAL_DAY_MV_U1) */
1543: DISTINCT
1544: tmp2.expenditure_org_id as expenditure_org_id,
1545: p_worker_id as worker_id,
1546: tmp2.person_id as person_id,

Line 1554: FII_TIME_CAL_DAY_MV fiit

1550: fiit.cal_qtr_id as period_id,
1551: 'G' as period_type
1552: FROM
1553: PJI_RM_AGGR_RES2 tmp2,
1554: FII_TIME_CAL_DAY_MV fiit
1555: WHERE
1556: tmp2.person_id = p_person_id
1557: and to_date(to_char(tmp2.time_id), 'J') = fiit.report_date
1558: and (

Line 1770: FII_TIME_CAL_DAY_MV fiit

1766: 0 as ROLL_X_WEEK_13
1767: FROM
1768: PJI_RM_AGGR_AVL1 avl_tmp1,
1769: FII_TIME_CAL_PERIOD per,
1770: FII_TIME_CAL_DAY_MV fiit
1771: WHERE
1772: avl_tmp1.PERIOD_ID = per.CAL_QTR_ID
1773: and avl_tmp1.gl_calendar_id = per.calendar_id
1774: and per.cal_period_id = fiit.cal_period_id