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_PMV_BACKLOG dependencies on PJI_PMV_ITD_DIM_TMP

Line 216: PJI_PMV_ITD_DIM_TMP TIME

212: , 0
213: , 0
214: , 0
215: FROM
216: PJI_PMV_ITD_DIM_TMP TIME
217: , PJI_PMV_ORGZ_DIM_TMP HORG
218: , PJI_AC_ORGO_F_MV FCT
219: , PJI_PMV_ORG_DIM_TMP HOU
220: WHERE

Line 258: PJI_PMV_ITD_DIM_TMP TIME

254: , 0
255: , 0
256: , 0
257: FROM
258: PJI_PMV_ITD_DIM_TMP TIME
259: , PJI_PMV_ORGZ_DIM_TMP HORG
260: , PJI_AC_ORGO_F_MV FCT
261: , PJI_PMV_ORG_DIM_TMP HOU
262: WHERE

Line 426: FROM PJI_PMV_ITD_DIM_TMP TIME

422: , 0
423: , 0
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

Line 470: PJI_PMV_ITD_DIM_TMP TIME

466: , 0
467: , 0
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

Line 966: FROM PJI_PMV_ITD_DIM_TMP TIME

962: SUM( DORMANT_BACKLOG_INACTIV
963: + ACTIVE_BACKLOG
964: + DORMANT_BACKLOG_START ), SUM(LOST_BACKLOG), SUM(REVENUE_AT_RISK)
965: INTO l_Ending_Backlog_itd, l_Ending_Lost_Backlog_itd, l_Ending_Revenue_at_Risk_itd
966: FROM PJI_PMV_ITD_DIM_TMP TIME
967: , PJI_PMV_ORGZ_DIM_TMP HORG
968: , PJI_AC_ORGO_F_MV FCT
969: , PJI_PMV_ORG_DIM_TMP HOU
970: WHERE

Line 982: FROM PJI_PMV_ITD_DIM_TMP TIME

978: SELECT /*+ ORDERED */ SUM( DORMANT_BACKLOG_INACTIV
979: + ACTIVE_BACKLOG
980: + DORMANT_BACKLOG_START )
981: INTO l_Ending_Prior_Backlog_itd
982: FROM PJI_PMV_ITD_DIM_TMP TIME
983: , PJI_PMV_ORGZ_DIM_TMP HORG
984: , PJI_AC_ORGO_F_MV FCT
985: , PJI_PMV_ORG_DIM_TMP HOU
986: WHERE

Line 1142: PJI_PMV_ITD_DIM_TMP TIME

1138: INTO l_Ending_Backlog_itd,
1139: l_Ending_Lost_Backlog_itd,
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

Line 1162: PJI_PMV_ITD_DIM_TMP TIME

1158: + ACTIVE_BACKLOG
1159: + DORMANT_BACKLOG_START)
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