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.

[Home] [Help]

APPS.MTH_UTIL_PKG dependencies on MTH_WORKDAY_SHIFTS_D

Line 127: IF p_fact_table = 'MTH_WORKDAY_SHIFTS_D'

123:
124: ELSE
125: /* update all non_ebs organizations from same system and plant with to_date as the passed date */
126: --Custom Logic for the time dimension
127: IF p_fact_table = 'MTH_WORKDAY_SHIFTS_D'
128: THEN
129: UPDATE mth_run_log
130: SET from_date = p_run_start_date
131: WHERE

Line 187: IF p_fact_table = 'MTH_WORKDAY_SHIFTS_D'

183: --if the above condition fails then update the row
184: ELSE--incremental load
185:
186: --Custom Logic for the time dimension
187: IF p_fact_table = 'MTH_WORKDAY_SHIFTS_D'
188: THEN
189: UPDATE mth_run_log
190: SET from_date = p_run_start_date
191: WHERE

Line 1858: IF p_fact_table = 'MTH_WORKDAY_SHIFTS_D'

1854:
1855: ELSE
1856: /* update all non_ebs organizations from same system and plant with to_date as the passed date */
1857: --Custom Logic for the time dimension
1858: IF p_fact_table = 'MTH_WORKDAY_SHIFTS_D'
1859: THEN
1860: UPDATE mth_run_log
1861: SET from_date = p_run_start_date
1862: WHERE

Line 1919: IF p_fact_table = 'MTH_WORKDAY_SHIFTS_D'

1915: --if the above condition fails then update the row
1916: ELSE--incremental load
1917:
1918: --Custom Logic for the time dimension
1919: IF p_fact_table = 'MTH_WORKDAY_SHIFTS_D'
1920: THEN
1921: UPDATE mth_run_log
1922: SET from_date = p_run_start_date
1923: WHERE

Line 3045: --DELETE FROM mth_workday_shifts_D WHERE plant_fk_key = l_plant_fk_key and shift_date>=l_start_date ;

3041: l_system_fk_key := "MTH_UTIL_PKG"."MTH_UA_GET_VAL"();
3042:
3043: IF (l_end_date > l_start_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))

Line 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;

3042:
3043: IF (l_end_date > l_start_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

Line 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;

3043: IF (l_end_date > l_start_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

Line 3099: INSERT INTO mth_workday_shifts_D(shift_workday_pk_key, shift_workday_pk,

3095: TO_NUMBER(SUBSTR(l_end_time,4,2))*60+
3096: TO_NUMBER(SUBSTR(l_end_time,7,2));
3097:
3098:
3099: INSERT INTO mth_workday_shifts_D(shift_workday_pk_key, shift_workday_pk,
3100: shift_date,shift_date_julian,plant_fk_key,shift_type,
3101: graveyard_shift,from_date,to_date, shift_num,shift_name,
3102: source_org_code,system_fk_key,
3103: creation_date,last_update_date,creation_system_id,

Line 3152: FROM mth_workday_shifts_d a ,

3148: b.entity_type entity_type,SYSDATE,SYSDATE,-1,-99999
3149:
3150: --INTO l_site_id,l_entity_pk_key,l_entity_name,l_entity_type,l_production_entity,
3151: --l_shift_workday_pk_key,l1_shift_date,l_from_date,l_to_date
3152: FROM mth_workday_shifts_d a ,
3153: (
3154: SELECT plant_fk_key site_id, entity_pk_key, entity_name, entity_type, production_entity production_entity
3155: FROM mth_equip_entities_mst
3156: UNION ALL

Line 3187: FROM mth_workday_shifts_d a ,

3183: b.entity_type entity_type,SYSDATE,SYSDATE,-1,-99999
3184:
3185: --INTO l_site_id,l_entity_pk_key,l_entity_name,l_entity_type,l_production_entity,
3186: --l_shift_workday_pk_key,l1_shift_date,l_from_date,l_to_date
3187: FROM mth_workday_shifts_d a ,
3188: (
3189: SELECT plant_fk_key site_id, entity_pk_key, entity_name, entity_type, production_entity production_entity
3190: FROM mth_equip_entities_mst
3191: UNION ALL

Line 3223: FROM mth_workday_shifts_d a ,

3219: b.entity_type entity_type,SYSDATE,SYSDATE,-1,-99999
3220:
3221: --INTO l_site_id,l_entity_pk_key,l_entity_name,l_entity_type,l_production_entity,
3222: --l_shift_workday_pk_key,l1_shift_date,l_from_date,l_to_date
3223: FROM mth_workday_shifts_d a ,
3224: (
3225: SELECT plant_fk_key site_id, entity_pk_key, entity_name, entity_type, production_entity production_entity
3226: FROM mth_equip_entities_mst
3227: UNION ALL

Line 3269: INSERT INTO mth_workday_shifts_D(shift_workday_pk_key, shift_workday_pk,

3265: l_last_update_system_id := -99999;
3266: l_last_update_date := l_sysdate;
3267: l_creation_system_id := -1;
3268:
3269: INSERT INTO mth_workday_shifts_D(shift_workday_pk_key, shift_workday_pk,
3270: shift_date,shift_date_julian,plant_fk_key,shift_type,graveyard_shift,from_date,to_date, shift_num,shift_name,source_org_code,system_fk_key,
3271: creation_date,last_update_date,creation_system_id,
3272: last_update_system_id)
3273: VALUES(mth_workdays_shifts_s.nextval,TO_CHAR(l_start_date,'yyyymmdd-hh24:mi:ss')||'-'||l_plant_pk|| "MTH_UTIL_PKG"."MTH_UA_GET_VAL"(),l_start_date ,TO_NUMBER(TO_CHAR( l_start_date ,'J')),

Line 3297: FROM mth_workday_shifts_d a ,

3293: b.entity_type entity_type,SYSDATE,SYSDATE,-1,-99999
3294:
3295: --INTO l_site_id,l_entity_pk_key,l_entity_name,l_entity_type,l_production_entity,
3296: --l_shift_workday_pk_key,l1_shift_date,l_from_date,l_to_date
3297: FROM mth_workday_shifts_d a ,
3298: (
3299: SELECT plant_fk_key site_id, entity_pk_key, entity_name, entity_type, production_entity production_entity
3300: FROM mth_equip_entities_mst
3301: UNION ALL

Line 4023: FROM MTH_WORKDAY_SHIFTS_D WSD,MTH_ALL_ENTITIES_V MAV

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')
4026: AND WSD.PLANT_FK_KEY = MAV.SITE_ID
4027: AND

Line 4069: MTH_WORKDAY_SHIFTS_D WSD

4065: WSD.FROM_DATE,
4066: WSD.TO_DATE,
4067: MAV.ENTITY_TYPE
4068: FROM MTH_ALL_ENTITIES_V MAV,
4069: MTH_WORKDAY_SHIFTS_D WSD
4070: WHERE (WSD.LAST_UPDATE_DATE > v_log_from_date OR
4071: ( MAV.CREATION_DATE > v_log_from_date AND
4072: TRUNC( MAV.CREATION_DATE ) <= WSD.SHIFT_DATE))
4073: AND (MAV.PRODUCTION_ENTITY ='Y'or MAV.PRODUCTION_ENTITY ='N')

Line 4406: mth_workday_shifts_D wsd,

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,
4409: mth_plants_d plants ,
4410: MTH_ORGANIZATIONS_L MOL,

Line 4427: DELETE FROM mth_workday_shifts_D

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,
4430: mth_shift_reference_MV mv,
4431: mth_workday_shifts_stg stg,

Line 4429: mth_workday_shifts_D wsd,

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,
4430: mth_shift_reference_MV mv,
4431: mth_workday_shifts_stg stg,
4432: mth_plants_d plants ,
4433: MTH_ORGANIZATIONS_L MOL,

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

4444: AND NVL(STG.SYSTEM_FK, MTH_UTIL_PKG.MTH_UA_GET_VAL() ) = MS.SYSTEM_PK
4445: AND stg.err_code IS NULL
4446: And stg.SOURCE_ORG_CODE = nvl ( wsd.SOURCE_ORG_CODE , stg.SOURCE_ORG_CODE ));
4447:
4448: mth_util_pkg.log_msg('Number of rows deleted from mth_workday_shifts_D - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4449:
4450: INSERT INTO MTH_WORKDAY_SHIFTS_D
4451: (SHIFT_WORKDAY_PK_KEY,
4452: SHIFT_WORKDAY_PK,

Line 4450: INSERT INTO MTH_WORKDAY_SHIFTS_D

4446: And stg.SOURCE_ORG_CODE = nvl ( wsd.SOURCE_ORG_CODE , stg.SOURCE_ORG_CODE ));
4447:
4448: mth_util_pkg.log_msg('Number of rows deleted from mth_workday_shifts_D - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4449:
4450: INSERT INTO MTH_WORKDAY_SHIFTS_D
4451: (SHIFT_WORKDAY_PK_KEY,
4452: SHIFT_WORKDAY_PK,
4453: SHIFT_DATE,
4454: SHIFT_DATE_JULIAN,

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

4521: AND NVL( STG.SHIFT_TYPE ,'Production Shift') = FL2.MEANING
4522: AND STG.processing_flag = v_processing_flag
4523: AND STG.ERR_CODE IS NULL );
4524:
4525: mth_util_pkg.log_msg('Number of rows inserted in mth_workday_shifts_D - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4526:
4527:
4528: INSERT INTO MTH_WORKDAY_SHIFTS_D
4529: (SHIFT_WORKDAY_PK_KEY,

Line 4528: INSERT INTO MTH_WORKDAY_SHIFTS_D

4524:
4525: mth_util_pkg.log_msg('Number of rows inserted in mth_workday_shifts_D - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4526:
4527:
4528: INSERT INTO MTH_WORKDAY_SHIFTS_D
4529: (SHIFT_WORKDAY_PK_KEY,
4530: SHIFT_WORKDAY_PK,
4531: SHIFT_DATE,
4532: SHIFT_DATE_JULIAN,

Line 4601: mth_util_pkg.log_msg('Number of catch all rows inserted in mth_workday_shifts_D - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

4597: AND STG.SOURCE_ORG_CODE = MOL.ORGANIZATION_CODE
4598: AND CATCH_ALL.DAY = stg.SHIFT_DATE
4599: );
4600:
4601: mth_util_pkg.log_msg('Number of catch all rows inserted in mth_workday_shifts_D - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4602:
4603: mth_util_pkg.truncate_table_partition(' MTH_WORKDAY_SHIFTS_STG',v_processing_flag);
4604:
4605: mth_util_pkg.log_msg('MTH_WORKDAY_SHIFTS_SF end', mth_util_pkg.G_DBG_PROC_FUN_END);