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_WT_DIM_TMP

Line 915: , PJI_PMV_WT_DIM_TMP WT

911: , 0 CT_NON_BILL_COST
912: FROM
913: PJI_PMV_TIME_DIM_TMP TIME
914: , PJI_PMV_ORGZ_DIM_TMP HORG
915: , PJI_PMV_WT_DIM_TMP WT
916: , PJI_FP_ORGO_ET_WT_F_MV FCT
917: , PJI_PMV_ORG_DIM_TMP HOU
918: WHERE
919: FCT.ORG_ID = HOU.ID

Line 952: , PJI_PMV_WT_DIM_TMP WT

948: 'RC', FCT.CONTRACT_RAW_COST - FCT.BILL_RAW_COST,0), 0) AS CT_NON_BILL_COST
949: FROM
950: PJI_PMV_TCMP_DIM_TMP TIME
951: , PJI_PMV_ORGZ_DIM_TMP HORG
952: , PJI_PMV_WT_DIM_TMP WT
953: , PJI_FP_ORGO_ET_WT_F_MV FCT
954: , PJI_PMV_ORG_DIM_TMP HOU
955: WHERE
956: FCT.ORG_ID = HOU.ID

Line 1013: FROM PJI_PMV_WT_DIM_TMP WT

1009: , 0 AS BUDGET
1010: , 0 AS CT_BUDGET
1011: , 0 AS NON_BILL_COST
1012: , 0 AS CT_NON_BILL_COST
1013: FROM PJI_PMV_WT_DIM_TMP WT
1014: WHERE WT.NAME <> '-1'
1015: ) WHERE 1=1
1016: GROUP BY ORG_ID, ORGANIZATION_ID, PROJECT_CLASS_ID, EXPENDITURE_CATEGORY,
1017: EXPENDITURE_TYPE_ID,WORK_TYPE_ID;

Line 1272: , PJI_PMV_WT_DIM_TMP WT

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
1275: FCT.ORG_ID = HOU.ID
1276: AND FCT.ORGANIZATION_ID = HORG.ID

Line 1312: , PJI_PMV_WT_DIM_TMP WT

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
1315: FCT.ORG_ID = HOU.ID
1316: AND FCT.ORGANIZATION_ID = HORG.ID

Line 1374: FROM PJI_PMV_WT_DIM_TMP WT

1370: , 0 AS BUDGET
1371: , 0 AS CT_BUDGET
1372: , 0 AS NON_BILL_COST
1373: , 0 AS CT_NON_BILL_COST
1374: FROM PJI_PMV_WT_DIM_TMP WT
1375: WHERE WT.NAME <> '-1'
1376: UNION ALL
1377: SELECT '-1' AS ORG_ID
1378: , '-1' AS ORGANIZATION_ID

Line 1457: , PJI_PMV_WT_DIM_TMP WT

1453: PJI_PMV_TIME_DIM_TMP TIME
1454: , PJI_PMV_ORGZ_DIM_TMP HORG
1455: , PJI_PMV_CLS_DIM_TMP CLS
1456: , PJI_FP_CLSO_ET_WT_F_MV FCT
1457: , PJI_PMV_WT_DIM_TMP WT
1458: , PJI_PMV_ORG_DIM_TMP HOU
1459: WHERE
1460: FCT.PROJECT_ORG_ID = HOU.ID
1461: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID

Line 1496: , PJI_PMV_WT_DIM_TMP WT

1492: PJI_PMV_TCMP_DIM_TMP TIME
1493: , PJI_PMV_ORGZ_DIM_TMP HORG
1494: , PJI_PMV_CLS_DIM_TMP CLS
1495: , PJI_FP_CLSO_ET_WT_F_MV FCT
1496: , PJI_PMV_WT_DIM_TMP WT
1497: , PJI_PMV_ORG_DIM_TMP HOU
1498: WHERE
1499: FCT.PROJECT_ORG_ID = HOU.ID
1500: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID

Line 1557: FROM PJI_PMV_WT_DIM_TMP WT

1553: , 0 AS BUDGET
1554: , 0 AS CT_BUDGET
1555: , 0 AS NON_BILL_COST
1556: , 0 AS CT_NON_BILL_COST
1557: FROM PJI_PMV_WT_DIM_TMP WT
1558: WHERE WT.NAME <> '-1'
1559: UNION ALL
1560: SELECT '-1' AS ORG_ID
1561: , '-1' AS ORGANIZATION_ID

Line 1638: , PJI_PMV_WT_DIM_TMP WT

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
1640: WHERE
1641: FCT.PROJECT_ORG_ID = HOU.ID
1642: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID

Line 1680: , PJI_PMV_WT_DIM_TMP WT

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
1682: WHERE
1683: FCT.PROJECT_ORG_ID = HOU.ID
1684: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID

Line 1760: FROM PJI_PMV_WT_DIM_TMP WT

1756: , 0 AS BUDGET
1757: , 0 AS CT_BUDGET
1758: , 0 AS NON_BILL_COST
1759: , 0 AS CT_NON_BILL_COST
1760: FROM PJI_PMV_WT_DIM_TMP WT
1761: WHERE WT.NAME <> '-1'
1762:
1763: UNION ALL
1764: SELECT '-1' AS ORG_ID

Line 2594: , PJI_PMV_WT_DIM_TMP WT

2590: , 0 CT_Non_Bill_Cost
2591: FROM
2592: PJI_PMV_TIME_DIM_TMP TIME
2593: , PJI_PMV_ORGZ_DIM_TMP HORG
2594: , PJI_PMV_WT_DIM_TMP WT
2595: , PJI_FP_ORGO_ET_WT_F_MV FCT
2596: , PJI_PMV_ORG_DIM_TMP HOU
2597: WHERE
2598: FCT.org_id = HOU.id

Line 2627: , PJI_PMV_WT_DIM_TMP WT

2623: 'BC', contract_brdn_cost - bill_burdened_cost),0) CT_Non_Bill_Cost
2624: FROM
2625: PJI_PMV_TIME_DIM_TMP TIME
2626: , PJI_PMV_ORGZ_DIM_TMP HORG
2627: , PJI_PMV_WT_DIM_TMP WT
2628: , PJI_FP_ORGO_ET_WT_F_MV FCT
2629: , PJI_PMV_ORG_DIM_TMP HOU
2630: WHERE
2631: FCT.org_id = HOU.id

Line 2832: , PJI_PMV_WT_DIM_TMP WT

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
2835: FCT.org_id = HOU.id
2836: AND FCT.organization_id = HORG.id

Line 2867: , PJI_PMV_WT_DIM_TMP WT

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
2870: FCT.org_id = HOU.id
2871: AND FCT.organization_id = HORG.id

Line 2951: , PJI_PMV_WT_DIM_TMP WT

2947: PJI_PMV_TIME_DIM_TMP TIME
2948: , PJI_PMV_ORGZ_DIM_TMP HORG
2949: , PJI_PMV_CLS_DIM_TMP CLS
2950: , PJI_FP_CLSO_ET_WT_F_MV FCT
2951: , PJI_PMV_WT_DIM_TMP WT
2952: , PJI_PMV_ORG_DIM_TMP HOU
2953: WHERE
2954: FCT.PROJECT_org_id = HOU.id
2955: AND FCT.PROJECT_organization_id = HORG.id

Line 2985: , PJI_PMV_WT_DIM_TMP WT

2981: PJI_PMV_TIME_DIM_TMP TIME
2982: , PJI_PMV_ORGZ_DIM_TMP HORG
2983: , PJI_PMV_CLS_DIM_TMP CLS
2984: , PJI_FP_CLSO_ET_WT_F_MV FCT
2985: , PJI_PMV_WT_DIM_TMP WT
2986: , PJI_PMV_ORG_DIM_TMP HOU
2987: WHERE
2988: FCT.PROJECT_org_id = HOU.id
2989: AND FCT.PROJECT_organization_id = HORG.id

Line 3067: , PJI_PMV_WT_DIM_TMP WT

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
3069: WHERE
3070: FCT.PROJECT_org_id = HOU.id
3071: AND FCT.PROJECT_organization_id = HORG.id

Line 3104: , PJI_PMV_WT_DIM_TMP WT

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
3106: WHERE
3107: FCT.PROJECT_org_id = HOU.id
3108: AND FCT.PROJECT_organization_id = HORG.id

Line 3618: , PJI_PMV_WT_DIM_TMP WT

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

Line 3737: , PJI_PMV_WT_DIM_TMP WT

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

Line 3795: , PJI_PMV_WT_DIM_TMP WT

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

Line 3846: , PJI_PMV_WT_DIM_TMP WT

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