APPS.PJI_PMV_BACKLOG dependencies on PJI_PMV_CLS_DIM_TMP

Line 428: , PJI_PMV_CLS_DIM_TMP CLS

424: , 0
425: , 0
426: FROM PJI_PMV_ITD_DIM_TMP TIME
427: , PJI_PMV_ORGZ_DIM_TMP HORG
428: , PJI_PMV_CLS_DIM_TMP CLS
429: , PJI_AC_CLSO_F_MV FCT
430: , PJI_PMV_ORG_DIM_TMP HOU
431: WHERE
432: FCT.PROJECT_ORG_ID = HOU.ID

Line 472: , PJI_PMV_CLS_DIM_TMP CLS

468: , 0
469: FROM
470: PJI_PMV_ITD_DIM_TMP TIME
471: , PJI_PMV_ORGZ_DIM_TMP HORG
472: , PJI_PMV_CLS_DIM_TMP CLS
473: , PJI_AC_CLSO_F_MV FCT
474: , PJI_PMV_ORG_DIM_TMP HOU
475: WHERE
476: FCT.PROJECT_ORG_ID = HOU.ID

Line 594: FROM PJI_PMV_CLS_DIM_TMP

590: , 0
591: , 0
592: , 0
593: , 0
594: FROM PJI_PMV_CLS_DIM_TMP
595: WHERE NAME <> '-1') FACT
596: GROUP BY
597: ORG_ID
598: , ORGANIZATION_ID

Line 1052: , PJI_PMV_CLS_DIM_TMP CLS

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
1055:
1056: WHERE

Line 1092: , PJI_PMV_CLS_DIM_TMP CLS

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
1095: WHERE
1096: FCT.PROJECT_ORG_ID = HOU.ID

Line 1144: , PJI_PMV_CLS_DIM_TMP CLS

1140: l_Ending_Revenue_at_Risk_itd
1141: FROM
1142: PJI_PMV_ITD_DIM_TMP TIME
1143: , PJI_PMV_ORGZ_DIM_TMP HORG
1144: , PJI_PMV_CLS_DIM_TMP CLS
1145: , PJI_AC_CLSO_F_MV FCT
1146: , PJI_PMV_ORG_DIM_TMP HOU
1147: WHERE
1148: FCT.PROJECT_ORG_ID = HOU.ID

Line 1164: , PJI_PMV_CLS_DIM_TMP CLS

1160: INTO l_Ending_Prior_Backlog_itd
1161: FROM
1162: PJI_PMV_ITD_DIM_TMP TIME
1163: , PJI_PMV_ORGZ_DIM_TMP HORG
1164: , PJI_PMV_CLS_DIM_TMP CLS
1165: , PJI_AC_CLSO_F_MV FCT
1166: , PJI_PMV_ORG_DIM_TMP HOU
1167:
1168: WHERE