APPS.MTH_UTIL_PKG dependencies on MTH_SHIFT_REFERENCE_MV

Line 1040: SELECT Count(*) into v_count FROM mth_shift_reference_mv;

1036:
1037: BEGIN
1038:
1039: --select the count value into the local variable.
1040: SELECT Count(*) into v_count FROM mth_shift_reference_mv;
1041:
1042: --Return the value.
1043: RETURN(v_count);
1044:

Line 3004: FROM mth_shift_reference_mv

3000:
3001: CURSOR c_shift_date(p_plant_key NUMBER)
3002: IS
3003: SELECT shift_date
3004: FROM mth_shift_reference_mv
3005: WHERE PLANT_FK_KEY = p_plant_key;
3006:
3007: CURSOR c_check_compile_state
3008: IS

Line 3011: WHERE mview_name = 'MTH_SHIFT_REFERENCE_MV';

3007: CURSOR c_check_compile_state
3008: IS
3009: SELECT compile_state
3010: FROM user_mviews
3011: WHERE mview_name = 'MTH_SHIFT_REFERENCE_MV';
3012:
3013: BEGIN
3014:
3015:

Line 3017: DBMS_MVIEW.REFRESH('MTH_SHIFT_REFERENCE_MV','C');

3013: BEGIN
3014:
3015:
3016:
3017: DBMS_MVIEW.REFRESH('MTH_SHIFT_REFERENCE_MV','C');
3018:
3019: OPEN c_check_compile_state;
3020: FETCH c_check_compile_state INTO l_comp_state;
3021: CLOSE c_check_compile_state;

Line 4194: mth_util_pkg.REFRESH_ONE_MV ('MTH_SHIFT_REFERENCE_MV',null,null,'C');

4190: --delete data from the output error table
4191: DELETE FROM MTH_WORKDAY_SHIFTS_ERR
4192: WHERE UPPER(REPROCESS_READY_YN) IN ('D','Y'); --Bug 14753663
4193: mth_util_pkg.log_msg('Number of rows deleted in MTH_WORKDAY_SHIFTS_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4194: mth_util_pkg.REFRESH_ONE_MV ('MTH_SHIFT_REFERENCE_MV',null,null,'C');
4195: mth_util_pkg.switch_column_default_value('MTH_WORKDAY_SHIFTS_STG',v_processing_flag);
4196: IF ( v_processing_flag=1 OR v_processing_flag=2 ) THEN
4197:
4198: --Execute all validations on csv records

Line 4330: MTH_SHIFT_REFERENCE_MV MSV,

4326: WHERE EXISTS (SELECT *
4327: FROM
4328: (SELECT stg.shift_workday_pk
4329: FROM mth_workday_shifts_stg stg,
4330: MTH_SHIFT_REFERENCE_MV MSV,
4331: mth_plants_d plants,
4332: mth_organizations_l mol,
4333: mth_systems_setup ms
4334: WHERE NVL(MSV.SHIFT_DATE,stg.shift_date-1) >= stg.shift_date

Line 4407: mth_shift_reference_MV mv,

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,
4411: MTH_SYSTEMS_SETUP MS

Line 4430: mth_shift_reference_MV mv,

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,
4434: MTH_SYSTEMS_SETUP MS