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_ORG_DIM_TMP

Line 219: , PJI_PMV_ORG_DIM_TMP HOU

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
222: AND FCT.ORGANIZATION_ID = HORG.ID
223: AND FCT.TIME_ID = TIME.ID

Line 261: , PJI_PMV_ORG_DIM_TMP HOU

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
264: AND FCT.ORGANIZATION_ID = HORG.ID
265: AND FCT.TIME_ID = TIME.PRIOR_ID

Line 296: FROM PJI_PMV_ORG_DIM_TMP

292: , 0
293: , 0
294: , 0
295: , 0
296: FROM PJI_PMV_ORG_DIM_TMP
297: WHERE NAME <> '-1'
298: UNION ALL
299: SELECT '-1' ORG_ID
300: , NAME ORGANIZATION_ID

Line 430: , PJI_PMV_ORG_DIM_TMP HOU

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
433: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID
434: AND FCT.TIME_ID = TIME.ID

Line 474: , PJI_PMV_ORG_DIM_TMP HOU

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
477: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID
478: AND FCT.TIME_ID = TIME.PRIOR_ID

Line 510: FROM PJI_PMV_ORG_DIM_TMP

506: , 0
507: , 0
508: , 0
509: , 0
510: FROM PJI_PMV_ORG_DIM_TMP
511: WHERE NAME <> '-1'
512: UNION ALL
513: SELECT '-1' ORG_ID
514: , NAME ORGANIZATION_ID

Line 884: , PJI_PMV_ORG_DIM_TMP HOU

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
887: AND FCT.ORGANIZATION_ID = HORG.ID
888: AND FCT.TIME_ID = TIME.ID

Line 921: , PJI_PMV_ORG_DIM_TMP HOU

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
924: FCT.ORG_ID = HOU.ID
925: AND FCT.ORGANIZATION_ID = HORG.ID

Line 969: , PJI_PMV_ORG_DIM_TMP HOU

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
972: AND FCT.ORGANIZATION_ID = HORG.ID
973: AND FCT.TIME_ID = TIME.ID

Line 985: , PJI_PMV_ORG_DIM_TMP HOU

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
988: AND FCT.ORGANIZATION_ID = HORG.ID
989: AND FCT.TIME_ID = TIME.PRIOR_ID

Line 1054: , PJI_PMV_ORG_DIM_TMP HOU

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
1057: FCT.PROJECT_ORG_ID = HOU.ID
1058: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID

Line 1094: , PJI_PMV_ORG_DIM_TMP HOU

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
1097: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID
1098: AND FCT.TIME_ID = TIME.PRIOR_ID

Line 1146: , PJI_PMV_ORG_DIM_TMP HOU

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
1149: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID
1150: AND FCT.TIME_ID = TIME.ID

Line 1166: , PJI_PMV_ORG_DIM_TMP HOU

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
1169: FCT.PROJECT_ORG_ID = HOU.ID
1170: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID