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_ORG_DIM_TMP

Line 433: , PJI_PMV_ORG_DIM_TMP HOU

429: FROM
430: PJI_PMV_TIME_DIM_TMP TIME
431: , PJI_PMV_ORGZ_DIM_TMP HORG
432: , PJI_FP_ORGO_F_MV FCT
433: , PJI_PMV_ORG_DIM_TMP HOU
434: WHERE
435: fct.org_id = hou.id
436: AND FCT.ORGANIZATION_ID = HORG.ID
437: AND FCT.TIME_ID = TIME.ID

Line 470: , PJI_PMV_ORG_DIM_TMP HOU

466: FROM
467: PJI_PMV_TCMP_DIM_TMP TIME
468: , PJI_PMV_ORGZ_DIM_TMP HORG
469: , PJI_FP_ORGO_F_MV fct
470: , PJI_PMV_ORG_DIM_TMP HOU
471: WHERE
472: fct.org_id = hou.id
473: AND FCT.ORGANIZATION_ID = HORG.ID
474: AND FCT.TIME_ID = TIME.ID

Line 494: FROM PJI_PMV_ORG_DIM_TMP HOU

490: , 0 AS BUDGET
491: , 0 AS CT_BUDGET
492: , 0 AS NON_BILL_COST
493: , 0 AS CT_NON_BILL_COST
494: FROM PJI_PMV_ORG_DIM_TMP HOU
495: WHERE HOU.NAME <> '-1'
496: UNION ALL -- FORCE Creation of Organization Rows
497: SELECT '-1' AS ORG_ID
498: , HORG.NAME AS ORGANIZATION_ID

Line 579: , PJI_PMV_ORG_DIM_TMP HOU

575: PJI_PMV_TIME_DIM_TMP TIME
576: , PJI_PMV_ORGZ_DIM_TMP HORG
577: , PJI_PMV_CLS_DIM_TMP CLS
578: , PJI_FP_CLSO_F_MV FCT
579: , PJI_PMV_ORG_DIM_TMP HOU
580: WHERE
581: FCT.PROJECT_ORG_ID = HOU.ID
582: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID
583: AND FCT.TIME_ID = TIME.ID

Line 618: , PJI_PMV_ORG_DIM_TMP HOU

614: PJI_PMV_TCMP_DIM_TMP TIME
615: , PJI_PMV_ORGZ_DIM_TMP HORG
616: , PJI_PMV_CLS_DIM_TMP CLS
617: , PJI_FP_CLSO_F_MV FCT
618: , PJI_PMV_ORG_DIM_TMP HOU
619: WHERE
620: FCT.PROJECT_ORG_ID = HOU.ID
621: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID
622: AND FCT.TIME_ID = TIME.ID

Line 643: FROM PJI_PMV_ORG_DIM_TMP HOU

639: , 0 AS BUDGET
640: , 0 AS CT_BUDGET
641: , 0 AS NON_BILL_COST
642: , 0 AS CT_NON_BILL_COST
643: FROM PJI_PMV_ORG_DIM_TMP HOU
644: WHERE HOU.NAME <> '-1'
645: UNION ALL -- FORCE Creation of Organization Rows
646: SELECT '-1' AS ORG_ID
647: , HORG.NAME AS ORGANIZATION_ID

Line 748: , PJI_PMV_ORG_DIM_TMP HOU

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
751: AND FCT.ORGANIZATION_ID = HORG.ID
752: AND FCT.TIME_ID = TIME.ID

Line 786: , PJI_PMV_ORG_DIM_TMP HOU

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
789: AND FCT.ORGANIZATION_ID = HORG.ID
790: AND FCT.TIME_ID = TIME.ID

Line 812: FROM PJI_PMV_ORG_DIM_TMP HOU

808: , 0 AS BUDGET
809: , 0 AS CT_BUDGET
810: , 0 AS NON_BILL_COST
811: , 0 AS CT_NON_BILL_COST
812: FROM PJI_PMV_ORG_DIM_TMP HOU
813: WHERE HOU.NAME <> '-1'
814: UNION ALL -- FORCE Creation of Organization Rows
815: SELECT '-1' AS ORG_ID
816: , HORG.NAME AS ORGANIZATION_ID

Line 917: , PJI_PMV_ORG_DIM_TMP HOU

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
920: AND FCT.ORGANIZATION_ID = HORG.ID
921: AND FCT.TIME_ID = TIME.ID

Line 954: , PJI_PMV_ORG_DIM_TMP HOU

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
957: AND FCT.ORGANIZATION_ID = HORG.ID
958: AND FCT.TIME_ID = TIME.ID

Line 979: FROM PJI_PMV_ORG_DIM_TMP HOU

975: , 0 AS BUDGET
976: , 0 AS CT_BUDGET
977: , 0 AS NON_BILL_COST
978: , 0 AS CT_NON_BILL_COST
979: FROM PJI_PMV_ORG_DIM_TMP HOU
980: WHERE HOU.NAME <> '-1'
981: UNION ALL -- FORCE Creation of Organization Rows
982: SELECT '-1' AS ORG_ID
983: , HORG.NAME AS ORGANIZATION_ID

Line 1086: , PJI_PMV_ORG_DIM_TMP HOU

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
1088: FCT.PROJECT_ORG_ID = HOU.ID
1089: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID
1090: AND FCT.TIME_ID = TIME.ID

Line 1126: , PJI_PMV_ORG_DIM_TMP HOU

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
1128: FCT.PROJECT_ORG_ID = HOU.ID
1129: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID
1130: AND FCT.TIME_ID = TIME.ID

Line 1153: FROM PJI_PMV_ORG_DIM_TMP HOU

1149: , 0 AS BUDGET
1150: , 0 AS CT_BUDGET
1151: , 0 AS NON_BILL_COST
1152: , 0 AS CT_NON_BILL_COST
1153: FROM PJI_PMV_ORG_DIM_TMP HOU
1154: WHERE HOU.NAME <> '-1'
1155: UNION ALL -- FORCE Creation of Organization Rows
1156: SELECT '-1' AS ORG_ID
1157: , HORG.NAME AS ORGANIZATION_ID

Line 1273: , PJI_PMV_ORG_DIM_TMP HOU

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
1277: AND FCT.TIME_ID = TIME.ID

Line 1313: , PJI_PMV_ORG_DIM_TMP HOU

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
1317: AND FCT.TIME_ID = TIME.ID

Line 1340: FROM PJI_PMV_ORG_DIM_TMP HOU

1336: , 0 AS BUDGET
1337: , 0 AS CT_BUDGET
1338: , 0 AS NON_BILL_COST
1339: , 0 AS CT_NON_BILL_COST
1340: FROM PJI_PMV_ORG_DIM_TMP HOU
1341: WHERE HOU.NAME <> '-1'
1342: UNION ALL -- FORCE Creation of Organization Rows
1343: SELECT '-1' AS ORG_ID
1344: , HORG.NAME AS ORGANIZATION_ID

Line 1458: , PJI_PMV_ORG_DIM_TMP HOU

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
1462: AND FCT.TIME_ID = TIME.ID

Line 1497: , PJI_PMV_ORG_DIM_TMP HOU

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
1501: AND FCT.TIME_ID = TIME.ID

Line 1523: FROM PJI_PMV_ORG_DIM_TMP HOU

1519: , 0 AS BUDGET
1520: , 0 AS CT_BUDGET
1521: , 0 AS NON_BILL_COST
1522: , 0 AS CT_NON_BILL_COST
1523: FROM PJI_PMV_ORG_DIM_TMP HOU
1524: WHERE HOU.NAME <> '-1'
1525: UNION ALL -- FORCE Creation of Organization Rows
1526: SELECT '-1' AS ORG_ID
1527: , HORG.NAME AS ORGANIZATION_ID

Line 1639: , PJI_PMV_ORG_DIM_TMP HOU

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
1643: AND FCT.TIME_ID = TIME.ID

Line 1681: , PJI_PMV_ORG_DIM_TMP HOU

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
1685: AND FCT.TIME_ID = TIME.ID

Line 1709: FROM PJI_PMV_ORG_DIM_TMP HOU

1705: , 0 AS BUDGET
1706: , 0 AS CT_BUDGET
1707: , 0 AS NON_BILL_COST
1708: , 0 AS CT_NON_BILL_COST
1709: FROM PJI_PMV_ORG_DIM_TMP HOU
1710: WHERE HOU.NAME <> '-1'
1711: UNION ALL -- FORCE Creation of Organization Rows
1712: SELECT '-1' AS ORG_ID
1713: , HORG.NAME AS ORGANIZATION_ID

Line 2250: , PJI_PMV_ORG_DIM_TMP HOU

2246: FROM
2247: PJI_PMV_TIME_DIM_TMP TIME
2248: , PJI_PMV_ORGZ_DIM_TMP HORG
2249: , PJI_FP_ORGO_F_MV FCT
2250: , PJI_PMV_ORG_DIM_TMP HOU
2251: WHERE
2252: FCT.org_id = HOU.id
2253: AND FCT.organization_id = HORG.id
2254: AND FCT.time_id = TIME.id

Line 2282: , PJI_PMV_ORG_DIM_TMP HOU

2278: FROM
2279: PJI_PMV_TIME_DIM_TMP TIME
2280: , PJI_PMV_ORGZ_DIM_TMP HORG
2281: , PJI_FP_ORGO_F_MV FCT
2282: , PJI_PMV_ORG_DIM_TMP HOU
2283: WHERE
2284: FCT.org_id = HOU.id
2285: AND FCT.organization_id = HORG.id
2286: AND FCT.time_id = TIME.prior_id

Line 2364: , PJI_PMV_ORG_DIM_TMP HOU

2360: PJI_PMV_TIME_DIM_TMP TIME
2361: , PJI_PMV_ORGZ_DIM_TMP HORG
2362: , PJI_PMV_CLS_DIM_TMP CLS
2363: , PJI_FP_CLSO_F_MV FCT
2364: , PJI_PMV_ORG_DIM_TMP HOU
2365: WHERE
2366: FCT.PROJECT_ORG_ID = HOU.id
2367: AND FCT.PROJECT_organization_id = HORG.id
2368: AND FCT.time_id = TIME.id

Line 2398: , PJI_PMV_ORG_DIM_TMP HOU

2394: PJI_PMV_TIME_DIM_TMP TIME
2395: , PJI_PMV_ORGZ_DIM_TMP HORG
2396: , PJI_PMV_CLS_DIM_TMP CLS
2397: , PJI_FP_CLSO_F_MV FCT
2398: , PJI_PMV_ORG_DIM_TMP HOU
2399: WHERE
2400: FCT.PROJECT_org_id = HOU.id
2401: AND FCT.PROJECT_organization_id = HORG.id
2402: AND FCT.time_id = TIME.prior_id

Line 2480: , PJI_PMV_ORG_DIM_TMP HOU

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
2483: AND FCT.organization_id = HORG.id
2484: AND FCT.time_id = TIME.id

Line 2513: , PJI_PMV_ORG_DIM_TMP HOU

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
2516: AND FCT.organization_id = HORG.id
2517: AND FCT.time_id = TIME.prior_id

Line 2596: , PJI_PMV_ORG_DIM_TMP HOU

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
2599: AND FCT.organization_id = HORG.id
2600: AND FCT.time_id = TIME.id

Line 2629: , PJI_PMV_ORG_DIM_TMP HOU

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
2632: AND FCT.organization_id = HORG.id
2633: AND FCT.time_id = TIME.prior_id

Line 2712: , PJI_PMV_ORG_DIM_TMP HOU

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
2714: FCT.PROJECT_org_id = HOU.id
2715: AND FCT.PROJECT_organization_id = HORG.id
2716: AND FCT.time_id = TIME.id

Line 2748: , PJI_PMV_ORG_DIM_TMP HOU

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
2750: FCT.PROJECT_org_id = HOU.id
2751: AND FCT.PROJECT_organization_id = HORG.id
2752: AND FCT.time_id = TIME.prior_id

Line 2833: , PJI_PMV_ORG_DIM_TMP HOU

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
2837: AND FCT.time_id = TIME.id

Line 2868: , PJI_PMV_ORG_DIM_TMP HOU

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
2872: AND FCT.time_id = TIME.prior_id

Line 2952: , PJI_PMV_ORG_DIM_TMP HOU

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
2956: AND FCT.time_id = TIME.id

Line 2986: , PJI_PMV_ORG_DIM_TMP HOU

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
2990: AND FCT.time_id = TIME.prior_id

Line 3068: , PJI_PMV_ORG_DIM_TMP HOU

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
3072: AND FCT.time_id = TIME.id

Line 3105: , PJI_PMV_ORG_DIM_TMP HOU

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
3109: AND FCT.time_id = TIME.prior_id

Line 3446: , PJI_PMV_ORG_DIM_TMP HOU

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
3448: AND bitand(fct.curr_record_type_id, l_curr_record_type_id) = l_curr_record_type_id
3449: AND FCT.PROJECT_ID = PRJ.ID
3450: AND FCT.PROJECT_ORG_ID = HOU.ID

Line 3502: , PJI_PMV_ORG_DIM_TMP HOU

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

Line 3561: , PJI_PMV_ORG_DIM_TMP HOU

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

Line 3620: , PJI_PMV_ORG_DIM_TMP HOU

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

Line 3679: , PJI_PMV_ORG_DIM_TMP HOU

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

Line 3739: , PJI_PMV_ORG_DIM_TMP HOU

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

Line 3797: , PJI_PMV_ORG_DIM_TMP HOU

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

Line 3848: , PJI_PMV_ORG_DIM_TMP HOU

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