DBA Data[Home] [Help]

APPS.PJI_PMV_PROFITABILITY dependencies on PJI_FP_PROJ_F

Line 3349: , PJI_FP_PROJ_F FCT

3345: 'RC', fct.forecast_raw_cost, 0), 0) AS FORECAST_BURDENED_COST
3346: FROM PJI_PMV_TIME_DIM_TMP TIME
3347: , PJI_PMV_PRJ_DIM_TMP PRJ
3348: , PJI_PMV_ORGZ_DIM_TMP HORG
3349: , PJI_FP_PROJ_F FCT
3350: , PJI_PMV_ORG_DIM_TMP HOU
3351: WHERE 1=1
3352: AND bitand(fct.curr_record_type_id, l_curr_record_type_id) = l_curr_record_type_id
3353: AND FCT.PROJECT_ID = PRJ.ID

Line 3412: , PJI_FP_PROJ_F FCT

3408: DECODE(G_Report_Cost_Type, 'BC', fct.forecast_burdened_cost,
3409: 'RC', fct.forecast_raw_cost, 0), 0) AS FORECAST_BURDENED_COST
3410: FROM PJI_PMV_TIME_DIM_TMP TIME
3411: , PJI_PMV_PRJ_DIM_TMP PRJ
3412: , PJI_FP_PROJ_F FCT
3413: , PJI_PMV_ORG_DIM_TMP HOU
3414: WHERE 1=1
3415: AND bitand(fct.curr_record_type_id, l_curr_record_type_id) = l_curr_record_type_id
3416: AND FCT.PROJECT_ID = PRJ.ID