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_ET_RT_DIM_TMP

Line 746: , PJI_PMV_ET_RT_DIM_TMP ET

742: , 0 CT_NON_BILL_COST
743: FROM
744: PJI_PMV_TIME_DIM_TMP TIME
745: , PJI_PMV_ORGZ_DIM_TMP HORG
746: , PJI_PMV_ET_RT_DIM_TMP ET
747: , PJI_FP_ORGO_ET_F_MV FCT
748: , PJI_PMV_ORG_DIM_TMP HOU
749: WHERE
750: FCT.ORG_ID = HOU.ID

Line 784: , PJI_PMV_ET_RT_DIM_TMP ET

780: 'RC', FCT.CONTRACT_RAW_COST - FCT.BILL_RAW_COST,0), 0) AS CT_NON_BILL_COST
781: FROM
782: PJI_PMV_TCMP_DIM_TMP TIME
783: , PJI_PMV_ORGZ_DIM_TMP HORG
784: , PJI_PMV_ET_RT_DIM_TMP ET
785: , PJI_FP_ORGO_ET_F_MV FCT
786: , PJI_PMV_ORG_DIM_TMP HOU
787: WHERE
788: FCT.ORG_ID = HOU.ID

Line 846: FROM PJI_PMV_ET_RT_DIM_TMP ET

842: , 0 AS BUDGET
843: , 0 AS CT_BUDGET
844: , 0 AS NON_BILL_COST
845: , 0 AS CT_NON_BILL_COST
846: FROM PJI_PMV_ET_RT_DIM_TMP ET
847: WHERE ET.NAME <> '-1'
848: ) WHERE 1=1
849: GROUP BY ORG_ID, ORGANIZATION_ID, PROJECT_CLASS_ID, EXPENDITURE_CATEGORY,
850: EXPENDITURE_TYPE_ID,WORK_TYPE_ID;

Line 1083: , PJI_PMV_ET_RT_DIM_TMP ET

1079: , 0 CT_NON_BILL_COST
1080: FROM
1081: PJI_PMV_TIME_DIM_TMP TIME
1082: , PJI_PMV_ORGZ_DIM_TMP HORG
1083: , PJI_PMV_ET_RT_DIM_TMP ET
1084: , PJI_FP_CLSO_ET_F_MV FCT
1085: , PJI_PMV_CLS_DIM_TMP CLS
1086: , PJI_PMV_ORG_DIM_TMP HOU
1087: WHERE

Line 1123: , PJI_PMV_ET_RT_DIM_TMP ET

1119: 'RC', FCT.CONTRACT_RAW_COST - FCT.BILL_RAW_COST,0), 0) AS CT_NON_BILL_COST
1120: FROM
1121: PJI_PMV_TCMP_DIM_TMP TIME
1122: , PJI_PMV_ORGZ_DIM_TMP HORG
1123: , PJI_PMV_ET_RT_DIM_TMP ET
1124: , PJI_FP_CLSO_ET_F_MV FCT
1125: , PJI_PMV_CLS_DIM_TMP CLS
1126: , PJI_PMV_ORG_DIM_TMP HOU
1127: WHERE

Line 1204: FROM PJI_PMV_ET_RT_DIM_TMP ET

1200: , 0 AS BUDGET
1201: , 0 AS CT_BUDGET
1202: , 0 AS NON_BILL_COST
1203: , 0 AS CT_NON_BILL_COST
1204: FROM PJI_PMV_ET_RT_DIM_TMP ET
1205: WHERE ET.NAME <> '-1'
1206: ) WHERE 1=1
1207: GROUP BY ORG_ID, ORGANIZATION_ID, PROJECT_CLASS_ID, EXPENDITURE_CATEGORY,
1208: EXPENDITURE_TYPE_ID,WORK_TYPE_ID;

Line 1270: , PJI_PMV_ET_RT_DIM_TMP ET

1266: , 0 CT_NON_BILL_COST
1267: FROM
1268: PJI_PMV_TIME_DIM_TMP TIME
1269: , PJI_PMV_ORGZ_DIM_TMP HORG
1270: , PJI_PMV_ET_RT_DIM_TMP ET
1271: , PJI_FP_ORGO_ET_WT_F_MV FCT
1272: , PJI_PMV_WT_DIM_TMP WT
1273: , PJI_PMV_ORG_DIM_TMP HOU
1274: WHERE

Line 1310: , PJI_PMV_ET_RT_DIM_TMP ET

1306: 'RC', FCT.CONTRACT_RAW_COST - FCT.BILL_RAW_COST,0), 0) AS CT_NON_BILL_COST
1307: FROM
1308: PJI_PMV_TCMP_DIM_TMP TIME
1309: , PJI_PMV_ORGZ_DIM_TMP HORG
1310: , PJI_PMV_ET_RT_DIM_TMP ET
1311: , PJI_FP_ORGO_ET_WT_F_MV FCT
1312: , PJI_PMV_WT_DIM_TMP WT
1313: , PJI_PMV_ORG_DIM_TMP HOU
1314: WHERE

Line 1391: FROM PJI_PMV_ET_RT_DIM_TMP ET

1387: , 0 AS BUDGET
1388: , 0 AS CT_BUDGET
1389: , 0 AS NON_BILL_COST
1390: , 0 AS CT_NON_BILL_COST
1391: FROM PJI_PMV_ET_RT_DIM_TMP ET
1392: WHERE ET.NAME <> '-1'
1393: ) WHERE 1=1
1394: GROUP BY ORG_ID, ORGANIZATION_ID, PROJECT_CLASS_ID, EXPENDITURE_CATEGORY,
1395: EXPENDITURE_TYPE_ID,WORK_TYPE_ID;

Line 1635: , PJI_PMV_ET_RT_DIM_TMP ET

1631: , 0 CT_NON_BILL_COST
1632: FROM
1633: PJI_PMV_TIME_DIM_TMP TIME
1634: , PJI_PMV_ORGZ_DIM_TMP HORG
1635: , PJI_PMV_ET_RT_DIM_TMP ET
1636: , PJI_FP_CLSO_ET_WT_F_MV FCT
1637: , PJI_PMV_CLS_DIM_TMP CLS
1638: , PJI_PMV_WT_DIM_TMP WT
1639: , PJI_PMV_ORG_DIM_TMP HOU

Line 1677: , PJI_PMV_ET_RT_DIM_TMP ET

1673: 'RC', FCT.CONTRACT_RAW_COST - FCT.BILL_RAW_COST,0), 0) AS CT_NON_BILL_COST
1674: FROM
1675: PJI_PMV_TCMP_DIM_TMP TIME
1676: , PJI_PMV_ORGZ_DIM_TMP HORG
1677: , PJI_PMV_ET_RT_DIM_TMP ET
1678: , PJI_FP_CLSO_ET_WT_F_MV FCT
1679: , PJI_PMV_CLS_DIM_TMP CLS
1680: , PJI_PMV_WT_DIM_TMP WT
1681: , PJI_PMV_ORG_DIM_TMP HOU

Line 1743: FROM PJI_PMV_ET_RT_DIM_TMP ET

1739: , 0 AS BUDGET
1740: , 0 AS CT_BUDGET
1741: , 0 AS NON_BILL_COST
1742: , 0 AS CT_NON_BILL_COST
1743: FROM PJI_PMV_ET_RT_DIM_TMP ET
1744: WHERE ET.NAME <> '-1'
1745: UNION ALL
1746: SELECT '-1' AS ORG_ID
1747: , '-1' AS ORGANIZATION_ID

Line 2478: , PJI_PMV_ET_RT_DIM_TMP ET

2474: , 0 CT_Non_Bill_Cost
2475: FROM
2476: PJI_PMV_TIME_DIM_TMP TIME
2477: , PJI_PMV_ORGZ_DIM_TMP HORG
2478: , PJI_PMV_ET_RT_DIM_TMP ET
2479: , PJI_FP_ORGO_ET_F_MV FCT
2480: , PJI_PMV_ORG_DIM_TMP HOU
2481: WHERE
2482: FCT.org_id = HOU.id

Line 2511: , PJI_PMV_ET_RT_DIM_TMP ET

2507: 'BC', contract_brdn_cost - bill_burdened_cost),0) CT_Non_Bill_Cost
2508: FROM
2509: PJI_PMV_TIME_DIM_TMP TIME
2510: , PJI_PMV_ORGZ_DIM_TMP HORG
2511: , PJI_PMV_ET_RT_DIM_TMP ET
2512: , PJI_FP_ORGO_ET_F_MV FCT
2513: , PJI_PMV_ORG_DIM_TMP HOU
2514: WHERE
2515: FCT.org_id = HOU.id

Line 2709: , PJI_PMV_ET_RT_DIM_TMP ET

2705: , 0 CT_Non_Bill_Cost
2706: FROM
2707: PJI_PMV_TIME_DIM_TMP TIME
2708: , PJI_PMV_ORGZ_DIM_TMP HORG
2709: , PJI_PMV_ET_RT_DIM_TMP ET
2710: , PJI_FP_CLSO_ET_F_MV FCT
2711: , PJI_PMV_CLS_DIM_TMP CLS
2712: , PJI_PMV_ORG_DIM_TMP HOU
2713: WHERE

Line 2745: , PJI_PMV_ET_RT_DIM_TMP ET

2741: 'BC', contract_brdn_cost - bill_burdened_cost),0) CT_Non_Bill_Cost
2742: FROM
2743: PJI_PMV_TIME_DIM_TMP TIME
2744: , PJI_PMV_ORGZ_DIM_TMP HORG
2745: , PJI_PMV_ET_RT_DIM_TMP ET
2746: , PJI_FP_CLSO_ET_F_MV FCT
2747: , PJI_PMV_CLS_DIM_TMP CLS
2748: , PJI_PMV_ORG_DIM_TMP HOU
2749: WHERE

Line 2830: , PJI_PMV_ET_RT_DIM_TMP ET

2826: , 0 CT_Non_Bill_Cost
2827: FROM
2828: PJI_PMV_TIME_DIM_TMP TIME
2829: , PJI_PMV_ORGZ_DIM_TMP HORG
2830: , PJI_PMV_ET_RT_DIM_TMP ET
2831: , PJI_FP_ORGO_ET_WT_F_MV FCT
2832: , PJI_PMV_WT_DIM_TMP WT
2833: , PJI_PMV_ORG_DIM_TMP HOU
2834: WHERE

Line 2865: , PJI_PMV_ET_RT_DIM_TMP ET

2861: 'BC', contract_brdn_cost - bill_burdened_cost),0) CT_Non_Bill_Cost
2862: FROM
2863: PJI_PMV_TIME_DIM_TMP TIME
2864: , PJI_PMV_ORGZ_DIM_TMP HORG
2865: , PJI_PMV_ET_RT_DIM_TMP ET
2866: , PJI_FP_ORGO_ET_WT_F_MV FCT
2867: , PJI_PMV_WT_DIM_TMP WT
2868: , PJI_PMV_ORG_DIM_TMP HOU
2869: WHERE

Line 3064: , PJI_PMV_ET_RT_DIM_TMP ET

3060: , 0 CT_Non_Bill_Cost
3061: FROM
3062: PJI_PMV_TIME_DIM_TMP TIME
3063: , PJI_PMV_ORGZ_DIM_TMP HORG
3064: , PJI_PMV_ET_RT_DIM_TMP ET
3065: , PJI_FP_CLSO_ET_WT_F_MV FCT
3066: , PJI_PMV_CLS_DIM_TMP CLS
3067: , PJI_PMV_WT_DIM_TMP WT
3068: , PJI_PMV_ORG_DIM_TMP HOU

Line 3101: , PJI_PMV_ET_RT_DIM_TMP ET

3097: 'BC', contract_brdn_cost - bill_burdened_cost),0) CT_Non_Bill_Cost
3098: FROM
3099: PJI_PMV_TIME_DIM_TMP TIME
3100: , PJI_PMV_ORGZ_DIM_TMP HORG
3101: , PJI_PMV_ET_RT_DIM_TMP ET
3102: , PJI_FP_CLSO_ET_WT_F_MV FCT
3103: , PJI_PMV_CLS_DIM_TMP CLS
3104: , PJI_PMV_WT_DIM_TMP WT
3105: , PJI_PMV_ORG_DIM_TMP HOU

Line 3559: , PJI_PMV_ET_RT_DIM_TMP ET

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
3563: AND bitand(fct.curr_record_type_id, l_curr_record_type_id) = l_curr_record_type_id

Line 3677: , PJI_PMV_ET_RT_DIM_TMP ET

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
3681: AND bitand(fct.curr_record_type_id, l_curr_record_type_id) = l_curr_record_type_id

Line 3736: , PJI_PMV_ET_RT_DIM_TMP ET

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
3740: WHERE 1=1

Line 3845: , PJI_PMV_ET_RT_DIM_TMP ET

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
3849: WHERE 1=1