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_CAPITAL_COST dependencies on PJI_PMV_CLS_DIM_TMP

Line 564: , PJI_PMV_CLS_DIM_TMP CLS

560: , 0 EXPENSE_CHANGE_PRCNT
561: from
562: PJI_PMV_TIME_DIM_TMP TIME
563: , PJI_PMV_ORGZ_DIM_TMP HORG
564: , PJI_PMV_CLS_DIM_TMP CLS
565: , PJI_FP_CLSO_F_MV FCT
566: , PJI_PMV_ORG_DIM_TMP HOU
567: where
568: fct.PROJECT_ORG_ID = HOU.ID

Line 608: , PJI_PMV_CLS_DIM_TMP CLS

604: , 0 EXPENSE_CHANGE_PRCNT
605: from
606: PJI_PMV_TCMP_DIM_TMP TIME
607: , PJI_PMV_ORGZ_DIM_TMP HORG
608: , PJI_PMV_CLS_DIM_TMP CLS
609: , PJI_FP_CLSO_F_MV FCT
610: , PJI_PMV_ORG_DIM_TMP HOU
611: where
612: FCT.PROJECT_ORG_ID = HOU.ID

Line 682: from PJI_PMV_CLS_DIM_TMP CLS

678: , 0 PRCNT_OF_COST_CHANGE
679: , 0 EXPENSE
680: , 0 CT_EXPENSE
681: , 0 EXPENSE_CHANGE_PRCNT
682: from PJI_PMV_CLS_DIM_TMP CLS
683: where CLS.NAME <> '-1'
684: ) WHERE 1 = 1
685: group by ORG_ID, ORGANIZATION_ID, PROJECT_CLASS_ID,
686: EXPENDITURE_CATEGORY, EXPENDITURE_TYPE_ID, WORK_TYPE_ID;

Line 1134: , PJI_PMV_CLS_DIM_TMP CLS

1130: PJI_PMV_TIME_DIM_TMP TIME
1131: , PJI_PMV_ORGZ_DIM_TMP HORG
1132: , PJI_PMV_ET_RT_DIM_TMP ET
1133: , PJI_FP_CLSO_ET_F_MV FCT
1134: , PJI_PMV_CLS_DIM_TMP CLS
1135: , PJI_PMV_ORG_DIM_TMP HOU
1136: where
1137: FCT.PROJECT_ORG_ID = HOU.ID
1138: and FCT.PROJECT_ORGANIZATION_ID = HORG.ID

Line 1180: , PJI_PMV_CLS_DIM_TMP CLS

1176: PJI_PMV_TCMP_DIM_TMP TIME
1177: , PJI_PMV_ORGZ_DIM_TMP HORG
1178: , PJI_PMV_ET_RT_DIM_TMP ET
1179: , PJI_FP_CLSO_ET_F_MV FCT
1180: , PJI_PMV_CLS_DIM_TMP CLS
1181: , PJI_PMV_ORG_DIM_TMP HOU
1182: where
1183: FCT.PROJECT_ORG_ID = HOU.ID
1184: and FCT.PROJECT_ORGANIZATION_ID = HORG.ID

Line 1254: from PJI_PMV_CLS_DIM_TMP CLS

1250: , 0 PRCNT_OF_COST_CHANGE
1251: , 0 EXPENSE
1252: , 0 CT_EXPENSE
1253: , 0 EXPENSE_CHANGE_PRCNT
1254: from PJI_PMV_CLS_DIM_TMP CLS
1255: where CLS.NAME <> '-1'
1256: union all -- FORCE Creation of Expenditure Category/Type Rows
1257: select '-1' as ORG_ID
1258: , '-1' as ORGANIZATION_ID

Line 1561: , PJI_PMV_CLS_DIM_TMP CLS

1557: , 0 EXPENSE_CHANGE_PRCNT
1558: from
1559: PJI_PMV_TIME_DIM_TMP TIME
1560: , PJI_PMV_ORGZ_DIM_TMP HORG
1561: , PJI_PMV_CLS_DIM_TMP CLS
1562: , PJI_FP_CLSO_ET_WT_F_MV FCT
1563: , PJI_PMV_WT_DIM_TMP WT
1564: , PJI_PMV_ORG_DIM_TMP HOU
1565: where

Line 1607: , PJI_PMV_CLS_DIM_TMP CLS

1603: , 0 EXPENSE_CHANGE_PRCNT
1604: from
1605: PJI_PMV_TCMP_DIM_TMP TIME
1606: , PJI_PMV_ORGZ_DIM_TMP HORG
1607: , PJI_PMV_CLS_DIM_TMP CLS
1608: , PJI_FP_CLSO_ET_WT_F_MV FCT
1609: , PJI_PMV_WT_DIM_TMP WT
1610: , PJI_PMV_ORG_DIM_TMP HOU
1611: where

Line 1683: from PJI_PMV_CLS_DIM_TMP CLS

1679: , 0 PRCNT_OF_COST_CHANGE
1680: , 0 EXPENSE
1681: , 0 CT_EXPENSE
1682: , 0 EXPENSE_CHANGE_PRCNT
1683: from PJI_PMV_CLS_DIM_TMP CLS
1684: where CLS.NAME <> '-1'
1685: union all -- FORCE Creation of Org rows
1686: select '-1' AS ORG_ID
1687: , '-1' AS ORGANIZATION_ID

Line 1774: , PJI_PMV_CLS_DIM_TMP CLS

1770: PJI_PMV_TIME_DIM_TMP TIME
1771: , PJI_PMV_ORGZ_DIM_TMP HORG
1772: , PJI_PMV_ET_RT_DIM_TMP ET
1773: , PJI_FP_CLSO_ET_WT_F_MV FCT
1774: , PJI_PMV_CLS_DIM_TMP CLS
1775: , PJI_PMV_WT_DIM_TMP WT
1776: , PJI_PMV_ORG_DIM_TMP HOU
1777: where
1778: FCT.PROJECT_ORG_ID = HOU.ID

Line 1823: , PJI_PMV_CLS_DIM_TMP CLS

1819: PJI_PMV_TCMP_DIM_TMP TIME
1820: , PJI_PMV_ORGZ_DIM_TMP HORG
1821: , PJI_PMV_ET_RT_DIM_TMP ET
1822: , PJI_FP_CLSO_ET_WT_F_MV FCT
1823: , PJI_PMV_CLS_DIM_TMP CLS
1824: , PJI_PMV_WT_DIM_TMP WT
1825: , PJI_PMV_ORG_DIM_TMP HOU
1826: where
1827: FCT.PROJECT_ORG_ID = HOU.ID

Line 1900: from PJI_PMV_CLS_DIM_TMP CLS

1896: , 0 PRCNT_OF_COST_CHANGE
1897: , 0 EXPENSE
1898: , 0 CT_EXPENSE
1899: , 0 EXPENSE_CHANGE_PRCNT
1900: from PJI_PMV_CLS_DIM_TMP CLS
1901: where CLS.NAME <> '-1'
1902: union all
1903: select '-1' as ORG_ID
1904: , '-1' AS ORGANIZATION_ID

Line 2427: , PJI_PMV_CLS_DIM_TMP CLS

2423: , 0 EXPENSE_CHANGE_PRCNT
2424: from
2425: PJI_PMV_TIME_DIM_TMP TIME
2426: , PJI_PMV_ORGZ_DIM_TMP HORG
2427: , PJI_PMV_CLS_DIM_TMP CLS
2428: , PJI_FP_CLSO_F_MV FCT
2429: , PJI_PMV_ORG_DIM_TMP HOU
2430: where
2431: FCT.PROJECT_ORG_ID = HOU.ID

Line 2466: , PJI_PMV_CLS_DIM_TMP CLS

2462: , 0 EXPENSE_CHANGE_PRCNT
2463: from
2464: PJI_PMV_TIME_DIM_TMP TIME
2465: , PJI_PMV_ORGZ_DIM_TMP HORG
2466: , PJI_PMV_CLS_DIM_TMP CLS
2467: , PJI_FP_CLSO_F_MV FCT
2468: , PJI_PMV_ORG_DIM_TMP HOU
2469: where
2470: FCT.PROJECT_org_id = HOU.id

Line 2802: , PJI_PMV_CLS_DIM_TMP CLS

2798: , 0 EXPENSE_CHANGE_PRCNT
2799: from
2800: PJI_PMV_TIME_DIM_TMP TIME
2801: , PJI_PMV_ORGZ_DIM_TMP HORG
2802: , PJI_PMV_CLS_DIM_TMP CLS
2803: , PJI_PMV_ET_RT_DIM_TMP ET
2804: , PJI_FP_CLSO_ET_F_MV FCT
2805: , PJI_PMV_ORG_DIM_TMP HOU
2806: where

Line 2844: , PJI_PMV_CLS_DIM_TMP CLS

2840: , 0 EXPENSE_CHANGE_PRCNT
2841: from
2842: PJI_PMV_TIME_DIM_TMP TIME
2843: , PJI_PMV_ORGZ_DIM_TMP HORG
2844: , PJI_PMV_CLS_DIM_TMP CLS
2845: , PJI_PMV_ET_RT_DIM_TMP ET
2846: , PJI_FP_CLSO_ET_F_MV FCT
2847: , PJI_PMV_ORG_DIM_TMP HOU
2848: where

Line 3063: , PJI_PMV_CLS_DIM_TMP CLS

3059: , 0 EXPENSE_CHANGE_PRCNT
3060: from
3061: PJI_PMV_TIME_DIM_TMP TIME
3062: , PJI_PMV_ORGZ_DIM_TMP HORG
3063: , PJI_PMV_CLS_DIM_TMP CLS
3064: , PJI_FP_CLSO_ET_WT_F_MV FCT
3065: , PJI_PMV_WT_DIM_TMP WT
3066: , PJI_PMV_ORG_DIM_TMP HOU
3067: where

Line 3104: , PJI_PMV_CLS_DIM_TMP CLS

3100: , 0 EXPENSE_CHANGE_PRCNT
3101: from
3102: PJI_PMV_TIME_DIM_TMP TIME
3103: , PJI_PMV_ORGZ_DIM_TMP HORG
3104: , PJI_PMV_CLS_DIM_TMP CLS
3105: , PJI_FP_CLSO_ET_WT_F_MV FCT
3106: , PJI_PMV_WT_DIM_TMP WT
3107: , PJI_PMV_ORG_DIM_TMP HOU
3108: where

Line 3190: , PJI_PMV_CLS_DIM_TMP CLS

3186: PJI_PMV_TIME_DIM_TMP TIME
3187: , PJI_PMV_ORGZ_DIM_TMP HORG
3188: , PJI_PMV_ET_RT_DIM_TMP ET
3189: , PJI_FP_CLSO_ET_WT_F_MV FCT
3190: , PJI_PMV_CLS_DIM_TMP CLS
3191: , PJI_PMV_WT_DIM_TMP WT
3192: , PJI_PMV_ORG_DIM_TMP HOU
3193: where
3194: FCT.PROJECT_ORG_ID = HOU.ID

Line 3234: , PJI_PMV_CLS_DIM_TMP CLS

3230: PJI_PMV_TIME_DIM_TMP TIME
3231: , PJI_PMV_ORGZ_DIM_TMP HORG
3232: , PJI_PMV_ET_RT_DIM_TMP ET
3233: , PJI_FP_CLSO_ET_WT_F_MV FCT
3234: , PJI_PMV_CLS_DIM_TMP CLS
3235: , PJI_PMV_WT_DIM_TMP WT
3236: , PJI_PMV_ORG_DIM_TMP HOU
3237: where
3238: FCT.PROJECT_org_id = HOU.id

Line 3432: , pji_pmv_cls_dim_tmp PTM

3428: INSERT INTO pji_pmv_prj_dim_tmp (id, name)
3429: SELECT DISTINCT prj.project_id, '-1' name
3430: FROM
3431: pji_project_classes PJM
3432: , pji_pmv_cls_dim_tmp PTM
3433: , pji_pmv_orgz_dim_tmp org
3434: , pa_projects_all prj
3435: WHERE
3436: pjm.project_class_id = ptm.id

Line 3454: , pji_pmv_cls_dim_tmp PTM

3450: pji_project_classes PJM
3451: , (SELECT project_id
3452: FROM pji_project_classes
3453: WHERE class_category = '$PROJECT_TYPE$CAPITAL') PJC
3454: , pji_pmv_cls_dim_tmp PTM
3455: , pji_pmv_orgz_dim_tmp org
3456: , pa_projects_all prj
3457: WHERE 1=1
3458: AND pjm.project_class_id = ptm.id