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.MTH_UTIL_PKG dependencies on MTH_EQUIPMENT_SHIFTS_D

Line 2257: * mth_equipment_shifts_d table *

2253: * reading_time + p_range_in_hours / 24. *
2254: * p_pre_tag_data: Previous tag reading for the same tag code *
2255: * p_pre_reading_time: reading time for the previous tag reading *
2256: * p_pre_eqp_availability: The availability_flag in the
2257: * mth_equipment_shifts_d table *
2258: * Y - available *
2259: * N - not available *
2260: * NULL - no schedule available *
2261: * Modification log : *

Line 2322: FROM MTH_EQUIPMENT_SHIFTS_D s

2318: ORDER BY reading_time desc;
2319:
2320: cursor c_avail (p_equipment_fk_key IN NUMBER, p_reading_time IN DATE ) IS
2321: SELECT s.availability_flag
2322: FROM MTH_EQUIPMENT_SHIFTS_D s
2323: WHERE s.equipment_fk_key = p_equipment_fk_key AND
2324: p_reading_time BETWEEN s.from_date AND s.To_Date;
2325:
2326:

Line 2678: FOR j IN (SELECT equipment_fk_key,shift_workday_fk_key,from_date,To_Date FROM mth_equipment_shifts_d WHERE equipment_fk_key = i.equipment_fk_key

2674: v_end_time := i.To_Date;
2675:
2676: --Dbms_Output.PUT_LINE('v_start_time AND v_end_time are'||'-----'||To_Char(v_start_time,'dd-Mon-yyyy hh24:mi:ss')||'------'||To_Char(v_end_time,'dd-Mon-yyyy hh24:mi:ss'));
2677:
2678: FOR j IN (SELECT equipment_fk_key,shift_workday_fk_key,from_date,To_Date FROM mth_equipment_shifts_d WHERE equipment_fk_key = i.equipment_fk_key
2679: AND shift_workday_fk_key = i.shift_workday_fk_key AND Upper(availability_flag)= 'N')
2680: LOOP
2681:
2682: --Dbms_Output.PUT_LINE('Equip_shift'||'------'||To_Char(j.from_date,'dd-Mon-yyyy hh24:mi:ss')||'------'||To_Char(j.to_date,'dd-Mon-yyyy hh24:mi:ss'));

Line 3048: DELETE FROM mth_equipment_shifts_d WHERE availability_date>=l_start_date AND availability_date<=l_end_date

3044: THEN
3045: --DELETE FROM mth_workday_shifts_D WHERE plant_fk_key = l_plant_fk_key and shift_date>=l_start_date ;
3046: DELETE FROM mth_workday_shifts_D WHERE plant_fk_key = l_plant_fk_key and Trunc(from_date)>=l_start_date AND Trunc(from_date)<=l_end_date;
3047: DELETE FROM mth_workday_shifts_D WHERE plant_fk_key = l_plant_fk_key and shift_date>=l_start_date AND shift_date<=l_end_date;
3048: DELETE FROM mth_equipment_shifts_d WHERE availability_date>=l_start_date AND availability_date<=l_end_date
3049: AND equipment_fk_key IN (SELECT DISTINCT(Nvl(a.equipment_fk_key,0))
3050: FROM mth_equipment_shifts_d a,mth_equipments_d b WHERE b.equipment_pk_key=a.equipment_fk_key AND b.plant_fk_key =l_plant_fk_key
3051: UNION ALL
3052: SELECT distinct(Nvl(a.equipment_fk_key,0) )

Line 3050: FROM mth_equipment_shifts_d a,mth_equipments_d b WHERE b.equipment_pk_key=a.equipment_fk_key AND b.plant_fk_key =l_plant_fk_key

3046: DELETE FROM mth_workday_shifts_D WHERE plant_fk_key = l_plant_fk_key and Trunc(from_date)>=l_start_date AND Trunc(from_date)<=l_end_date;
3047: DELETE FROM mth_workday_shifts_D WHERE plant_fk_key = l_plant_fk_key and shift_date>=l_start_date AND shift_date<=l_end_date;
3048: DELETE FROM mth_equipment_shifts_d WHERE availability_date>=l_start_date AND availability_date<=l_end_date
3049: AND equipment_fk_key IN (SELECT DISTINCT(Nvl(a.equipment_fk_key,0))
3050: FROM mth_equipment_shifts_d a,mth_equipments_d b WHERE b.equipment_pk_key=a.equipment_fk_key AND b.plant_fk_key =l_plant_fk_key
3051: UNION ALL
3052: SELECT distinct(Nvl(a.equipment_fk_key,0) )
3053: FROM mth_equipment_shifts_d a,mth_resources_d b WHERE b.resource_pk_key=a.equipment_fk_key AND b.plant_fk_key =l_plant_fk_key
3054:

Line 3053: FROM mth_equipment_shifts_d a,mth_resources_d b WHERE b.resource_pk_key=a.equipment_fk_key AND b.plant_fk_key =l_plant_fk_key

3049: AND equipment_fk_key IN (SELECT DISTINCT(Nvl(a.equipment_fk_key,0))
3050: FROM mth_equipment_shifts_d a,mth_equipments_d b WHERE b.equipment_pk_key=a.equipment_fk_key AND b.plant_fk_key =l_plant_fk_key
3051: UNION ALL
3052: SELECT distinct(Nvl(a.equipment_fk_key,0) )
3053: FROM mth_equipment_shifts_d a,mth_resources_d b WHERE b.resource_pk_key=a.equipment_fk_key AND b.plant_fk_key =l_plant_fk_key
3054:
3055: UNION ALL
3056: SELECT distinct(Nvl(a.equipment_fk_key,0) )
3057: FROM mth_equipment_shifts_d a,mth_plants_d b WHERE b.plant_pk_key=a.equipment_fk_key AND b.plant_pk_key =l_plant_fk_key

Line 3057: FROM mth_equipment_shifts_d a,mth_plants_d b WHERE b.plant_pk_key=a.equipment_fk_key AND b.plant_pk_key =l_plant_fk_key

3053: FROM mth_equipment_shifts_d a,mth_resources_d b WHERE b.resource_pk_key=a.equipment_fk_key AND b.plant_fk_key =l_plant_fk_key
3054:
3055: UNION ALL
3056: SELECT distinct(Nvl(a.equipment_fk_key,0) )
3057: FROM mth_equipment_shifts_d a,mth_plants_d b WHERE b.plant_pk_key=a.equipment_fk_key AND b.plant_pk_key =l_plant_fk_key
3058:
3059: UNION ALL
3060: SELECT distinct(Nvl(a.equipment_fk_key,0) )
3061: FROM mth_equipment_shifts_d a,mth_equip_entities_mst b WHERE b.entity_pk_key=a.equipment_fk_key AND b.plant_fk_key =l_plant_fk_key

Line 3061: FROM mth_equipment_shifts_d a,mth_equip_entities_mst b WHERE b.entity_pk_key=a.equipment_fk_key AND b.plant_fk_key =l_plant_fk_key

3057: FROM mth_equipment_shifts_d a,mth_plants_d b WHERE b.plant_pk_key=a.equipment_fk_key AND b.plant_pk_key =l_plant_fk_key
3058:
3059: UNION ALL
3060: SELECT distinct(Nvl(a.equipment_fk_key,0) )
3061: FROM mth_equipment_shifts_d a,mth_equip_entities_mst b WHERE b.entity_pk_key=a.equipment_fk_key AND b.plant_fk_key =l_plant_fk_key
3062: );
3063:
3064: FOR l_shift_def IN c_shift_def
3065: LOOP

Line 3144: INSERT INTO mth_equipment_shifts_d(equipment_fk_key,availability_date,shift_workday_fk_key,from_date,To_Date,line_num,availability_flag,entity_type,creation_date,last_update_date,creation_system_id,

3140: END IF;
3141:
3142:
3143: IF UPPER(l_shift_type)='BOTH' THEN
3144: INSERT INTO mth_equipment_shifts_d(equipment_fk_key,availability_date,shift_workday_fk_key,from_date,To_Date,line_num,availability_flag,entity_type,creation_date,last_update_date,creation_system_id,
3145: last_update_system_id) (
3146:
3147: SELECT b.entity_pk_key entity_pk_key,a.shift_date shift_date,a.shift_workday_pk_key shift_workday_fk_key,a.from_date from_date,a.to_date To_Date,1 line_num,'Y',
3148: b.entity_type entity_type,SYSDATE,SYSDATE,-1,-99999

Line 3179: INSERT INTO mth_equipment_shifts_d(equipment_fk_key,availability_date,shift_workday_fk_key,from_date,To_Date,line_num,availability_flag,entity_type,creation_date,last_update_date,creation_system_id,

3175: AND l_shift_def.end_time=To_Char(To_Date,'HH24:MI:SS'));
3176:
3177: END IF;
3178: IF UPPER(l_shift_type)='PROD-SHIFT' THEN
3179: INSERT INTO mth_equipment_shifts_d(equipment_fk_key,availability_date,shift_workday_fk_key,from_date,To_Date,line_num,availability_flag,entity_type,creation_date,last_update_date,creation_system_id,
3180: last_update_system_id) (
3181:
3182: SELECT b.entity_pk_key entity_pk_key,a.shift_date shift_date,a.shift_workday_pk_key shift_workday_fk_key,a.from_date from_date,a.to_date To_Date,1 line_num,'Y',
3183: b.entity_type entity_type,SYSDATE,SYSDATE,-1,-99999

Line 3215: INSERT INTO mth_equipment_shifts_d(equipment_fk_key,availability_date,shift_workday_fk_key,from_date,To_Date,line_num,availability_flag,entity_type,creation_date,last_update_date,creation_system_id,

3211: AND l_shift_def.end_time=To_Char(To_Date,'HH24:MI:SS'));
3212:
3213: END IF;
3214: IF UPPER(l_shift_type)='NON-PROD-SHIFT' THEN
3215: INSERT INTO mth_equipment_shifts_d(equipment_fk_key,availability_date,shift_workday_fk_key,from_date,To_Date,line_num,availability_flag,entity_type,creation_date,last_update_date,creation_system_id,
3216: last_update_system_id) (
3217:
3218: SELECT b.entity_pk_key entity_pk_key,a.shift_date shift_date,a.shift_workday_pk_key shift_workday_fk_key,a.from_date from_date,a.to_date To_Date,1 line_num,'Y',
3219: b.entity_type entity_type,SYSDATE,SYSDATE,-1,-99999

Line 3289: INSERT INTO mth_equipment_shifts_d(equipment_fk_key,availability_date,shift_workday_fk_key,from_date,To_Date,line_num,availability_flag,entity_type,creation_date,last_update_date,creation_system_id,

3285: ELSE
3286: l_start_date := p_start_date;
3287: END IF;
3288:
3289: INSERT INTO mth_equipment_shifts_d(equipment_fk_key,availability_date,shift_workday_fk_key,from_date,To_Date,line_num,availability_flag,entity_type,creation_date,last_update_date,creation_system_id,
3290: last_update_system_id) (
3291:
3292: SELECT b.entity_pk_key entity_pk_key,a.shift_date shift_date,a.shift_workday_pk_key shift_workday_fk_key,null,null,1 line_num,'Y',
3293: b.entity_type entity_type,SYSDATE,SYSDATE,-1,-99999

Line 4015: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIPMENT_SHIFTS_D',v_unassigned_val,'INCR',NULL,0,v_log_to_date);

4011: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
4012:
4013:
4014: -- Call mth_run_log_pre_load
4015: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIPMENT_SHIFTS_D',v_unassigned_val,'INCR',NULL,0,v_log_to_date);
4016:
4017: -- Call GET_RUN_LOG_DATES
4018: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIPMENT_SHIFTS_D',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
4019:

Line 4018: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIPMENT_SHIFTS_D',NULL,NULL,NULL,v_log_from_date,v_log_to_date);

4014: -- Call mth_run_log_pre_load
4015: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIPMENT_SHIFTS_D',v_unassigned_val,'INCR',NULL,0,v_log_to_date);
4016:
4017: -- Call GET_RUN_LOG_DATES
4018: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIPMENT_SHIFTS_D',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
4019:
4020: DELETE
4021: FROM MTH_EQUIPMENT_SHIFTS_D ESD
4022: WHERE EXISTS (SELECT 1

Line 4021: FROM MTH_EQUIPMENT_SHIFTS_D ESD

4017: -- Call GET_RUN_LOG_DATES
4018: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIPMENT_SHIFTS_D',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
4019:
4020: DELETE
4021: FROM MTH_EQUIPMENT_SHIFTS_D ESD
4022: WHERE EXISTS (SELECT 1
4023: FROM MTH_WORKDAY_SHIFTS_D WSD,MTH_ALL_ENTITIES_V MAV
4024: WHERE WSD.LAST_UPDATE_DATE > v_log_from_date
4025: AND (MAV.PRODUCTION_ENTITY ='Y'or MAV.PRODUCTION_ENTITY ='N')

Line 4030: mth_util_pkg.log_msg('Number of rows deleted from MTH_EQUIPMENT_SHIFTS_D - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

4026: AND WSD.PLANT_FK_KEY = MAV.SITE_ID
4027: AND
4028: ESD.EQUIPMENT_FK_KEY = MAV.ENTITY_PK_KEY AND
4029: ESD.SHIFT_WORKDAY_FK_KEY = WSD.SHIFT_WORKDAY_PK_KEY ) ;
4030: mth_util_pkg.log_msg('Number of rows deleted from MTH_EQUIPMENT_SHIFTS_D - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4031:
4032: INSERT INTO MTH_EQUIPMENT_SHIFTS_D (EQUIPMENT_FK_KEY,
4033: AVAILABILITY_DATE,
4034: SHIFT_WORKDAY_FK_KEY,

Line 4032: INSERT INTO MTH_EQUIPMENT_SHIFTS_D (EQUIPMENT_FK_KEY,

4028: ESD.EQUIPMENT_FK_KEY = MAV.ENTITY_PK_KEY AND
4029: ESD.SHIFT_WORKDAY_FK_KEY = WSD.SHIFT_WORKDAY_PK_KEY ) ;
4030: mth_util_pkg.log_msg('Number of rows deleted from MTH_EQUIPMENT_SHIFTS_D - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4031:
4032: INSERT INTO MTH_EQUIPMENT_SHIFTS_D (EQUIPMENT_FK_KEY,
4033: AVAILABILITY_DATE,
4034: SHIFT_WORKDAY_FK_KEY,
4035: FROM_DATE,
4036: TO_DATE,

Line 4094: mth_util_pkg.log_msg('Number of rows inserted in MTH_EQUIPMENT_SHIFTS_D - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

4090: ( RES.FROM_DATE >= COST.EQUIPMENT_EFFECTIVE_DATE (+) AND
4091: RES.FROM_DATE <= NVL ( COST.EQUIPMENT_EXPIRATION_DATE (+) ,TO_DATE('4000-01-01', 'YYYY-MM-DD') )
4092: ) )
4093: ;
4094: mth_util_pkg.log_msg('Number of rows inserted in MTH_EQUIPMENT_SHIFTS_D - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4095:
4096: ----Call mth_run_log_post_load
4097: mth_util_pkg.mth_run_log_post_load('MTH_EQUIPMENT_SHIFTS_D',v_unassigned_val);
4098:

Line 4097: mth_util_pkg.mth_run_log_post_load('MTH_EQUIPMENT_SHIFTS_D',v_unassigned_val);

4093: ;
4094: mth_util_pkg.log_msg('Number of rows inserted in MTH_EQUIPMENT_SHIFTS_D - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4095:
4096: ----Call mth_run_log_post_load
4097: mth_util_pkg.mth_run_log_post_load('MTH_EQUIPMENT_SHIFTS_D',v_unassigned_val);
4098:
4099:
4100: mth_util_pkg.log_msg('INCR_EQUIPMENT_SHIFTS end', mth_util_pkg.G_DBG_PROC_FUN_END);
4101: COMMIT;

Line 4404: DELETE FROM mth_equipment_shifts_D

4400: mth_util_pkg.log_msg('Number of rows inserted in MTH_WORKDAY_SHIFTS_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4401:
4402:
4403:
4404: DELETE FROM mth_equipment_shifts_D
4405: WHERE shift_workday_fk_key IN (SELECT shift_workday_pk_key FROM
4406: mth_workday_shifts_D wsd,
4407: mth_shift_reference_MV mv,
4408: mth_workday_shifts_stg stg,

Line 4425: mth_util_pkg.log_msg('Number of rows deleted from mth_equipment_shifts_D - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

4421: AND NVL(STG.SYSTEM_FK, MTH_UTIL_PKG.MTH_UA_GET_VAL() ) = MS.SYSTEM_PK
4422: AND stg.err_code IS NULL
4423: And stg.SOURCE_ORG_CODE = nvl ( wsd.SOURCE_ORG_CODE , stg.SOURCE_ORG_CODE ));
4424:
4425: mth_util_pkg.log_msg('Number of rows deleted from mth_equipment_shifts_D - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4426:
4427: DELETE FROM mth_workday_shifts_D
4428: WHERE shift_workday_pk_key IN (SELECT shift_workday_pk_key FROM
4429: mth_workday_shifts_D wsd,