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_ORGZ_DIM_TMP

Line 238: PJI_PMV_ORGZ_DIM_TMP HORG,

234: AVAILABLE_HRS_BKT5_S /
235: DECODE(G_LABOUR_UNITS, 'DAYS', IMP.FTE_DAY,
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

Line 273: PJI_PMV_ORGZ_DIM_TMP HORG,

269: ,0 AVL_BKT3
270: ,0 AVL_BKT4
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

Line 300: FROM PJI_PMV_ORGZ_DIM_TMP

296: , 0 AVL_BKT2
297: , 0 AVL_BKT3
298: , 0 AVL_BKT4
299: , 0 AVL_BKT5
300: FROM PJI_PMV_ORGZ_DIM_TMP
301: WHERE NAME <> '-1'
302: ) GROUP BY ORGANIZATION_ID;
303:
304: FOR I IN 1..L_AVL_DAYS_SUM_TBL.COUNT

Line 681: FROM PJI_PMV_ORGZ_DIM_TMP HORG,

677: ,0 WEEK_1
678: ,0 WEEK_2
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

Line 701: FROM PJI_PMV_ORGZ_DIM_TMP HORG,

697: ,FCT.AVAILABILITY WEEK_1
698: ,0 WEEK_2
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

Line 721: FROM PJI_PMV_ORGZ_DIM_TMP HORG,

717: ,0 WEEK_1
718: ,FCT.AVAILABILITY WEEK_2
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

Line 741: FROM PJI_PMV_ORGZ_DIM_TMP HORG,

737: ,0 WEEK_1
738: ,0 WEEK_2
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

Line 761: FROM PJI_PMV_ORGZ_DIM_TMP HORG,

757: ,0 WEEK_1
758: ,0 WEEK_2
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

Line 781: FROM PJI_PMV_ORGZ_DIM_TMP

777: ,0 WEEK_1
778: ,0 WEEK_2
779: ,0 WEEK_3
780: ,0 WEEK_4
781: FROM PJI_PMV_ORGZ_DIM_TMP
782: WHERE NAME <> '-1'
783: ) GROUP BY ORGANIZATION_ID, ID;
784:
785: FOR I IN 1..L_CUR_AVL_RES_TBL.COUNT

Line 1016: FROM PJI_PMV_ORGZ_DIM_TMP HORG,

1012: , 0 CUR_AVL_2
1013: , 0 CUR_AVL_3
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

Line 1040: FROM PJI_PMV_ORGZ_DIM_TMP HORG,

1036: , DECODE (L_AVL_TYPE, 'CUMULATIVE', BCKT_4_CM,
1037: 'CONSECUTIVE', BCKT_4_CS, 0) CUR_AVL_4
1038: , DECODE (L_AVL_TYPE, 'CUMULATIVE', BCKT_5_CM,
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

Line 1063: FROM PJI_PMV_ORGZ_DIM_TMP HORG

1059: , 0 CUR_AVL_2
1060: , 0 CUR_AVL_3
1061: , 0 CUR_AVL_4
1062: , 0 CUR_AVL_5
1063: FROM PJI_PMV_ORGZ_DIM_TMP HORG
1064: WHERE NAME <> '-1')
1065: GROUP BY ORGANIZATION_ID,
1066: EXP_ORGANIZATION_ID;
1067:

Line 1354: FROM PJI_PMV_ORGZ_DIM_TMP HORG,

1350: ,(CASE WHEN (AVAILABLE_RES_COUNT_BKT5_S = 0)
1351: THEN 0 ELSE AVAILABLE_HRS_BKT5_S /
1352: DECODE(G_LABOUR_UNITS, 'DAYS', IMP.FTE_DAY, 'WEEKS',IMP.FTE_WEEK, 1) END) AVL_BKT5
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

Line 1564: FROM PJI_PMV_ORGZ_DIM_TMP HORG,

1560: , 4, AVAILABLE_RES_COUNT_BKT4_S
1561: , 5, AVAILABLE_RES_COUNT_BKT5_S
1562: , AVAILABLE_RES_COUNT_BKT5_S
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

Line 1593: FROM PJI_PMV_ORGZ_DIM_TMP HORG,

1589: ,0 REDUCE_CAP_S
1590: ,0 AVAILABLE
1591: ,0 AVAILABLE_HOURS
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

Line 1628: FROM PJI_PMV_ORGZ_DIM_TMP HORG,

1624: ) AVAILABLE
1625:
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