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_WT_DIM_TMP

Line 944: , PJI_PMV_WT_DIM_TMP WT

940: , 0 EXPENSE_CHANGE_PRCNT
941: from
942: PJI_PMV_TIME_DIM_TMP TIME
943: , PJI_PMV_ORGZ_DIM_TMP HORG
944: , PJI_PMV_WT_DIM_TMP WT
945: , PJI_FP_ORGO_ET_WT_F_MV FCT
946: , PJI_PMV_ORG_DIM_TMP HOU
947: where
948: FCT.ORG_ID = HOU.ID

Line 988: , PJI_PMV_WT_DIM_TMP WT

984: , 0 EXPENSE_CHANGE_PRCNT
985: from
986: PJI_PMV_TCMP_DIM_TMP TIME
987: , PJI_PMV_ORGZ_DIM_TMP HORG
988: , PJI_PMV_WT_DIM_TMP WT
989: , PJI_FP_ORGO_ET_WT_F_MV FCT
990: , PJI_PMV_ORG_DIM_TMP HOU
991: where
992: FCT.ORG_ID = HOU.ID

Line 1062: from PJI_PMV_WT_DIM_TMP WT

1058: , 0 PRCNT_OF_COST_CHANGE
1059: , 0 EXPENSE
1060: , 0 CT_EXPENSE
1061: , 0 EXPENSE_CHANGE_PRCNT
1062: from PJI_PMV_WT_DIM_TMP WT
1063: where WT.NAME <> '-1'
1064: )
1065: group by ORG_ID, ORGANIZATION_ID, PROJECT_CLASS_ID, EXPENDITURE_CATEGORY,
1066: EXPENDITURE_TYPE_ID, WORK_TYPE_ID;

Line 1348: , PJI_PMV_WT_DIM_TMP WT

1344: PJI_PMV_TIME_DIM_TMP TIME
1345: , PJI_PMV_ORGZ_DIM_TMP HORG
1346: , PJI_PMV_ET_RT_DIM_TMP ET
1347: , PJI_FP_ORGO_ET_WT_F_MV FCT
1348: , PJI_PMV_WT_DIM_TMP WT
1349: , PJI_PMV_ORG_DIM_TMP HOU
1350: where
1351: FCT.ORG_ID = HOU.ID
1352: and FCT.ORGANIZATION_ID = HORG.ID

Line 1394: , PJI_PMV_WT_DIM_TMP WT

1390: PJI_PMV_TCMP_DIM_TMP TIME
1391: , PJI_PMV_ORGZ_DIM_TMP HORG
1392: , PJI_PMV_ET_RT_DIM_TMP ET
1393: , PJI_FP_ORGO_ET_WT_F_MV FCT
1394: , PJI_PMV_WT_DIM_TMP WT
1395: , PJI_PMV_ORG_DIM_TMP HOU
1396: where
1397: FCT.ORG_ID = HOU.ID
1398: and FCT.ORGANIZATION_ID = HORG.ID

Line 1491: PJI_PMV_WT_DIM_TMP WT

1487: , 0 EXPENSE
1488: , 0 CT_EXPENSE
1489: , 0 EXPENSE_CHANGE_PRCNT
1490: from
1491: PJI_PMV_WT_DIM_TMP WT
1492: where WT.NAME <> '-1'
1493: ) WHERE 1=1
1494: group by ORG_ID, ORGANIZATION_ID, PROJECT_CLASS_ID, EXPENDITURE_CATEGORY,
1495: EXPENDITURE_TYPE_ID, WORK_TYPE_ID;

Line 1563: , PJI_PMV_WT_DIM_TMP WT

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
1566: FCT.PROJECT_ORG_ID = HOU.ID
1567: and FCT.PROJECT_ORGANIZATION_ID = HORG.ID

Line 1609: , PJI_PMV_WT_DIM_TMP WT

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
1612: FCT.PROJECT_ORG_ID = HOU.ID
1613: and FCT.PROJECT_ORGANIZATION_ID = HORG.ID

Line 1704: from PJI_PMV_WT_DIM_TMP WT

1700: , 0 PRCNT_OF_COST_CHANGE
1701: , 0 EXPENSE
1702: , 0 CT_EXPENSE
1703: , 0 EXPENSE_CHANGE_PRCNT
1704: from PJI_PMV_WT_DIM_TMP WT
1705: where WT.NAME <> '-1'
1706: ) group by ORG_ID, ORGANIZATION_ID, PROJECT_CLASS_ID, EXPENDITURE_CATEGORY,
1707: EXPENDITURE_TYPE_ID,WORK_TYPE_ID;
1708:

Line 1775: , PJI_PMV_WT_DIM_TMP WT

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
1779: and FCT.PROJECT_ORGANIZATION_ID = HORG.ID

Line 1824: , PJI_PMV_WT_DIM_TMP WT

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
1828: and FCT.PROJECT_ORGANIZATION_ID = HORG.ID

Line 1942: from PJI_PMV_WT_DIM_TMP WT

1938: , 0 PRCNT_OF_COST_CHANGE
1939: , 0 EXPENSE
1940: , 0 CT_EXPENSE
1941: , 0 EXPENSE_CHANGE_PRCNT
1942: from PJI_PMV_WT_DIM_TMP WT
1943: where WT.NAME <> '-1'
1944: ) where 1=1
1945: group by ORG_ID, ORGANIZATION_ID, PROJECT_CLASS_ID, EXPENDITURE_CATEGORY,
1946: EXPENDITURE_TYPE_ID, WORK_TYPE_ID;

Line 2678: , PJI_PMV_WT_DIM_TMP WT

2674: , 0 EXPENSE_CHANGE_PRCNT
2675: from
2676: PJI_PMV_TIME_DIM_TMP TIME
2677: , PJI_PMV_ORGZ_DIM_TMP HORG
2678: , PJI_PMV_WT_DIM_TMP WT
2679: , PJI_FP_ORGO_ET_WT_F_MV FCT
2680: , PJI_PMV_ORG_DIM_TMP HOU
2681: where
2682: FCT.ORG_ID = HOU.ID

Line 2717: , PJI_PMV_WT_DIM_TMP WT

2713: , 0 EXPENSE_CHANGE_PRCNT
2714: from
2715: PJI_PMV_TIME_DIM_TMP TIME
2716: , PJI_PMV_ORGZ_DIM_TMP HORG
2717: , PJI_PMV_WT_DIM_TMP WT
2718: , PJI_FP_ORGO_ET_WT_F_MV FCT
2719: , PJI_PMV_ORG_DIM_TMP HOU
2720: where
2721: FCT.org_id = HOU.id

Line 2935: , PJI_PMV_WT_DIM_TMP WT

2931: PJI_PMV_TIME_DIM_TMP TIME
2932: , PJI_PMV_ORGZ_DIM_TMP HORG
2933: , PJI_PMV_ET_RT_DIM_TMP ET
2934: , PJI_FP_ORGO_ET_WT_F_MV FCT
2935: , PJI_PMV_WT_DIM_TMP WT
2936: , PJI_PMV_ORG_DIM_TMP HOU
2937: where
2938: FCT.ORG_ID = HOU.ID
2939: AND FCT.ORGANIZATION_ID = HORG.ID

Line 2977: , PJI_PMV_WT_DIM_TMP WT

2973: PJI_PMV_TIME_DIM_TMP TIME
2974: , PJI_PMV_ORGZ_DIM_TMP HORG
2975: , PJI_PMV_ET_RT_DIM_TMP ET
2976: , PJI_FP_ORGO_ET_WT_F_MV FCT
2977: , PJI_PMV_WT_DIM_TMP WT
2978: , PJI_PMV_ORG_DIM_TMP HOU
2979: where
2980: FCT.org_id = HOU.id
2981: and FCT.organization_id = HORG.id

Line 3065: , PJI_PMV_WT_DIM_TMP WT

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

Line 3106: , PJI_PMV_WT_DIM_TMP WT

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
3109: FCT.PROJECT_org_id = HOU.id
3110: and FCT.PROJECT_organization_id = HORG.id

Line 3191: , PJI_PMV_WT_DIM_TMP WT

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
3195: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID

Line 3235: , PJI_PMV_WT_DIM_TMP WT

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
3239: and FCT.PROJECT_organization_id = HORG.id

Line 3683: , PJI_PMV_WT_DIM_TMP WT

3679: , DECODE(NVL(TIME.amount_type,1),1,
3680: DECODE(G_Report_Cost_Type, 'BC', fct.burdened_cost - fct.capitalizable_brdn_cost,
3681: 'RC', fct.raw_cost - fct.capitalizable_raw_cost),0) AS EXPENSE
3682: FROM PJI_PMV_TIME_DIM_TMP TIME
3683: , PJI_PMV_WT_DIM_TMP WT
3684: , PJI_PMV_PRJ_DIM_TMP PRJ
3685: , PJI_FP_PROJ_ET_WT_F FCT
3686: , PJI_PMV_ORG_DIM_TMP HOU
3687: WHERE 1=1

Line 3796: , PJI_PMV_WT_DIM_TMP WT

3792: DECODE(G_Report_Cost_Type, 'BC', fct.burdened_cost - fct.capitalizable_brdn_cost,
3793: 'RC', fct.raw_cost - fct.capitalizable_raw_cost),0) AS EXPENSE
3794: FROM PJI_PMV_TIME_DIM_TMP TIME
3795: , PJI_PMV_ET_RT_DIM_TMP ET
3796: , PJI_PMV_WT_DIM_TMP WT
3797: , PJI_PMV_PRJ_DIM_TMP PRJ
3798: , PJI_FP_PROJ_ET_WT_F FCT
3799: , PJI_PMV_ORG_DIM_TMP HOU
3800: WHERE 1=1

Line 3855: , PJI_PMV_WT_DIM_TMP WT

3851: DECODE(G_Report_Cost_Type, 'BC', fct.burdened_cost - fct.capitalizable_brdn_cost,
3852: 'RC', fct.raw_cost - fct.capitalizable_raw_cost), 0) AS EXPENSE
3853: FROM PJI_PMV_TIME_DIM_TMP TIME
3854: , PJI_PMV_PRJ_DIM_TMP PRJ
3855: , PJI_PMV_WT_DIM_TMP WT
3856: , PJI_FP_PROJ_ET_WT_F FCT
3857: , PJI_PMV_ORG_DIM_TMP HOU
3858: WHERE 1=1
3859: AND bitand(fct.curr_record_type_id, l_curr_record_type_id) = l_curr_record_type_id

Line 3903: , PJI_PMV_WT_DIM_TMP WT

3899: 'RC', fct.raw_cost - fct.capitalizable_raw_cost),0) AS EXPENSE
3900: FROM PJI_PMV_TIME_DIM_TMP TIME
3901: , PJI_PMV_PRJ_DIM_TMP PRJ
3902: , PJI_PMV_ET_RT_DIM_TMP ET
3903: , PJI_PMV_WT_DIM_TMP WT
3904: , PJI_FP_PROJ_ET_WT_F FCT
3905: , PJI_PMV_ORG_DIM_TMP HOU
3906: WHERE 1=1
3907: AND bitand(fct.curr_record_type_id, l_curr_record_type_id) = l_curr_record_type_id