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_AVL dependencies on PJI_PMV_ORG_DIM_TMP

Line 240: PJI_PMV_ORG_DIM_TMP HOU,

236: 'WEEKS',IMP.FTE_WEEK, 1) END AVL_BKT5
237: FROM PJI_PMV_TIME_DIM_TMP TIME,
238: PJI_PMV_ORGZ_DIM_TMP HORG,
239: PJI_RM_ORGO_F_MV FCT,
240: PJI_PMV_ORG_DIM_TMP HOU,
241: PA_IMPLEMENTATIONS_ALL IMP
242: WHERE FCT.EXPENDITURE_ORG_ID = HOU.ID
243: AND FCT.EXPENDITURE_ORGANIZATION_ID = HORG.ID
244: AND HOU.ID = IMP.ORG_ID

Line 275: PJI_PMV_ORG_DIM_TMP HOU,

271: ,0 AVL_BKT5
272: FROM PJI_PMV_TIME_DIM_TMP TIME,
273: PJI_PMV_ORGZ_DIM_TMP HORG,
274: PJI_RM_ORGO_F_MV FCT,
275: PJI_PMV_ORG_DIM_TMP HOU,
276: PA_IMPLEMENTATIONS_ALL IMP
277: WHERE FCT.EXPENDITURE_ORG_ID = HOU.ID
278: AND FCT.EXPENDITURE_ORGANIZATION_ID = HORG.ID
279: AND HOU.ID = IMP.ORG_ID

Line 683: PJI_PMV_ORG_DIM_TMP HOU

679: ,0 WEEK_3
680: ,0 WEEK_4
681: FROM PJI_PMV_ORGZ_DIM_TMP HORG,
682: PJI_CA_ORGO_F_MV FCT,
683: PJI_PMV_ORG_DIM_TMP HOU
684: WHERE FCT.EXPENDITURE_ORG_ID = HOU.ID
685: AND FCT.EXPENDITURE_ORGANIZATION_ID = HORG.ID
686: AND FCT.TIME_ID = L_WEEK_IDS(1)
687: AND FCT.CALENDAR_TYPE = L_CALENDAR_TYPE

Line 703: PJI_PMV_ORG_DIM_TMP HOU

699: ,0 WEEK_3
700: ,0 WEEK_4
701: FROM PJI_PMV_ORGZ_DIM_TMP HORG,
702: PJI_CA_ORGO_F_MV FCT,
703: PJI_PMV_ORG_DIM_TMP HOU
704: WHERE FCT.EXPENDITURE_ORG_ID = HOU.ID
705: AND FCT.EXPENDITURE_ORGANIZATION_ID = HORG.ID
706: AND FCT.TIME_ID = L_WEEK_IDS(2)
707: AND FCT.CALENDAR_TYPE = L_CALENDAR_TYPE

Line 723: PJI_PMV_ORG_DIM_TMP HOU

719: ,0 WEEK_3
720: ,0 WEEK_4
721: FROM PJI_PMV_ORGZ_DIM_TMP HORG,
722: PJI_CA_ORGO_F_MV FCT,
723: PJI_PMV_ORG_DIM_TMP HOU
724: WHERE FCT.EXPENDITURE_ORG_ID = HOU.ID
725: AND FCT.EXPENDITURE_ORGANIZATION_ID = HORG.ID
726: AND FCT.TIME_ID = L_WEEK_IDS(3)
727: AND FCT.CALENDAR_TYPE = L_CALENDAR_TYPE

Line 743: PJI_PMV_ORG_DIM_TMP HOU

739: ,FCT.AVAILABILITY WEEK_3
740: ,0 WEEK_4
741: FROM PJI_PMV_ORGZ_DIM_TMP HORG,
742: PJI_CA_ORGO_F_MV FCT,
743: PJI_PMV_ORG_DIM_TMP HOU
744: WHERE FCT.EXPENDITURE_ORG_ID = HOU.ID
745: AND FCT.EXPENDITURE_ORGANIZATION_ID = HORG.ID
746: AND FCT.TIME_ID = L_WEEK_IDS(4)
747: AND FCT.CALENDAR_TYPE = L_CALENDAR_TYPE

Line 763: PJI_PMV_ORG_DIM_TMP HOU

759: ,0 WEEK_3
760: ,FCT.AVAILABILITY WEEK_4
761: FROM PJI_PMV_ORGZ_DIM_TMP HORG,
762: PJI_CA_ORGO_F_MV FCT,
763: PJI_PMV_ORG_DIM_TMP HOU
764: WHERE FCT.EXPENDITURE_ORG_ID = HOU.ID
765: AND FCT.EXPENDITURE_ORGANIZATION_ID = HORG.ID
766: AND FCT.TIME_ID = L_WEEK_IDS(5)
767: AND FCT.CALENDAR_TYPE = L_CALENDAR_TYPE

Line 1018: PJI_PMV_ORG_DIM_TMP HOU

1014: , 0 CUR_AVL_4
1015: , 0 CUR_AVL_5
1016: FROM PJI_PMV_ORGZ_DIM_TMP HORG,
1017: PJI_RM_ORGO_F_MV FCT,
1018: PJI_PMV_ORG_DIM_TMP HOU
1019: WHERE FCT.EXPENDITURE_ORG_ID = HOU.ID
1020: AND FCT.EXPENDITURE_ORGANIZATION_ID = HORG.ID
1021: AND FCT.PERIOD_TYPE_ID = l_DAY_PERIOD_TYPE
1022: AND FCT.CALENDAR_TYPE = l_DAY_CALENDAR_TYPE

Line 1043: PJI_PMV_ORG_DIM_TMP HOU

1039: 'CONSECUTIVE', BCKT_5_CS, 0) CUR_AVL_5
1040: FROM PJI_PMV_ORGZ_DIM_TMP HORG,
1041: PJI_PMV_TIME_DIM_TMP TIME,
1042: PJI_AV_ORGO_F_MV FCT,
1043: PJI_PMV_ORG_DIM_TMP HOU
1044: WHERE FCT.EXPENDITURE_ORG_ID = HOU.ID
1045: AND FCT.EXPENDITURE_ORGANIZATION_ID = HORG.ID
1046: AND FCT.TIME_ID = TIME.ID
1047: AND FCT.PERIOD_TYPE_ID = TIME.PERIOD_TYPE

Line 1357: PJI_PMV_ORG_DIM_TMP HOU,

1353:
1354: FROM PJI_PMV_ORGZ_DIM_TMP HORG,
1355: PJI_PMV_TIME_DIM_TMP TIME,
1356: PJI_RM_ORGO_F_MV FCT,
1357: PJI_PMV_ORG_DIM_TMP HOU,
1358: PA_IMPLEMENTATIONS_ALL IMP
1359: WHERE FCT.EXPENDITURE_ORG_ID = HOU.ID
1360: AND FCT.EXPENDITURE_ORGANIZATION_ID = HORG.ID
1361: AND HOU.ID = IMP.ORG_ID

Line 1567: PJI_PMV_ORG_DIM_TMP HOU,

1563: ) AVAILABLE_DAYS
1564: FROM PJI_PMV_ORGZ_DIM_TMP HORG,
1565: PJI_PMV_TIME_DIM_TMP TIME,
1566: PJI_RM_RES_F FCT,
1567: PJI_PMV_ORG_DIM_TMP HOU,
1568: PA_IMPLEMENTATIONS_ALL IMP
1569: WHERE FCT.EXPENDITURE_ORG_ID = HOU.ID
1570: AND FCT.EXPENDITURE_ORGANIZATION_ID = HORG.ID
1571: AND FCT.TIME_ID = TIME.ID

Line 1596: PJI_PMV_ORG_DIM_TMP HOU,

1592: ,0 AVAILABLE_DAYS
1593: FROM PJI_PMV_ORGZ_DIM_TMP HORG,
1594: PJI_PMV_TIME_DIM_TMP TIME,
1595: PJI_RM_RES_F FCT,
1596: PJI_PMV_ORG_DIM_TMP HOU,
1597: PA_IMPLEMENTATIONS_ALL IMP
1598: WHERE FCT.EXPENDITURE_ORG_ID = HOU.ID
1599: AND FCT.EXPENDITURE_ORGANIZATION_ID = HORG.ID
1600: AND FCT.TIME_ID = TIME.ID

Line 1630: PJI_PMV_ORG_DIM_TMP HOU

1626: ,0 AVAILABLE_HOURS
1627: ,0 AVAILABLE_DAYS
1628: FROM PJI_PMV_ORGZ_DIM_TMP HORG,
1629: PJI_RM_RES_F FCT,
1630: PJI_PMV_ORG_DIM_TMP HOU
1631: WHERE FCT.EXPENDITURE_ORG_ID = HOU.ID
1632: AND FCT.EXPENDITURE_ORGANIZATION_ID = HORG.ID
1633: AND FCT.TIME_ID = P_AS_OF_DATE
1634: AND FCT.PERIOD_TYPE_ID = L_DAY_PERIOD_TYPE