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

Line 3426: DELETE pji_pmv_prj_dim_tmp;

3422: IF p_Project_IDS IS NULL THEN
3423:
3424: /*
3425: BEGIN
3426: DELETE pji_pmv_prj_dim_tmp;
3427:
3428: INSERT INTO pji_pmv_prj_dim_tmp (id, name)
3429: SELECT DISTINCT prj.project_id, '-1' name
3430: FROM

Line 3428: INSERT INTO pji_pmv_prj_dim_tmp (id, name)

3424: /*
3425: BEGIN
3426: DELETE pji_pmv_prj_dim_tmp;
3427:
3428: INSERT INTO pji_pmv_prj_dim_tmp (id, name)
3429: SELECT DISTINCT prj.project_id, '-1' name
3430: FROM
3431: pji_project_classes PJM
3432: , pji_pmv_cls_dim_tmp PTM

Line 3444: DELETE pji_pmv_prj_dim_tmp;

3440:
3441: */
3442:
3443: BEGIN
3444: DELETE pji_pmv_prj_dim_tmp;
3445:
3446: IF p_Classifications IS NOT NULL THEN
3447: INSERT INTO pji_pmv_prj_dim_tmp (id, name)
3448: SELECT DISTINCT prj.project_id, '-1' name

Line 3447: INSERT INTO pji_pmv_prj_dim_tmp (id, name)

3443: BEGIN
3444: DELETE pji_pmv_prj_dim_tmp;
3445:
3446: IF p_Classifications IS NOT NULL THEN
3447: INSERT INTO pji_pmv_prj_dim_tmp (id, name)
3448: SELECT DISTINCT prj.project_id, '-1' name
3449: FROM
3450: pji_project_classes PJM
3451: , (SELECT project_id

Line 3464: INSERT INTO pji_pmv_prj_dim_tmp (id, name)

3460: AND prj.project_id = pjm.project_id
3461: AND prj.carrying_out_organization_id = org.ID;
3462: ELSE
3463:
3464: INSERT INTO pji_pmv_prj_dim_tmp (id, name)
3465: SELECT DISTINCT prj.project_id, '-1' name
3466: FROM
3467: pji_project_classes PJM
3468: , pji_pmv_orgz_dim_tmp org

Line 3522: , PJI_PMV_PRJ_DIM_TMP PRJ

3518: DECODE(G_Report_Cost_Type, 'BC', fct.burdened_cost - fct.capitalizable_brdn_cost,
3519: 'RC', fct.raw_cost - fct.capitalizable_raw_cost, 0), 0) AS EXPENSE
3520: FROM PJI_PMV_TIME_DIM_TMP TIME
3521: , PJI_PMV_ORGZ_DIM_TMP HORG
3522: , PJI_PMV_PRJ_DIM_TMP PRJ
3523: , PJI_FP_PROJ_F FCT
3524: , PJI_PMV_ORG_DIM_TMP HOU
3525: WHERE 1=1
3526: AND bitand(fct.curr_record_type_id, l_curr_record_type_id) = l_curr_record_type_id

Line 3573: , PJI_PMV_PRJ_DIM_TMP PRJ

3569: , DECODE(NVL(TIME.amount_type,1),1,
3570: DECODE(G_Report_Cost_Type, 'BC', fct.burdened_cost - fct.capitalizable_brdn_cost,
3571: 'RC', fct.raw_cost - fct.capitalizable_raw_cost),0) AS EXPENSE
3572: FROM PJI_PMV_TIME_DIM_TMP TIME
3573: , PJI_PMV_PRJ_DIM_TMP PRJ
3574: , PJI_FP_PROJ_F FCT
3575: , PJI_PMV_ORG_DIM_TMP HOU
3576: WHERE 1=1
3577: AND bitand(fct.curr_record_type_id, l_curr_record_type_id) = l_curr_record_type_id

Line 3627: , PJI_PMV_PRJ_DIM_TMP PRJ

3623: , DECODE(NVL(TIME.amount_type,1),1,
3624: DECODE(G_Report_Cost_Type, 'BC', fct.burdened_cost - fct.capitalizable_brdn_cost,
3625: 'RC', fct.raw_cost - fct.capitalizable_raw_cost),0) AS EXPENSE
3626: FROM PJI_PMV_TIME_DIM_TMP TIME
3627: , PJI_PMV_PRJ_DIM_TMP PRJ
3628: , PJI_PMV_ET_RT_DIM_TMP ET
3629: , PJI_FP_PROJ_ET_F FCT
3630: , PJI_PMV_ORG_DIM_TMP HOU
3631: WHERE 1=1

Line 3684: , PJI_PMV_PRJ_DIM_TMP PRJ

3680: DECODE(G_Report_Cost_Type, 'BC', fct.burdened_cost - fct.capitalizable_brdn_cost,
3681: 'RC', fct.raw_cost - fct.capitalizable_raw_cost),0) AS EXPENSE
3682: FROM PJI_PMV_TIME_DIM_TMP TIME
3683: , PJI_PMV_WT_DIM_TMP WT
3684: , PJI_PMV_PRJ_DIM_TMP PRJ
3685: , PJI_FP_PROJ_ET_WT_F FCT
3686: , PJI_PMV_ORG_DIM_TMP HOU
3687: WHERE 1=1
3688: AND bitand(fct.curr_record_type_id, l_curr_record_type_id) = l_curr_record_type_id

Line 3739: , PJI_PMV_PRJ_DIM_TMP PRJ

3735: , DECODE(NVL(TIME.amount_type,1),1,
3736: DECODE(G_Report_Cost_Type, 'BC', fct.burdened_cost - fct.capitalizable_brdn_cost,
3737: 'RC', fct.raw_cost - fct.capitalizable_raw_cost),0) AS EXPENSE
3738: FROM PJI_PMV_TIME_DIM_TMP TIME
3739: , PJI_PMV_PRJ_DIM_TMP PRJ
3740: , PJI_PMV_ET_RT_DIM_TMP ET
3741: , PJI_FP_PROJ_ET_F FCT
3742: , PJI_PMV_ORG_DIM_TMP HOU
3743: WHERE 1=1

Line 3797: , PJI_PMV_PRJ_DIM_TMP PRJ

3793: 'RC', fct.raw_cost - fct.capitalizable_raw_cost),0) AS EXPENSE
3794: FROM PJI_PMV_TIME_DIM_TMP TIME
3795: , PJI_PMV_ET_RT_DIM_TMP ET
3796: , PJI_PMV_WT_DIM_TMP WT
3797: , PJI_PMV_PRJ_DIM_TMP PRJ
3798: , PJI_FP_PROJ_ET_WT_F FCT
3799: , PJI_PMV_ORG_DIM_TMP HOU
3800: WHERE 1=1
3801: AND bitand(fct.curr_record_type_id, l_curr_record_type_id) = l_curr_record_type_id

Line 3854: , PJI_PMV_PRJ_DIM_TMP PRJ

3850: , DECODE(NVL(TIME.amount_type,1),1,
3851: DECODE(G_Report_Cost_Type, 'BC', fct.burdened_cost - fct.capitalizable_brdn_cost,
3852: 'RC', fct.raw_cost - fct.capitalizable_raw_cost), 0) AS EXPENSE
3853: FROM PJI_PMV_TIME_DIM_TMP TIME
3854: , PJI_PMV_PRJ_DIM_TMP PRJ
3855: , PJI_PMV_WT_DIM_TMP WT
3856: , PJI_FP_PROJ_ET_WT_F FCT
3857: , PJI_PMV_ORG_DIM_TMP HOU
3858: WHERE 1=1

Line 3901: , PJI_PMV_PRJ_DIM_TMP PRJ

3897: , DECODE(NVL(TIME.amount_type,1),1,
3898: DECODE(G_Report_Cost_Type, 'BC', fct.burdened_cost - fct.capitalizable_brdn_cost,
3899: 'RC', fct.raw_cost - fct.capitalizable_raw_cost),0) AS EXPENSE
3900: FROM PJI_PMV_TIME_DIM_TMP TIME
3901: , PJI_PMV_PRJ_DIM_TMP PRJ
3902: , PJI_PMV_ET_RT_DIM_TMP ET
3903: , PJI_PMV_WT_DIM_TMP WT
3904: , PJI_FP_PROJ_ET_WT_F FCT
3905: , PJI_PMV_ORG_DIM_TMP HOU