DBA Data[Home] [Help]

APPS.PJI_FM_SUM_ROLLUP_ACT dependencies on FII_TIME_CAL_DAY_MV

Line 1426: FII_TIME_CAL_DAY_MV time,

1422: sum(act.LOST_BACKLOG),
1423: sum(act.ACTIVE_BACKLOG),
1424: sum(act.REVENUE_AT_RISK)
1425: from
1426: FII_TIME_CAL_DAY_MV time,
1427: PJI_FM_AGGR_ACT3 act
1428: where
1429: act.PERIOD_TYPE_ID = 1 and
1430: act.CALENDAR_TYPE = 'P' and

Line 1652: FII_TIME_CAL_DAY_MV time,

1648: sum(act.LOST_BACKLOG) LOST_BACKLOG,
1649: sum(act.ACTIVE_BACKLOG) ACTIVE_BACKLOG,
1650: sum(act.REVENUE_AT_RISK) REVENUE_AT_RISK
1651: from
1652: FII_TIME_CAL_DAY_MV time,
1653: PJI_FM_AGGR_ACT3 act
1654: where
1655: act.PERIOD_TYPE_ID = 1 and
1656: act.CALENDAR_TYPE = 'C' and