eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_PMV_PROFITABILITY dependencies on PJI_PMV_PRJ_DIM_TMP

Line 3139: ** then the pji_pmv_prj_dim_tmp is populated on the fly and joined in the SQL

3135: ** the collection logic does not address view-by logic requirements.
3136: **
3137: ** Also, double counting, which may occur if class codes are specified,
3138: ** is NOT permitted for these reports. As a result, if class codes are specified,
3139: ** then the pji_pmv_prj_dim_tmp is populated on the fly and joined in the SQL
3140: ** to prevent double counting.
3141: **
3142: ** Issues:
3143: **

Line 3264: DELETE pji_pmv_prj_dim_tmp;

3260: ** project_class mapping table. The intersection table is equi-joined in the following
3261: ** select statement.
3262: */
3263: BEGIN
3264: DELETE pji_pmv_prj_dim_tmp;
3265:
3266: if(l_Convert_Classification = 'Y') then
3267: INSERT into pji_pmv_prj_dim_tmp (id, name)
3268: SELECT DISTINCT prj.project_id, '-1' name

Line 3267: INSERT into pji_pmv_prj_dim_tmp (id, name)

3263: BEGIN
3264: DELETE pji_pmv_prj_dim_tmp;
3265:
3266: if(l_Convert_Classification = 'Y') then
3267: INSERT into pji_pmv_prj_dim_tmp (id, name)
3268: SELECT DISTINCT prj.project_id, '-1' name
3269: FROM
3270: pji_project_classes PJM
3271: , pji_pmv_cls_dim_tmp PTM

Line 3279: INSERT into pji_pmv_prj_dim_tmp (id, name)

3275: pjm.project_class_id = ptm.id
3276: AND prj.project_id = pjm.project_id
3277: AND prj.carrying_out_organization_id = org.ID;
3278: else
3279: INSERT into pji_pmv_prj_dim_tmp (id, name)
3280: SELECT DISTINCT prj.project_id, '-1' name
3281: FROM
3282: pji_pmv_orgz_dim_tmp org
3283: , pa_projects_all prj

Line 3347: , PJI_PMV_PRJ_DIM_TMP PRJ

3343: , DECODE(TIME.amount_type,2,
3344: DECODE(G_Report_Cost_Type, 'BC', fct.forecast_burdened_cost,
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

Line 3411: , PJI_PMV_PRJ_DIM_TMP PRJ

3407: , DECODE(TIME.amount_type,2,
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

Line 3467: , PJI_PMV_PRJ_DIM_TMP PRJ

3463: , NULL AS CURR_BGT_BURDENED_COST
3464: , NULL AS FORECAST_REVENUE
3465: , NULL AS FORECAST_BURDENED_COST
3466: FROM PJI_PMV_TIME_DIM_TMP TIME
3467: , PJI_PMV_PRJ_DIM_TMP PRJ
3468: , PJI_PMV_ET_RT_DIM_TMP ET
3469: , PJI_FP_PROJ_ET_F FCT
3470: , PJI_PMV_ORG_DIM_TMP HOU
3471: WHERE 1=1

Line 3529: , PJI_PMV_PRJ_DIM_TMP PRJ

3525: , NULL AS CURR_BGT_BURDENED_COST
3526: , NULL AS FORECAST_REVENUE
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

Line 3587: , PJI_PMV_PRJ_DIM_TMP PRJ

3583: , NULL AS CURR_BGT_BURDENED_COST
3584: , NULL AS FORECAST_REVENUE
3585: , NULL AS FORECAST_BURDENED_COST
3586: FROM PJI_PMV_TIME_DIM_TMP TIME
3587: , PJI_PMV_PRJ_DIM_TMP PRJ
3588: , PJI_PMV_ET_RT_DIM_TMP ET
3589: , PJI_FP_PROJ_ET_F FCT
3590: , PJI_PMV_ORG_DIM_TMP HOU
3591: WHERE 1=1

Line 3648: , PJI_PMV_PRJ_DIM_TMP PRJ

3644: , NULL AS CURR_BGT_BURDENED_COST
3645: , NULL AS FORECAST_REVENUE
3646: , NULL AS FORECAST_BURDENED_COST
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

Line 3712: , PJI_PMV_PRJ_DIM_TMP PRJ

3708: , NULL AS CURR_BGT_BURDENED_COST
3709: , NULL AS FORECAST_REVENUE
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

Line 3768: , PJI_PMV_PRJ_DIM_TMP PRJ

3764: , NULL AS CURR_BGT_BURDENED_COST
3765: , NULL AS FORECAST_REVENUE
3766: , NULL AS FORECAST_BURDENED_COST
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