DBA Data[Home] [Help]

APPS.PJI_PMV_PROFITABILITY dependencies on PJI_FP_PROJ_ET_WT_F

Line 3531: , PJI_FP_PROJ_ET_WT_F FCT

3527: , NULL AS FORECAST_BURDENED_COST
3528: FROM PJI_PMV_TIME_DIM_TMP TIME
3529: , PJI_PMV_PRJ_DIM_TMP PRJ
3530: , PJI_PMV_WT_DIM_TMP WT
3531: , PJI_FP_PROJ_ET_WT_F FCT
3532: , PJI_PMV_ORG_DIM_TMP HOU
3533: WHERE 1=1
3534: AND bitand(fct.curr_record_type_id, l_curr_record_type_id) = l_curr_record_type_id
3535: AND FCT.PROJECT_ID = PRJ.ID

Line 3651: , PJI_FP_PROJ_ET_WT_F FCT

3647: FROM PJI_PMV_TIME_DIM_TMP TIME
3648: , PJI_PMV_PRJ_DIM_TMP PRJ
3649: , PJI_PMV_ET_RT_DIM_TMP ET
3650: , PJI_PMV_WT_DIM_TMP WT
3651: , PJI_FP_PROJ_ET_WT_F FCT
3652: , PJI_PMV_ORG_DIM_TMP HOU
3653: WHERE 1=1
3654: AND bitand(fct.curr_record_type_id, l_curr_record_type_id) = l_curr_record_type_id
3655: AND FCT.PROJECT_ID = PRJ.ID

Line 3714: , PJI_FP_PROJ_ET_WT_F FCT

3710: , NULL AS FORECAST_BURDENED_COST
3711: FROM PJI_PMV_TIME_DIM_TMP TIME
3712: , PJI_PMV_PRJ_DIM_TMP PRJ
3713: , PJI_PMV_WT_DIM_TMP WT
3714: , PJI_FP_PROJ_ET_WT_F FCT
3715: , PJI_PMV_ORG_DIM_TMP HOU
3716: WHERE 1=1
3717: AND bitand(fct.curr_record_type_id, l_curr_record_type_id) = l_curr_record_type_id
3718: AND FCT.PROJECT_ID = PRJ.ID

Line 3771: , PJI_FP_PROJ_ET_WT_F FCT

3767: FROM PJI_PMV_TIME_DIM_TMP TIME
3768: , PJI_PMV_PRJ_DIM_TMP PRJ
3769: , PJI_PMV_ET_RT_DIM_TMP ET
3770: , PJI_PMV_WT_DIM_TMP WT
3771: , PJI_FP_PROJ_ET_WT_F FCT
3772: , PJI_PMV_ORG_DIM_TMP HOU
3773: WHERE 1=1
3774: AND bitand(fct.curr_record_type_id, l_curr_record_type_id) = l_curr_record_type_id
3775: AND FCT.PROJECT_ID = PRJ.ID