DBA Data[Home] [Help]

APPS.PJI_PMV_PROFITABILITY dependencies on PJI_PMV_TCMP_DIM_TMP

Line 4225: PJI_PMV_TCMP_DIM_TMP TIME

4221: , DECODE(TIME.amount_type,2,
4222: DECODE(G_Report_Cost_Type, 'BC', fct.forecast_burdened_cost,
4223: 'RC', fct.forecast_raw_cost, 0),0) AS CT_FORECAST_BURDENED_COST
4224: FROM
4225: PJI_PMV_TCMP_DIM_TMP TIME
4226: , PJI_PMV_ORGZ_DIM_TMP HORG
4227: , PJI_FP_ORGO_F_MV fct
4228: , PJI_PMV_ORG_DIM_TMP HOU
4229: WHERE

Line 4421: PJI_PMV_TCMP_DIM_TMP TIME

4417: 'RC', fct.forecast_raw_cost, 0), 0) AS
4418:
4419: CT_FORECAST_BURDENED_COST
4420: FROM
4421: PJI_PMV_TCMP_DIM_TMP TIME
4422: , PJI_PMV_ORGZ_DIM_TMP HORG
4423: , PJI_PMV_CLS_DIM_TMP CLS
4424: , PJI_FP_CLSO_F_MV fct
4425: , PJI_PMV_ORG_DIM_TMP HOU

Line 4622: PJI_PMV_TCMP_DIM_TMP TIME

4618: 'RC', fct.raw_cost, 0), 0) AS CT_BURDENED_COST
4619: , NULL AS CT_FORECAST_REVENUE
4620: , NULL AS CT_FORECAST_BURDENED_COST
4621: FROM
4622: PJI_PMV_TCMP_DIM_TMP TIME
4623: , PJI_PMV_ORGZ_DIM_TMP HORG
4624: , PJI_PMV_ET_RT_DIM_TMP ET
4625: , PJI_FP_ORGO_ET_F_MV fct
4626: , PJI_PMV_ORG_DIM_TMP HOU

Line 4823: PJI_PMV_TCMP_DIM_TMP TIME

4819: 'RC', fct.raw_cost, 0), 0) AS CT_BURDENED_COST
4820: , NULL AS CT_FORECAST_REVENUE
4821: , NULL AS CT_FORECAST_BURDENED_COST
4822: FROM
4823: PJI_PMV_TCMP_DIM_TMP TIME
4824: , PJI_PMV_ORGZ_DIM_TMP HORG
4825: , PJI_PMV_WT_DIM_TMP WT
4826: , PJI_FP_ORGO_ET_WT_F_MV fct
4827: , PJI_PMV_ORG_DIM_TMP HOU

Line 5027: PJI_PMV_TCMP_DIM_TMP TIME

5023: 'RC', fct.raw_cost, 0), 0) AS CT_BURDENED_COST
5024: , NULL AS CT_FORECAST_REVENUE
5025: , NULL AS CT_FORECAST_BURDENED_COST
5026: FROM
5027: PJI_PMV_TCMP_DIM_TMP TIME
5028: , PJI_PMV_ORGZ_DIM_TMP HORG
5029: , PJI_PMV_CLS_DIM_TMP CLS
5030: , PJI_PMV_ET_RT_DIM_TMP ET
5031: , PJI_FP_CLSO_ET_F_MV fct

Line 5254: PJI_PMV_TCMP_DIM_TMP TIME

5250: 'RC', fct.raw_cost, 0), 0) AS CT_BURDENED_COST
5251: , NULL AS CT_FORECAST_REVENUE
5252: , NULL AS CT_FORECAST_BURDENED_COST
5253: FROM
5254: PJI_PMV_TCMP_DIM_TMP TIME
5255: , PJI_PMV_ORGZ_DIM_TMP HORG
5256: , PJI_PMV_ET_RT_DIM_TMP ET
5257: , PJI_PMV_WT_DIM_TMP WT
5258: , PJI_FP_ORGO_ET_WT_F_MV fct

Line 5481: PJI_PMV_TCMP_DIM_TMP TIME

5477: 'RC', fct.raw_cost, 0), 0) AS CT_BURDENED_COST
5478: , NULL AS CT_FORECAST_REVENUE
5479: , NULL AS CT_FORECAST_BURDENED_COST
5480: FROM
5481: PJI_PMV_TCMP_DIM_TMP TIME
5482: , PJI_PMV_ORGZ_DIM_TMP HORG
5483: , PJI_PMV_CLS_DIM_TMP CLS
5484: , PJI_PMV_WT_DIM_TMP WT
5485: , PJI_FP_CLSO_ET_WT_F_MV fct

Line 5711: PJI_PMV_TCMP_DIM_TMP TIME

5707: 'RC', fct.raw_cost, 0), 0) AS CT_BURDENED_COST
5708: , NULL AS CT_FORECAST_REVENUE
5709: , NULL AS CT_FORECAST_BURDENED_COST
5710: FROM
5711: PJI_PMV_TCMP_DIM_TMP TIME
5712: , PJI_PMV_ORGZ_DIM_TMP HORG
5713: , PJI_PMV_CLS_DIM_TMP CLS
5714: , PJI_PMV_ET_RT_DIM_TMP ET
5715: , PJI_PMV_WT_DIM_TMP WT