[Home] [Help]
468: -- JOB_ID Util --> Non-Util: make sure source reversals are not summarized
469:
470: select count(*)
471: into l_row_count
472: from PJI_RES_DELTA
473: where CHANGE_TYPE = 'N';
474:
475: if (l_row_count > 0) then
476:
492: where fid.PJI_SUMMARIZED_FLAG = 'N' and
493: fid.FORECAST_ITEM_ID in
494: (select /*+ cardinality(delta, 1) */
495: fi.FORECAST_ITEM_ID
496: from PJI_RES_DELTA delta,
497: PA_FORECAST_ITEMS fi
498: where delta.CHANGE_TYPE = 'N' and
499: delta.RESOURCE_ID = fi.RESOURCE_ID and
500: fi.FORECAST_ITEM_TYPE in ('U', 'A') and
1191: -rmr.UNASSIGNED_HRS_S UNASSIGNED_HRS_S,
1192: -rmr.CONF_OVERCOM_HRS_S CONF_OVERCOM_HRS_S,
1193: -rmr.PROV_OVERCOM_HRS_S PROV_OVERCOM_HRS_S
1194: from
1195: PJI_RES_DELTA delta,
1196: PJI_RM_RES_WT_F rmr,
1197: PJI_RM_ORG_BATCH_MAP map,
1198: PJI_PJI_PROJ_BATCH_MAP fm_map,
1199: PJI_ORG_EXTR_INFO info
1240: -rmr.UNASSIGNED_HRS_S,
1241: -rmr.CONF_OVERCOM_HRS_S,
1242: -rmr.PROV_OVERCOM_HRS_S
1243: from
1244: PJI_RES_DELTA delta,
1245: PJI_RM_RES_WT_F rmr,
1246: PJI_ORG_EXTR_INFO info
1247: where
1248: l_extraction_type = 'INCREMENTAL' and
1314: end PROV_OVERCOM_HRS_S
1315: from
1316: PJI_RM_AGGR_RES3 tmp3,
1317: PJI_RM_RES_WT_F rmr,
1318: PJI_RES_DELTA delta,
1319: (
1320: select 'TMP3' INVERT_ID from dual union all
1321: select 'RMR' INVERT_ID from dual
1322: ) invert
1425: from PA_PROJECTS_ALL pa
1426: where pa.PROJECT_ID = pji.PROJECT_ID)
1427: ) prj,
1428: PJI_RM_RES_WT_F rmr,
1429: PJI_RES_DELTA delta,
1430: PJI_ORG_EXTR_INFO info
1431: where
1432: l_extraction_type = 'INCREMENTAL' and
1433: rmr.PROJECT_ID = prj.PROJECT_ID and
1701: 'NORMAL',
1702: null);
1703:
1704: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
1705: 'PJI_RES_DELTA',
1706: 'NORMAL',
1707: null);
1708:
1709: delete