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_ORG_DIM_TMP

Line 401: , PJI_PMV_ORG_DIM_TMP HOU

397: from
398: PJI_PMV_TIME_DIM_TMP TIME
399: , PJI_PMV_ORGZ_DIM_TMP HORG
400: , PJI_FP_ORGO_F_MV FCT
401: , PJI_PMV_ORG_DIM_TMP HOU
402: where
403: FCT.ORG_ID = HOU.ID
404: and FCT.ORGANIZATION_ID = HORG.ID
405: and FCT.TIME_ID = TIME.ID

Line 443: , PJI_PMV_ORG_DIM_TMP HOU

439: from
440: PJI_PMV_TCMP_DIM_TMP TIME
441: , PJI_PMV_ORGZ_DIM_TMP HORG
442: , PJI_FP_ORGO_F_MV FCT
443: , PJI_PMV_ORG_DIM_TMP HOU
444: where
445: FCT.ORG_ID = HOU.ID
446: and FCT.ORGANIZATION_ID = HORG.ID
447: and FCT.TIME_ID = TIME.ID

Line 472: PJI_PMV_ORG_DIM_TMP HOU

468: , 0 EXPENSE
469: , 0 CT_EXPENSE
470: , 0 EXPENSE_CHANGE_PRCNT
471: from
472: PJI_PMV_ORG_DIM_TMP HOU
473: where HOU.NAME <> '-1'
474: union all -- FORCE Creation of Organization Rows
475: select '-1' as ORG_ID
476: , HORG.NAME as ORGANIZATION_ID

Line 566: , PJI_PMV_ORG_DIM_TMP HOU

562: PJI_PMV_TIME_DIM_TMP TIME
563: , PJI_PMV_ORGZ_DIM_TMP HORG
564: , PJI_PMV_CLS_DIM_TMP CLS
565: , PJI_FP_CLSO_F_MV FCT
566: , PJI_PMV_ORG_DIM_TMP HOU
567: where
568: fct.PROJECT_ORG_ID = HOU.ID
569: and FCT.PROJECT_ORGANIZATION_ID = HORG.ID
570: and FCT.TIME_ID = TIME.ID

Line 610: , PJI_PMV_ORG_DIM_TMP HOU

606: PJI_PMV_TCMP_DIM_TMP TIME
607: , PJI_PMV_ORGZ_DIM_TMP HORG
608: , PJI_PMV_CLS_DIM_TMP CLS
609: , PJI_FP_CLSO_F_MV FCT
610: , PJI_PMV_ORG_DIM_TMP HOU
611: where
612: FCT.PROJECT_ORG_ID = HOU.ID
613: and FCT.PROJECT_ORGANIZATION_ID = HORG.ID
614: and FCT.TIME_ID = TIME.ID

Line 640: PJI_PMV_ORG_DIM_TMP HOU

636: , 0 EXPENSE
637: , 0 CT_EXPENSE
638: , 0 EXPENSE_CHANGE_PRCNT
639: from
640: PJI_PMV_ORG_DIM_TMP HOU
641: where HOU.NAME <> '-1'
642: union all -- FORCE Creation of Organization Rows
643: select '-1' AS ORG_ID
644: , NAME AS ORGANIZATION_ID

Line 755: , PJI_PMV_ORG_DIM_TMP HOU

751: PJI_PMV_TIME_DIM_TMP TIME
752: , PJI_PMV_ORGZ_DIM_TMP HORG
753: , PJI_PMV_ET_RT_DIM_TMP ET
754: , PJI_FP_ORGO_ET_F_MV FCT
755: , PJI_PMV_ORG_DIM_TMP HOU
756: where
757: FCT.ORG_ID = HOU.ID
758: and FCT.ORGANIZATION_ID = HORG.ID
759: and FCT.TIME_ID = TIME.ID

Line 800: , PJI_PMV_ORG_DIM_TMP HOU

796: PJI_PMV_TCMP_DIM_TMP TIME
797: , PJI_PMV_ORGZ_DIM_TMP HORG
798: , PJI_PMV_ET_RT_DIM_TMP ET
799: , PJI_FP_ORGO_ET_F_MV FCT
800: , PJI_PMV_ORG_DIM_TMP HOU
801: where
802: FCT.ORG_ID = HOU.ID
803: and FCT.ORGANIZATION_ID = HORG.ID
804: and FCT.TIME_ID = TIME.ID

Line 831: PJI_PMV_ORG_DIM_TMP HOU

827: , 0 EXPENSE
828: , 0 CT_EXPENSE
829: , 0 EXPENSE_CHANGE_PRCNT
830: from
831: PJI_PMV_ORG_DIM_TMP HOU
832: where HOU.NAME <> '-1'
833: union all -- FORCE Creation of Organization Rows
834: select '-1' AS ORG_ID
835: , HORG.NAME AS ORGANIZATION_ID

Line 946: , PJI_PMV_ORG_DIM_TMP HOU

942: PJI_PMV_TIME_DIM_TMP TIME
943: , PJI_PMV_ORGZ_DIM_TMP HORG
944: , PJI_PMV_WT_DIM_TMP WT
945: , PJI_FP_ORGO_ET_WT_F_MV FCT
946: , PJI_PMV_ORG_DIM_TMP HOU
947: where
948: FCT.ORG_ID = HOU.ID
949: and FCT.ORGANIZATION_ID = HORG.ID
950: and FCT.TIME_ID = TIME.ID

Line 990: , PJI_PMV_ORG_DIM_TMP HOU

986: PJI_PMV_TCMP_DIM_TMP TIME
987: , PJI_PMV_ORGZ_DIM_TMP HORG
988: , PJI_PMV_WT_DIM_TMP WT
989: , PJI_FP_ORGO_ET_WT_F_MV FCT
990: , PJI_PMV_ORG_DIM_TMP HOU
991: where
992: FCT.ORG_ID = HOU.ID
993: and FCT.ORGANIZATION_ID = HORG.ID
994: and FCT.TIME_ID = TIME.ID

Line 1020: PJI_PMV_ORG_DIM_TMP HOU

1016: , 0 EXPENSE
1017: , 0 CT_EXPENSE
1018: , 0 EXPENSE_CHANGE_PRCNT
1019: from
1020: PJI_PMV_ORG_DIM_TMP HOU
1021: where HOU.NAME <> '-1'
1022: union all -- FORCE Creation of Organization Rows
1023: select '-1' AS ORG_ID
1024: , HORG.NAME AS ORGANIZATION_ID

Line 1135: , PJI_PMV_ORG_DIM_TMP HOU

1131: , PJI_PMV_ORGZ_DIM_TMP HORG
1132: , PJI_PMV_ET_RT_DIM_TMP ET
1133: , PJI_FP_CLSO_ET_F_MV FCT
1134: , PJI_PMV_CLS_DIM_TMP CLS
1135: , PJI_PMV_ORG_DIM_TMP HOU
1136: where
1137: FCT.PROJECT_ORG_ID = HOU.ID
1138: and FCT.PROJECT_ORGANIZATION_ID = HORG.ID
1139: and FCT.TIME_ID = TIME.ID

Line 1181: , PJI_PMV_ORG_DIM_TMP HOU

1177: , PJI_PMV_ORGZ_DIM_TMP HORG
1178: , PJI_PMV_ET_RT_DIM_TMP ET
1179: , PJI_FP_CLSO_ET_F_MV FCT
1180: , PJI_PMV_CLS_DIM_TMP CLS
1181: , PJI_PMV_ORG_DIM_TMP HOU
1182: where
1183: FCT.PROJECT_ORG_ID = HOU.ID
1184: and FCT.PROJECT_ORGANIZATION_ID = HORG.ID
1185: and FCT.TIME_ID = TIME.ID

Line 1212: PJI_PMV_ORG_DIM_TMP HOU

1208: , 0 EXPENSE
1209: , 0 CT_EXPENSE
1210: , 0 EXPENSE_CHANGE_PRCNT
1211: from
1212: PJI_PMV_ORG_DIM_TMP HOU
1213: where HOU.NAME <> '-1'
1214: union all -- FORCE Creation of Organization Rows
1215: select '-1' as ORG_ID
1216: , HORG.NAME as ORGANIZATION_ID

Line 1349: , PJI_PMV_ORG_DIM_TMP HOU

1345: , PJI_PMV_ORGZ_DIM_TMP HORG
1346: , PJI_PMV_ET_RT_DIM_TMP ET
1347: , PJI_FP_ORGO_ET_WT_F_MV FCT
1348: , PJI_PMV_WT_DIM_TMP WT
1349: , PJI_PMV_ORG_DIM_TMP HOU
1350: where
1351: FCT.ORG_ID = HOU.ID
1352: and FCT.ORGANIZATION_ID = HORG.ID
1353: and FCT.TIME_ID = TIME.ID

Line 1395: , PJI_PMV_ORG_DIM_TMP HOU

1391: , PJI_PMV_ORGZ_DIM_TMP HORG
1392: , PJI_PMV_ET_RT_DIM_TMP ET
1393: , PJI_FP_ORGO_ET_WT_F_MV FCT
1394: , PJI_PMV_WT_DIM_TMP WT
1395: , PJI_PMV_ORG_DIM_TMP HOU
1396: where
1397: FCT.ORG_ID = HOU.ID
1398: and FCT.ORGANIZATION_ID = HORG.ID
1399: and FCT.TIME_ID = TIME.ID

Line 1426: PJI_PMV_ORG_DIM_TMP HOU

1422: , 0 EXPENSE
1423: , 0 CT_EXPENSE
1424: , 0 EXPENSE_CHANGE_PRCNT
1425: from
1426: PJI_PMV_ORG_DIM_TMP HOU
1427: where HOU.NAME <> '-1'
1428: union all -- FORCE Creation of Organization Rows
1429: select '-1' AS ORG_ID
1430: , HORG.NAME AS ORGANIZATION_ID

Line 1564: , PJI_PMV_ORG_DIM_TMP HOU

1560: , PJI_PMV_ORGZ_DIM_TMP HORG
1561: , PJI_PMV_CLS_DIM_TMP CLS
1562: , PJI_FP_CLSO_ET_WT_F_MV FCT
1563: , PJI_PMV_WT_DIM_TMP WT
1564: , PJI_PMV_ORG_DIM_TMP HOU
1565: where
1566: FCT.PROJECT_ORG_ID = HOU.ID
1567: and FCT.PROJECT_ORGANIZATION_ID = HORG.ID
1568: and FCT.TIME_ID = TIME.ID

Line 1610: , PJI_PMV_ORG_DIM_TMP HOU

1606: , PJI_PMV_ORGZ_DIM_TMP HORG
1607: , PJI_PMV_CLS_DIM_TMP CLS
1608: , PJI_FP_CLSO_ET_WT_F_MV FCT
1609: , PJI_PMV_WT_DIM_TMP WT
1610: , PJI_PMV_ORG_DIM_TMP HOU
1611: where
1612: FCT.PROJECT_ORG_ID = HOU.ID
1613: and FCT.PROJECT_ORGANIZATION_ID = HORG.ID
1614: and FCT.TIME_ID = TIME.ID

Line 1641: PJI_PMV_ORG_DIM_TMP HOU

1637: , 0 EXPENSE
1638: , 0 CT_EXPENSE
1639: , 0 EXPENSE_CHANGE_PRCNT
1640: from
1641: PJI_PMV_ORG_DIM_TMP HOU
1642: where HOU.NAME <> '-1'
1643: union all -- FORCE Creation of Organization Rows
1644: select '-1' as ORG_ID
1645: , HORG.NAME as ORGANIZATION_ID

Line 1776: , PJI_PMV_ORG_DIM_TMP HOU

1772: , PJI_PMV_ET_RT_DIM_TMP ET
1773: , PJI_FP_CLSO_ET_WT_F_MV FCT
1774: , PJI_PMV_CLS_DIM_TMP CLS
1775: , PJI_PMV_WT_DIM_TMP WT
1776: , PJI_PMV_ORG_DIM_TMP HOU
1777: where
1778: FCT.PROJECT_ORG_ID = HOU.ID
1779: and FCT.PROJECT_ORGANIZATION_ID = HORG.ID
1780: and FCT.TIME_ID = TIME.ID

Line 1825: , PJI_PMV_ORG_DIM_TMP HOU

1821: , PJI_PMV_ET_RT_DIM_TMP ET
1822: , PJI_FP_CLSO_ET_WT_F_MV FCT
1823: , PJI_PMV_CLS_DIM_TMP CLS
1824: , PJI_PMV_WT_DIM_TMP WT
1825: , PJI_PMV_ORG_DIM_TMP HOU
1826: where
1827: FCT.PROJECT_ORG_ID = HOU.ID
1828: and FCT.PROJECT_ORGANIZATION_ID = HORG.ID
1829: and FCT.TIME_ID = TIME.ID

Line 1858: PJI_PMV_ORG_DIM_TMP HOU

1854: , 0 EXPENSE
1855: , 0 CT_EXPENSE
1856: , 0 EXPENSE_CHANGE_PRCNT
1857: from
1858: PJI_PMV_ORG_DIM_TMP HOU
1859: where HOU.NAME <> '-1'
1860: union all -- FORCE Creation of Organization Rows
1861: select '-1' as ORG_ID
1862: , HORG.NAME AS ORGANIZATION_ID

Line 2307: , PJI_PMV_ORG_DIM_TMP HOU

2303: from
2304: PJI_PMV_TIME_DIM_TMP TIME
2305: , PJI_PMV_ORGZ_DIM_TMP HORG
2306: , PJI_FP_ORGO_F_MV FCT
2307: , PJI_PMV_ORG_DIM_TMP HOU
2308: where
2309: FCT.ORG_ID = HOU.ID
2310: AND FCT.ORGANIZATION_ID = HORG.ID
2311: AND FCT.TIME_ID = TIME.ID

Line 2344: , PJI_PMV_ORG_DIM_TMP HOU

2340: from
2341: PJI_PMV_TIME_DIM_TMP TIME
2342: , PJI_PMV_ORGZ_DIM_TMP HORG
2343: , PJI_FP_ORGO_F_MV FCT
2344: , PJI_PMV_ORG_DIM_TMP HOU
2345: where
2346: FCT.org_id = HOU.id
2347: and FCT.organization_id = HORG.id
2348: and FCT.time_id = TIME.prior_id

Line 2429: , PJI_PMV_ORG_DIM_TMP HOU

2425: PJI_PMV_TIME_DIM_TMP TIME
2426: , PJI_PMV_ORGZ_DIM_TMP HORG
2427: , PJI_PMV_CLS_DIM_TMP CLS
2428: , PJI_FP_CLSO_F_MV FCT
2429: , PJI_PMV_ORG_DIM_TMP HOU
2430: where
2431: FCT.PROJECT_ORG_ID = HOU.ID
2432: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID
2433: AND FCT.TIME_ID = TIME.ID

Line 2468: , PJI_PMV_ORG_DIM_TMP HOU

2464: PJI_PMV_TIME_DIM_TMP TIME
2465: , PJI_PMV_ORGZ_DIM_TMP HORG
2466: , PJI_PMV_CLS_DIM_TMP CLS
2467: , PJI_FP_CLSO_F_MV FCT
2468: , PJI_PMV_ORG_DIM_TMP HOU
2469: where
2470: FCT.PROJECT_org_id = HOU.id
2471: and FCT.PROJECT_organization_id = HORG.id
2472: and FCT.time_id = TIME.prior_id

Line 2553: , PJI_PMV_ORG_DIM_TMP HOU

2549: PJI_PMV_TIME_DIM_TMP TIME
2550: , PJI_PMV_ORGZ_DIM_TMP HORG
2551: , PJI_PMV_ET_RT_DIM_TMP ET
2552: , PJI_FP_ORGO_ET_F_MV FCT
2553: , PJI_PMV_ORG_DIM_TMP HOU
2554: where
2555: FCT.ORG_ID = HOU.ID
2556: AND FCT.ORGANIZATION_ID = HORG.ID
2557: AND FCT.TIME_ID = TIME.ID

Line 2593: , PJI_PMV_ORG_DIM_TMP HOU

2589: PJI_PMV_TIME_DIM_TMP TIME
2590: , PJI_PMV_ORGZ_DIM_TMP HORG
2591: , PJI_PMV_ET_RT_DIM_TMP ET
2592: , PJI_FP_ORGO_ET_F_MV FCT
2593: , PJI_PMV_ORG_DIM_TMP HOU
2594: where
2595: FCT.org_id = HOU.id
2596: and FCT.organization_id = HORG.id
2597: and FCT.time_id = TIME.prior_id

Line 2680: , PJI_PMV_ORG_DIM_TMP HOU

2676: PJI_PMV_TIME_DIM_TMP TIME
2677: , PJI_PMV_ORGZ_DIM_TMP HORG
2678: , PJI_PMV_WT_DIM_TMP WT
2679: , PJI_FP_ORGO_ET_WT_F_MV FCT
2680: , PJI_PMV_ORG_DIM_TMP HOU
2681: where
2682: FCT.ORG_ID = HOU.ID
2683: AND FCT.ORGANIZATION_ID = HORG.ID
2684: AND FCT.TIME_ID = TIME.ID

Line 2719: , PJI_PMV_ORG_DIM_TMP HOU

2715: PJI_PMV_TIME_DIM_TMP TIME
2716: , PJI_PMV_ORGZ_DIM_TMP HORG
2717: , PJI_PMV_WT_DIM_TMP WT
2718: , PJI_FP_ORGO_ET_WT_F_MV FCT
2719: , PJI_PMV_ORG_DIM_TMP HOU
2720: where
2721: FCT.org_id = HOU.id
2722: and FCT.organization_id = HORG.id
2723: and FCT.time_id = TIME.prior_id

Line 2805: , PJI_PMV_ORG_DIM_TMP HOU

2801: , PJI_PMV_ORGZ_DIM_TMP HORG
2802: , PJI_PMV_CLS_DIM_TMP CLS
2803: , PJI_PMV_ET_RT_DIM_TMP ET
2804: , PJI_FP_CLSO_ET_F_MV FCT
2805: , PJI_PMV_ORG_DIM_TMP HOU
2806: where
2807: FCT.PROJECT_ORG_ID = HOU.ID
2808: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID
2809: AND FCT.TIME_ID = TIME.ID

Line 2847: , PJI_PMV_ORG_DIM_TMP HOU

2843: , PJI_PMV_ORGZ_DIM_TMP HORG
2844: , PJI_PMV_CLS_DIM_TMP CLS
2845: , PJI_PMV_ET_RT_DIM_TMP ET
2846: , PJI_FP_CLSO_ET_F_MV FCT
2847: , PJI_PMV_ORG_DIM_TMP HOU
2848: where
2849: FCT.PROJECT_org_id = HOU.id
2850: and FCT.PROJECT_organization_id = HORG.id
2851: and FCT.time_id = TIME.prior_id

Line 2936: , PJI_PMV_ORG_DIM_TMP HOU

2932: , PJI_PMV_ORGZ_DIM_TMP HORG
2933: , PJI_PMV_ET_RT_DIM_TMP ET
2934: , PJI_FP_ORGO_ET_WT_F_MV FCT
2935: , PJI_PMV_WT_DIM_TMP WT
2936: , PJI_PMV_ORG_DIM_TMP HOU
2937: where
2938: FCT.ORG_ID = HOU.ID
2939: AND FCT.ORGANIZATION_ID = HORG.ID
2940: AND FCT.TIME_ID = TIME.ID

Line 2978: , PJI_PMV_ORG_DIM_TMP HOU

2974: , PJI_PMV_ORGZ_DIM_TMP HORG
2975: , PJI_PMV_ET_RT_DIM_TMP ET
2976: , PJI_FP_ORGO_ET_WT_F_MV FCT
2977: , PJI_PMV_WT_DIM_TMP WT
2978: , PJI_PMV_ORG_DIM_TMP HOU
2979: where
2980: FCT.org_id = HOU.id
2981: and FCT.organization_id = HORG.id
2982: and FCT.time_id = TIME.prior_id

Line 3066: , PJI_PMV_ORG_DIM_TMP HOU

3062: , PJI_PMV_ORGZ_DIM_TMP HORG
3063: , PJI_PMV_CLS_DIM_TMP CLS
3064: , PJI_FP_CLSO_ET_WT_F_MV FCT
3065: , PJI_PMV_WT_DIM_TMP WT
3066: , PJI_PMV_ORG_DIM_TMP HOU
3067: where
3068: FCT.PROJECT_ORG_ID = HOU.ID
3069: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID
3070: AND FCT.TIME_ID = TIME.ID

Line 3107: , PJI_PMV_ORG_DIM_TMP HOU

3103: , PJI_PMV_ORGZ_DIM_TMP HORG
3104: , PJI_PMV_CLS_DIM_TMP CLS
3105: , PJI_FP_CLSO_ET_WT_F_MV FCT
3106: , PJI_PMV_WT_DIM_TMP WT
3107: , PJI_PMV_ORG_DIM_TMP HOU
3108: where
3109: FCT.PROJECT_org_id = HOU.id
3110: and FCT.PROJECT_organization_id = HORG.id
3111: and FCT.time_id = TIME.prior_id

Line 3192: , PJI_PMV_ORG_DIM_TMP HOU

3188: , PJI_PMV_ET_RT_DIM_TMP ET
3189: , PJI_FP_CLSO_ET_WT_F_MV FCT
3190: , PJI_PMV_CLS_DIM_TMP CLS
3191: , PJI_PMV_WT_DIM_TMP WT
3192: , PJI_PMV_ORG_DIM_TMP HOU
3193: where
3194: FCT.PROJECT_ORG_ID = HOU.ID
3195: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID
3196: AND FCT.TIME_ID = TIME.ID

Line 3236: , PJI_PMV_ORG_DIM_TMP HOU

3232: , PJI_PMV_ET_RT_DIM_TMP ET
3233: , PJI_FP_CLSO_ET_WT_F_MV FCT
3234: , PJI_PMV_CLS_DIM_TMP CLS
3235: , PJI_PMV_WT_DIM_TMP WT
3236: , PJI_PMV_ORG_DIM_TMP HOU
3237: where
3238: FCT.PROJECT_org_id = HOU.id
3239: and FCT.PROJECT_organization_id = HORG.id
3240: and FCT.time_id = TIME.prior_id

Line 3524: , PJI_PMV_ORG_DIM_TMP HOU

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
3527: AND FCT.PROJECT_ID = PRJ.ID
3528: AND FCT.PROJECT_ORG_ID = HOU.ID

Line 3575: , PJI_PMV_ORG_DIM_TMP HOU

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
3578: AND FCT.PROJECT_ID = PRJ.ID
3579: AND FCT.PROJECT_ORG_ID = HOU.ID

Line 3630: , PJI_PMV_ORG_DIM_TMP HOU

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
3632: AND bitand(fct.curr_record_type_id, l_curr_record_type_id) = l_curr_record_type_id
3633: AND FCT.PROJECT_ID = PRJ.ID
3634: AND FCT.EXP_EVT_TYPE_ID = ET.ID

Line 3686: , PJI_PMV_ORG_DIM_TMP HOU

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
3689: AND FCT.PROJECT_ID = PRJ.ID
3690: AND FCT.WORK_TYPE_ID = WT.ID

Line 3742: , PJI_PMV_ORG_DIM_TMP HOU

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
3744: AND bitand(fct.curr_record_type_id, l_curr_record_type_id) = l_curr_record_type_id
3745: AND FCT.PROJECT_ID = PRJ.ID
3746: AND FCT.EXP_EVT_TYPE_ID = ET.ID

Line 3799: , PJI_PMV_ORG_DIM_TMP HOU

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
3802: AND FCT.PROJECT_ID = PRJ.ID
3803: AND FCT.EXP_EVT_TYPE_ID = ET.ID

Line 3857: , PJI_PMV_ORG_DIM_TMP HOU

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
3859: AND bitand(fct.curr_record_type_id, l_curr_record_type_id) = l_curr_record_type_id
3860: AND FCT.PROJECT_ID = PRJ.ID
3861: AND FCT.WORK_TYPE_ID = WT.ID

Line 3905: , PJI_PMV_ORG_DIM_TMP HOU

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
3906: WHERE 1=1
3907: AND bitand(fct.curr_record_type_id, l_curr_record_type_id) = l_curr_record_type_id
3908: AND FCT.PROJECT_ID = PRJ.ID
3909: AND FCT.EXP_EVT_TYPE_ID = ET.ID