DBA Data[Home] [Help]

APPS.PJI_PMV_COST dependencies on PJI_FP_PROJ_F

Line 3445: , PJI_FP_PROJ_F FCT

3441:
3442: FROM PJI_PMV_TIME_DIM_TMP TIME
3443: , PJI_PMV_PRJ_DIM_TMP PRJ
3444: , PJI_PMV_ORGZ_DIM_TMP HORG
3445: , PJI_FP_PROJ_F FCT
3446: , PJI_PMV_ORG_DIM_TMP HOU
3447: WHERE 1=1
3448: AND bitand(fct.curr_record_type_id, l_curr_record_type_id) = l_curr_record_type_id
3449: AND FCT.PROJECT_ID = PRJ.ID

Line 3501: , PJI_FP_PROJ_F FCT

3497: 'RC', fct.RAW_COST - fct.bill_raw_cost, 0), 0) AS NON_BILL_COST
3498:
3499: FROM PJI_PMV_TIME_DIM_TMP TIME
3500: , PJI_PMV_PRJ_DIM_TMP PRJ
3501: , PJI_FP_PROJ_F FCT
3502: , PJI_PMV_ORG_DIM_TMP HOU
3503: WHERE 1=1
3504: AND bitand(fct.curr_record_type_id, l_curr_record_type_id) = l_curr_record_type_id
3505: AND FCT.PROJECT_ID = PRJ.ID