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_ORGZ_DIM_TMP

Line 217: , PJI_PMV_ORGZ_DIM_TMP HORG

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
221: FCT.ORG_ID = HOU.ID

Line 259: , PJI_PMV_ORGZ_DIM_TMP HORG

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
263: FCT.ORG_ID = HOU.ID

Line 324: FROM PJI_PMV_ORGZ_DIM_TMP

320: , 0
321: , 0
322: , 0
323: , 0
324: FROM PJI_PMV_ORGZ_DIM_TMP
325: WHERE NAME <> '-1'
326: UNION ALL
327: SELECT '-1' ORG_ID
328: , '-1' ORGANIZATION_ID

Line 427: , PJI_PMV_ORGZ_DIM_TMP HORG

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
431: WHERE

Line 471: , PJI_PMV_ORGZ_DIM_TMP HORG

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
475: WHERE

Line 538: FROM PJI_PMV_ORGZ_DIM_TMP

534: , 0
535: , 0
536: , 0
537: , 0
538: FROM PJI_PMV_ORGZ_DIM_TMP
539: WHERE NAME <> '-1'
540: UNION ALL
541: SELECT '-1' ORG_ID
542: , '-1' ORGANIZATION_ID

Line 882: , PJI_PMV_ORGZ_DIM_TMP HORG

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
886: FCT.ORG_ID = HOU.ID

Line 919: , PJI_PMV_ORGZ_DIM_TMP HORG

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:
923: WHERE

Line 967: , PJI_PMV_ORGZ_DIM_TMP HORG

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
971: FCT.ORG_ID = HOU.ID

Line 983: , PJI_PMV_ORGZ_DIM_TMP HORG

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
987: FCT.ORG_ID = HOU.ID

Line 1051: ,PJI_PMV_ORGZ_DIM_TMP HORG

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

Line 1091: , PJI_PMV_ORGZ_DIM_TMP HORG

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
1095: WHERE

Line 1143: , PJI_PMV_ORGZ_DIM_TMP HORG

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
1147: WHERE

Line 1163: , PJI_PMV_ORGZ_DIM_TMP HORG

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
1167: