APPS.PJI_PMV_BOOKINGS_BACKLOG dependencies on PJI_PMV_TIME_DIM_TMP

Line 397: FROM pji_pmv_time_dim_tmp TIME

393: , 0 btb_revenue
394: , 0
395: , 0 prior_btb_total_bookings
396: , 0 prior_btb_revenue
397: FROM pji_pmv_time_dim_tmp TIME
398: , pji_pmv_orgz_dim_tmp HORG
399: , pji_ac_orgo_f_mv FCT
400: , pji_pmv_org_dim_tmp HOU
401: WHERE

Line 613: FROM pji_pmv_time_dim_tmp

609: , 0 btb_revenue
610: , 0
611: , 0 prior_btb_total_bookings
612: , 0 prior_btb_revenue
613: FROM pji_pmv_time_dim_tmp
614: WHERE name <> '-1')
615: GROUP BY
616: ORG_ID
617: , ORGANIZATION_ID

Line 673: FROM pji_pmv_time_dim_tmp TIME

669: , 0 btb_revenue
670: , 0
671: , 0 prior_btb_total_bookings
672: , 0 prior_btb_revenue
673: FROM pji_pmv_time_dim_tmp TIME
674: , pji_pmv_orgz_dim_tmp HORG
675: , pji_pmv_cls_dim_tmp CLS
676: , pji_ac_clso_f_mv FCT
677: , pji_pmv_org_dim_tmp HOU

Line 900: FROM pji_pmv_time_dim_tmp

896: , 0 btb_revenue
897: , 0
898: , 0 prior_btb_total_bookings
899: , 0 prior_btb_revenue
900: FROM pji_pmv_time_dim_tmp
901: WHERE name <> '-1'
902: UNION ALL
903: SELECT '-1' ORG_ID
904: ,'-1' ORGANIZATION_ID

Line 1432: FROM PJI_PMV_TIME_DIM_TMP TIME,

1428: 0,
1429: 0,
1430: 0,
1431: 0
1432: FROM PJI_PMV_TIME_DIM_TMP TIME,
1433: PJI_PMV_ORGZ_DIM_TMP TORG,
1434: PJI_AC_PROJ_F FCT,
1435: PJI_PMV_ORG_DIM_TMP TOU
1436: WHERE FCT.PROJECT_ORG_ID = TOU.ID

Line 1649: FROM PJI_PMV_TIME_DIM_TMP TIME,

1645: 0,
1646: 0,
1647: 0,
1648: 0
1649: FROM PJI_PMV_TIME_DIM_TMP TIME,
1650: PJI_PMV_PRJ_DIM_TMP TPRJ,
1651: PJI_AC_PROJ_F FCT,
1652: PJI_PMV_ORG_DIM_TMP TOU
1653: WHERE FCT.PROJECT_ORG_ID = TOU.ID

Line 2038: FROM PJI_PMV_TIME_DIM_TMP TIME,

2034: 0,
2035: 0,
2036: 0,
2037: 0
2038: FROM PJI_PMV_TIME_DIM_TMP TIME,
2039: PJI_PMV_ORGZ_DIM_TMP HORG,
2040: PJI_AC_ORGO_F_MV FCT,
2041: PJI_PMV_ORG_DIM_TMP HOU
2042: WHERE FCT.ORG_ID = HOU.ID

Line 2119: FROM PJI_PMV_TIME_DIM_TMP

2115: 0 LOST_BACKLOG, 0 LOST_BACKLOG_ITD, 0 BACKLOG,
2116: 0 BACKLOG_ITD, 0 REVENUE_AT_RISK,
2117: 0 REVENUE_AT_RISK_ITD,
2118: 0,0,0,0,0,0,0,0,0,0
2119: FROM PJI_PMV_TIME_DIM_TMP
2120: WHERE NAME <> '-1')
2121: GROUP BY ORG_ID, ORGANIZATION_ID, TIME_KEY, TIME_ID, PROJECT_CLASS_ID;
2122: ELSE
2123: /*

Line 2189: FROM PJI_PMV_TIME_DIM_TMP TIME,

2185: 0,
2186: 0,
2187: 0,
2188: 0
2189: FROM PJI_PMV_TIME_DIM_TMP TIME,
2190: PJI_PMV_ORGZ_DIM_TMP HORG,
2191: PJI_PMV_CLS_DIM_TMP CLS,
2192: PJI_AC_CLSO_F_MV FCT,
2193: PJI_PMV_ORG_DIM_TMP HOU

Line 2301: FROM PJI_PMV_TIME_DIM_TMP

2297: 0,
2298: 0,
2299: 0,
2300: 0
2301: FROM PJI_PMV_TIME_DIM_TMP
2302: WHERE NAME <> '-1'
2303: UNION ALL
2304: SELECT '-1' ORG_ID, '-1' ORGANIZATION_ID, '-1' TIME_ID,
2305: -1 TIME_KEY, NAME PROJECT_CLASS_ID,