APPS.PJI_PMV_BACKLOG dependencies on PJI_PMV_TIME_DIM_TMP

Line 352: FROM PJI_PMV_TIME_DIM_TMP

348: , 0
349: , 0
350: , 0
351: , 0
352: FROM PJI_PMV_TIME_DIM_TMP
353: WHERE NAME <> '-1')
354: GROUP BY
355: ORG_ID
356: , ORGANIZATION_ID

Line 566: FROM PJI_PMV_TIME_DIM_TMP

562: , 0
563: , 0
564: , 0
565: , 0
566: FROM PJI_PMV_TIME_DIM_TMP
567: WHERE NAME <> '-1'
568: UNION ALL
569: SELECT '-1' ORG_ID
570: , '-1' ORGANIZATION_ID

Line 881: PJI_PMV_TIME_DIM_TMP TIME

877: + DORMANT_BACKLOG_START BACKLOG
878: , REVENUE_AT_RISK REVENUE_AT_RISK
879: , 0
880: FROM
881: PJI_PMV_TIME_DIM_TMP TIME
882: , PJI_PMV_ORGZ_DIM_TMP HORG
883: , PJI_AC_ORGO_F_MV FCT
884: , PJI_PMV_ORG_DIM_TMP HOU
885: WHERE

Line 918: PJI_PMV_TIME_DIM_TMP TIME

914: , 0 BACKLOG
915: , 0 REVENUE_AT_RISK
916: , 0
917: FROM
918: PJI_PMV_TIME_DIM_TMP TIME
919: , PJI_PMV_ORGZ_DIM_TMP HORG
920: , PJI_AC_ORGO_F_MV FCT
921: , PJI_PMV_ORG_DIM_TMP HOU
922:

Line 952: FROM PJI_PMV_TIME_DIM_TMP

948: , 0 LOST_BACKLOG
949: , 0 BACKLOG
950: , 0 REVENUE_AT_RISK
951: , 0
952: FROM PJI_PMV_TIME_DIM_TMP
953: WHERE NAME <> '-1')
954: GROUP BY
955: ORG_ID
956: , ORGANIZATION_ID

Line 1050: PJI_PMV_TIME_DIM_TMP TIME

1046: + DORMANT_BACKLOG_START BACKLOG
1047: , REVENUE_AT_RISK REVENUE_AT_RISK
1048: , 0
1049: FROM
1050: PJI_PMV_TIME_DIM_TMP TIME
1051: ,PJI_PMV_ORGZ_DIM_TMP HORG
1052: , PJI_PMV_CLS_DIM_TMP CLS
1053: , PJI_AC_CLSO_F_MV FCT
1054: , PJI_PMV_ORG_DIM_TMP HOU

Line 1090: PJI_PMV_TIME_DIM_TMP TIME

1086: , 0 BACKLOG
1087: , 0 REVENUE_AT_RISK
1088: , 0
1089: FROM
1090: PJI_PMV_TIME_DIM_TMP TIME
1091: , PJI_PMV_ORGZ_DIM_TMP HORG
1092: , PJI_PMV_CLS_DIM_TMP CLS
1093: , PJI_AC_CLSO_F_MV FCT
1094: , PJI_PMV_ORG_DIM_TMP HOU

Line 1125: FROM PJI_PMV_TIME_DIM_TMP

1121: , 0 LOST_BACKLOG
1122: , 0 BACKLOG
1123: , 0 REVENUE_AT_RISK
1124: , 0
1125: FROM PJI_PMV_TIME_DIM_TMP
1126: WHERE NAME <> '-1'
1127: ) FACT
1128: GROUP BY
1129: ORG_ID