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_COST dependencies on PJI_PMV_PRJ_DIM_TMP

Line 3349: DELETE pji_pmv_prj_dim_tmp;

3345: IF p_Project_IDS IS NULL THEN
3346:
3347: /*
3348: BEGIN
3349: DELETE pji_pmv_prj_dim_tmp;
3350:
3351: INSERT INTO pji_pmv_prj_dim_tmp (id, name)
3352: SELECT DISTINCT prj.project_id, '-1' name
3353: FROM

Line 3351: INSERT INTO pji_pmv_prj_dim_tmp (id, name)

3347: /*
3348: BEGIN
3349: DELETE pji_pmv_prj_dim_tmp;
3350:
3351: INSERT INTO pji_pmv_prj_dim_tmp (id, name)
3352: SELECT DISTINCT prj.project_id, '-1' name
3353: FROM
3354: pji_project_classes PJM
3355: , pji_pmv_cls_dim_tmp PTM

Line 3367: DELETE pji_pmv_prj_dim_tmp;

3363:
3364: */
3365:
3366: BEGIN
3367: DELETE pji_pmv_prj_dim_tmp;
3368:
3369: IF p_Classifications IS NOT NULL THEN
3370: INSERT INTO pji_pmv_prj_dim_tmp (id, name)
3371: SELECT DISTINCT prj.project_id, '-1' name

Line 3370: INSERT INTO pji_pmv_prj_dim_tmp (id, name)

3366: BEGIN
3367: DELETE pji_pmv_prj_dim_tmp;
3368:
3369: IF p_Classifications IS NOT NULL THEN
3370: INSERT INTO pji_pmv_prj_dim_tmp (id, name)
3371: SELECT DISTINCT prj.project_id, '-1' name
3372: FROM
3373: pji_project_classes PJM
3374: , (SELECT project_id

Line 3386: INSERT INTO pji_pmv_prj_dim_tmp (id, name)

3382: AND prj.project_id = pjc.project_id
3383: AND prj.project_id = pjm.project_id
3384: AND prj.carrying_out_organization_id = org.ID;
3385: ELSE
3386: INSERT INTO pji_pmv_prj_dim_tmp (id, name)
3387: SELECT DISTINCT prj.project_id, '-1' name
3388: FROM
3389: pji_project_classes PJM
3390: , pji_pmv_orgz_dim_tmp org

Line 3443: , PJI_PMV_PRJ_DIM_TMP PRJ

3439: DECODE(G_Report_Cost_Type, 'BC', fct.BURDENED_COST - fct.bill_burdened_cost,
3440: 'RC', fct.RAW_COST - fct.bill_raw_cost, 0), 0) AS NON_BILL_COST
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

Line 3500: , PJI_PMV_PRJ_DIM_TMP PRJ

3496: DECODE(G_Report_Cost_Type, 'BC', fct.BURDENED_COST - fct.bill_burdened_cost,
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

Line 3558: , PJI_PMV_PRJ_DIM_TMP PRJ

3554: DECODE(G_Report_Cost_Type, 'BC', fct.BURDENED_COST - fct.bill_burdened_cost,
3555: 'RC', fct.RAW_COST - fct.bill_raw_cost, 0), 0) AS NON_BILL_COST
3556:
3557: FROM PJI_PMV_TIME_DIM_TMP TIME
3558: , PJI_PMV_PRJ_DIM_TMP PRJ
3559: , PJI_PMV_ET_RT_DIM_TMP ET
3560: , PJI_FP_PROJ_ET_F FCT
3561: , PJI_PMV_ORG_DIM_TMP HOU
3562: WHERE 1=1

Line 3617: , PJI_PMV_PRJ_DIM_TMP PRJ

3613: DECODE(G_Report_Cost_Type, 'BC', fct.BURDENED_COST - fct.bill_burdened_cost,
3614: 'RC', fct.RAW_COST - fct.bill_raw_cost, 0), 0) AS NON_BILL_COST
3615:
3616: FROM PJI_PMV_TIME_DIM_TMP TIME
3617: , PJI_PMV_PRJ_DIM_TMP PRJ
3618: , PJI_PMV_WT_DIM_TMP WT
3619: , PJI_FP_PROJ_ET_WT_F FCT
3620: , PJI_PMV_ORG_DIM_TMP HOU
3621: WHERE 1=1

Line 3676: , PJI_PMV_PRJ_DIM_TMP PRJ

3672: DECODE(G_Report_Cost_Type, 'BC', fct.BURDENED_COST - fct.bill_burdened_cost,
3673: 'RC', fct.RAW_COST - fct.bill_raw_cost, 0), 0) AS NON_BILL_COST
3674:
3675: FROM PJI_PMV_TIME_DIM_TMP TIME
3676: , PJI_PMV_PRJ_DIM_TMP PRJ
3677: , PJI_PMV_ET_RT_DIM_TMP ET
3678: , PJI_FP_PROJ_ET_F FCT
3679: , PJI_PMV_ORG_DIM_TMP HOU
3680: WHERE 1=1

Line 3735: , PJI_PMV_PRJ_DIM_TMP PRJ

3731: DECODE(G_Report_Cost_Type, 'BC', fct.BURDENED_COST - fct.bill_burdened_cost,
3732: 'RC', fct.RAW_COST - fct.bill_raw_cost, 0), 0) AS NON_BILL_COST
3733:
3734: FROM PJI_PMV_TIME_DIM_TMP TIME
3735: , PJI_PMV_PRJ_DIM_TMP PRJ
3736: , PJI_PMV_ET_RT_DIM_TMP ET
3737: , PJI_PMV_WT_DIM_TMP WT
3738: , PJI_FP_PROJ_ET_WT_F FCT
3739: , PJI_PMV_ORG_DIM_TMP HOU

Line 3794: , PJI_PMV_PRJ_DIM_TMP PRJ

3790: DECODE(G_Report_Cost_Type, 'BC', fct.BURDENED_COST - fct.bill_burdened_cost,
3791: 'RC', fct.RAW_COST - fct.bill_raw_cost, 0), 0) AS NON_BILL_COST
3792:
3793: FROM PJI_PMV_TIME_DIM_TMP TIME
3794: , PJI_PMV_PRJ_DIM_TMP PRJ
3795: , PJI_PMV_WT_DIM_TMP WT
3796: , PJI_FP_PROJ_ET_WT_F FCT
3797: , PJI_PMV_ORG_DIM_TMP HOU
3798: WHERE 1=1

Line 3844: , PJI_PMV_PRJ_DIM_TMP PRJ

3840: DECODE(G_Report_Cost_Type, 'BC', fct.BURDENED_COST - fct.bill_burdened_cost,
3841: 'RC', fct.RAW_COST - fct.bill_raw_cost, 0), 0) AS NON_BILL_COST
3842:
3843: FROM PJI_PMV_TIME_DIM_TMP TIME
3844: , PJI_PMV_PRJ_DIM_TMP PRJ
3845: , PJI_PMV_ET_RT_DIM_TMP ET
3846: , PJI_PMV_WT_DIM_TMP WT
3847: , PJI_FP_PROJ_ET_WT_F FCT
3848: , PJI_PMV_ORG_DIM_TMP HOU