APPS.PJI_PMV_CAPITAL_COST dependencies on PJI_PMV_ET_RT_DIM_TMP

Line 753: , PJI_PMV_ET_RT_DIM_TMP ET

749: , 0 EXPENSE_CHANGE_PRCNT
750: from
751: PJI_PMV_TIME_DIM_TMP TIME
752: , PJI_PMV_ORGZ_DIM_TMP HORG
753: , PJI_PMV_ET_RT_DIM_TMP ET
754: , PJI_FP_ORGO_ET_F_MV FCT
755: , PJI_PMV_ORG_DIM_TMP HOU
756: where
757: FCT.ORG_ID = HOU.ID

Line 798: , PJI_PMV_ET_RT_DIM_TMP ET

794: , 0 EXPENSE_CHANGE_PRCNT
795: from
796: PJI_PMV_TCMP_DIM_TMP TIME
797: , PJI_PMV_ORGZ_DIM_TMP HORG
798: , PJI_PMV_ET_RT_DIM_TMP ET
799: , PJI_FP_ORGO_ET_F_MV FCT
800: , PJI_PMV_ORG_DIM_TMP HOU
801: where
802: FCT.ORG_ID = HOU.ID

Line 873: from PJI_PMV_ET_RT_DIM_TMP ET

869: , 0 PRCNT_OF_COST_CHANGE
870: , 0 EXPENSE
871: , 0 CT_EXPENSE
872: , 0 EXPENSE_CHANGE_PRCNT
873: from PJI_PMV_ET_RT_DIM_TMP ET
874: where ET.NAME <> '-1'
875: ) WHERE 1 = 1
876: group by ORG_ID, ORGANIZATION_ID, PROJECT_CLASS_ID, EXPENDITURE_CATEGORY,
877: EXPENDITURE_TYPE_ID, WORK_TYPE_ID;

Line 1132: , PJI_PMV_ET_RT_DIM_TMP ET

1128: , 0 EXPENSE_CHANGE_PRCNT
1129: from
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

Line 1178: , PJI_PMV_ET_RT_DIM_TMP ET

1174: , 0 EXPENSE_CHANGE_PRCNT
1175: from
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

Line 1275: from PJI_PMV_ET_RT_DIM_TMP ET

1271: , 0 PRCNT_OF_COST_CHANGE
1272: , 0 EXPENSE
1273: , 0 CT_EXPENSE
1274: , 0 EXPENSE_CHANGE_PRCNT
1275: from PJI_PMV_ET_RT_DIM_TMP ET
1276: where ET.NAME <> '-1'
1277: ) WHERE 1=1
1278: group by ORG_ID, ORGANIZATION_ID, PROJECT_CLASS_ID, EXPENDITURE_CATEGORY,
1279: EXPENDITURE_TYPE_ID, WORK_TYPE_ID;

Line 1346: , PJI_PMV_ET_RT_DIM_TMP ET

1342: , 0 EXPENSE_CHANGE_PRCNT
1343: from
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

Line 1392: , PJI_PMV_ET_RT_DIM_TMP ET

1388: , 0 EXPENSE_CHANGE_PRCNT
1389: from
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

Line 1469: PJI_PMV_ET_RT_DIM_TMP ET

1465: , 0 EXPENSE
1466: , 0 CT_EXPENSE
1467: , 0 EXPENSE_CHANGE_PRCNT
1468: from
1469: PJI_PMV_ET_RT_DIM_TMP ET
1470: where ET.NAME <> '-1'
1471: union all
1472: select '-1' as ORG_ID
1473: , '-1' as ORGANIZATION_ID

Line 1772: , PJI_PMV_ET_RT_DIM_TMP ET

1768: , 0 EXPENSE_CHANGE_PRCNT
1769: from
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

Line 1821: , PJI_PMV_ET_RT_DIM_TMP ET

1817: , 0 EXPENSE_CHANGE_PRCNT
1818: from
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

Line 1921: from PJI_PMV_ET_RT_DIM_TMP ET

1917: , 0 PRCNT_OF_COST_CHANGE
1918: , 0 EXPENSE
1919: , 0 CT_EXPENSE
1920: , 0 EXPENSE_CHANGE_PRCNT
1921: from PJI_PMV_ET_RT_DIM_TMP ET
1922: where ET.NAME <> '-1'
1923: union all
1924: select '-1' as ORG_ID
1925: , '-1' AS ORGANIZATION_ID

Line 2551: , PJI_PMV_ET_RT_DIM_TMP ET

2547: , 0 EXPENSE_CHANGE_PRCNT
2548: from
2549: PJI_PMV_TIME_DIM_TMP TIME
2550: , PJI_PMV_ORGZ_DIM_TMP HORG
2551: , PJI_PMV_ET_RT_DIM_TMP ET
2552: , PJI_FP_ORGO_ET_F_MV FCT
2553: , PJI_PMV_ORG_DIM_TMP HOU
2554: where
2555: FCT.ORG_ID = HOU.ID

Line 2591: , PJI_PMV_ET_RT_DIM_TMP ET

2587: , 0 EXPENSE_CHANGE_PRCNT
2588: from
2589: PJI_PMV_TIME_DIM_TMP TIME
2590: , PJI_PMV_ORGZ_DIM_TMP HORG
2591: , PJI_PMV_ET_RT_DIM_TMP ET
2592: , PJI_FP_ORGO_ET_F_MV FCT
2593: , PJI_PMV_ORG_DIM_TMP HOU
2594: where
2595: FCT.org_id = HOU.id

Line 2803: , PJI_PMV_ET_RT_DIM_TMP ET

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
2807: FCT.PROJECT_ORG_ID = HOU.ID

Line 2845: , PJI_PMV_ET_RT_DIM_TMP ET

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
2849: FCT.PROJECT_org_id = HOU.id

Line 2933: , PJI_PMV_ET_RT_DIM_TMP ET

2929: , 0 EXPENSE_CHANGE_PRCNT
2930: from
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

Line 2975: , PJI_PMV_ET_RT_DIM_TMP ET

2971: , 0 EXPENSE_CHANGE_PRCNT
2972: from
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

Line 3188: , PJI_PMV_ET_RT_DIM_TMP ET

3184: , 0 EXPENSE_CHANGE_PRCNT
3185: from
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

Line 3232: , PJI_PMV_ET_RT_DIM_TMP ET

3228: , 0 EXPENSE_CHANGE_PRCNT
3229: from
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

Line 3628: , PJI_PMV_ET_RT_DIM_TMP ET

3624: DECODE(G_Report_Cost_Type, 'BC', fct.burdened_cost - fct.capitalizable_brdn_cost,
3625: 'RC', fct.raw_cost - fct.capitalizable_raw_cost),0) AS EXPENSE
3626: FROM PJI_PMV_TIME_DIM_TMP TIME
3627: , PJI_PMV_PRJ_DIM_TMP PRJ
3628: , PJI_PMV_ET_RT_DIM_TMP ET
3629: , PJI_FP_PROJ_ET_F FCT
3630: , PJI_PMV_ORG_DIM_TMP HOU
3631: WHERE 1=1
3632: AND bitand(fct.curr_record_type_id, l_curr_record_type_id) = l_curr_record_type_id

Line 3740: , PJI_PMV_ET_RT_DIM_TMP ET

3736: DECODE(G_Report_Cost_Type, 'BC', fct.burdened_cost - fct.capitalizable_brdn_cost,
3737: 'RC', fct.raw_cost - fct.capitalizable_raw_cost),0) AS EXPENSE
3738: FROM PJI_PMV_TIME_DIM_TMP TIME
3739: , PJI_PMV_PRJ_DIM_TMP PRJ
3740: , PJI_PMV_ET_RT_DIM_TMP ET
3741: , PJI_FP_PROJ_ET_F FCT
3742: , PJI_PMV_ORG_DIM_TMP HOU
3743: WHERE 1=1
3744: AND bitand(fct.curr_record_type_id, l_curr_record_type_id) = l_curr_record_type_id

Line 3795: , PJI_PMV_ET_RT_DIM_TMP ET

3791: , DECODE(NVL(TIME.amount_type,1),1,
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

Line 3902: , PJI_PMV_ET_RT_DIM_TMP ET

3898: DECODE(G_Report_Cost_Type, 'BC', fct.burdened_cost - fct.capitalizable_brdn_cost,
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