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_MV_TO_FACT_PKG dependencies on MTH_EQUIPMENT_DENORM_D

Line 28: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIPMENT_DENORM_D_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date);

24: v_log_to_date := sysdate;
25: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
26:
27: -- Call mth_run_log_pre_load
28: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIPMENT_DENORM_D_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date);
29: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIPMENT_DENORM_D_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
30: mth_util_pkg.log_msg('v_log_from_date - ' || to_char(v_log_from_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
31: mth_util_pkg.log_msg('v_log_to_date - ' || to_char(v_log_to_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
32:

Line 29: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIPMENT_DENORM_D_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);

25: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
26:
27: -- Call mth_run_log_pre_load
28: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIPMENT_DENORM_D_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date);
29: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIPMENT_DENORM_D_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
30: mth_util_pkg.log_msg('v_log_from_date - ' || to_char(v_log_from_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
31: mth_util_pkg.log_msg('v_log_to_date - ' || to_char(v_log_to_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
32:
33: -- Update the Resource cost and other columns on the equipment shifts table

Line 40: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY "EQUIPMENT_FK_KEY",

36: INTO
37: MTH_EQUIPMENT_SHIFTS_D
38: USING
39: (SELECT
40: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY "EQUIPMENT_FK_KEY",
41: MTH_EQUIPMENT_SHIFTS_D_SQ.SHIFT_WORKDAY_FK_KEY "SHIFT_WORKDAY_FK_KEY",
42: v_log_to_date "LAST_UPDATE_DATE",
43: v_unassigned_val "LAST_UPDATE_SYSTEM_ID",
44: v_unassigned_val "LAST_UPDATED_BY",

Line 56: (MTH_RUN_LOG.FACT_TABLE = 'MTH_EQUIPMENT_DENORM_D_MV' )) MTH_RUN_LOG_SQ , */

52: MTH_RUN_LOG.TO_DATE
53: FROM
54: MTH_RUN_LOG
55: WHERE
56: (MTH_RUN_LOG.FACT_TABLE = 'MTH_EQUIPMENT_DENORM_D_MV' )) MTH_RUN_LOG_SQ , */
57: (SELECT
58: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_FK_KEY,
59: MTH_EQUIPMENT_DENORM_D.LEVEL9_LEVEL_KEY ,
60: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EFFECTIVE_DATE,

Line 58: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_FK_KEY,

54: MTH_RUN_LOG
55: WHERE
56: (MTH_RUN_LOG.FACT_TABLE = 'MTH_EQUIPMENT_DENORM_D_MV' )) MTH_RUN_LOG_SQ , */
57: (SELECT
58: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_FK_KEY,
59: MTH_EQUIPMENT_DENORM_D.LEVEL9_LEVEL_KEY ,
60: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EFFECTIVE_DATE,
61: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EXPIRATION_DATE,
62: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_HIERARCHY_KEY

Line 59: MTH_EQUIPMENT_DENORM_D.LEVEL9_LEVEL_KEY ,

55: WHERE
56: (MTH_RUN_LOG.FACT_TABLE = 'MTH_EQUIPMENT_DENORM_D_MV' )) MTH_RUN_LOG_SQ , */
57: (SELECT
58: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_FK_KEY,
59: MTH_EQUIPMENT_DENORM_D.LEVEL9_LEVEL_KEY ,
60: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EFFECTIVE_DATE,
61: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EXPIRATION_DATE,
62: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_HIERARCHY_KEY
63: FROM MTH_EQUIPMENT_DENORM_D ) MTH_EQUIPMENT_DENORM_D_SQ,

Line 60: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EFFECTIVE_DATE,

56: (MTH_RUN_LOG.FACT_TABLE = 'MTH_EQUIPMENT_DENORM_D_MV' )) MTH_RUN_LOG_SQ , */
57: (SELECT
58: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_FK_KEY,
59: MTH_EQUIPMENT_DENORM_D.LEVEL9_LEVEL_KEY ,
60: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EFFECTIVE_DATE,
61: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EXPIRATION_DATE,
62: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_HIERARCHY_KEY
63: FROM MTH_EQUIPMENT_DENORM_D ) MTH_EQUIPMENT_DENORM_D_SQ,
64: (SELECT

Line 61: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EXPIRATION_DATE,

57: (SELECT
58: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_FK_KEY,
59: MTH_EQUIPMENT_DENORM_D.LEVEL9_LEVEL_KEY ,
60: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EFFECTIVE_DATE,
61: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EXPIRATION_DATE,
62: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_HIERARCHY_KEY
63: FROM MTH_EQUIPMENT_DENORM_D ) MTH_EQUIPMENT_DENORM_D_SQ,
64: (SELECT
65: MTH_EQUIP_HIERARCHY.HIERARCHY_ID,

Line 62: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_HIERARCHY_KEY

58: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_FK_KEY,
59: MTH_EQUIPMENT_DENORM_D.LEVEL9_LEVEL_KEY ,
60: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EFFECTIVE_DATE,
61: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EXPIRATION_DATE,
62: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_HIERARCHY_KEY
63: FROM MTH_EQUIPMENT_DENORM_D ) MTH_EQUIPMENT_DENORM_D_SQ,
64: (SELECT
65: MTH_EQUIP_HIERARCHY.HIERARCHY_ID,
66: MTH_EQUIP_HIERARCHY.LEVEL_NUM,

Line 63: FROM MTH_EQUIPMENT_DENORM_D ) MTH_EQUIPMENT_DENORM_D_SQ,

59: MTH_EQUIPMENT_DENORM_D.LEVEL9_LEVEL_KEY ,
60: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EFFECTIVE_DATE,
61: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EXPIRATION_DATE,
62: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_HIERARCHY_KEY
63: FROM MTH_EQUIPMENT_DENORM_D ) MTH_EQUIPMENT_DENORM_D_SQ,
64: (SELECT
65: MTH_EQUIP_HIERARCHY.HIERARCHY_ID,
66: MTH_EQUIP_HIERARCHY.LEVEL_NUM,
67: MTH_EQUIP_HIERARCHY.LEVEL_FK_KEY,

Line 91: MTH_EQUIP_HIERARCHY_SQ.HIERARCHY_ID = MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_HIERARCHY_KEY and

87: WHERE
88: ( MTH_EQUIP_HIERARCHY_SQ.LAST_UPDATE_DATE > v_log_from_date AND
89: MTH_EQUIP_HIERARCHY_SQ.LAST_UPDATE_DATE <= v_log_to_date AND
90: MTH_EQUIP_HIERARCHY_SQ.HIERARCHY_ID = -2 and
91: MTH_EQUIP_HIERARCHY_SQ.HIERARCHY_ID = MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_HIERARCHY_KEY and
92: MTH_EQUIP_HIERARCHY_SQ.LEVEL_NUM = 10 and
93: MTH_EQUIP_HIERARCHY_SQ.LEVEL_FK_KEY = MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY And
94: MTH_EQUIPMENT_DENORM_D_SQ.LEVEL9_LEVEL_KEY = MTH_RESOURCE_COST_MV_SQ.RESOURCE_FK_KEY (+) And
95: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE = MTH_EQUIP_HIERARCHY_SQ.EFFECTIVE_DATE AND

Line 93: MTH_EQUIP_HIERARCHY_SQ.LEVEL_FK_KEY = MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY And

89: MTH_EQUIP_HIERARCHY_SQ.LAST_UPDATE_DATE <= v_log_to_date AND
90: MTH_EQUIP_HIERARCHY_SQ.HIERARCHY_ID = -2 and
91: MTH_EQUIP_HIERARCHY_SQ.HIERARCHY_ID = MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_HIERARCHY_KEY and
92: MTH_EQUIP_HIERARCHY_SQ.LEVEL_NUM = 10 and
93: MTH_EQUIP_HIERARCHY_SQ.LEVEL_FK_KEY = MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY And
94: MTH_EQUIPMENT_DENORM_D_SQ.LEVEL9_LEVEL_KEY = MTH_RESOURCE_COST_MV_SQ.RESOURCE_FK_KEY (+) And
95: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE = MTH_EQUIP_HIERARCHY_SQ.EFFECTIVE_DATE AND
96: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY = MTH_EQUIPMENT_SHIFTS_D_SQ.EQUIPMENT_FK_KEY AND
97: MTH_EQUIPMENT_SHIFTS_D_SQ.SHIFT_WORKDAY_FK_KEY = MTH_SHIFT_GREGORIAN_DENORM_SQ.SHIFT_WORKDAY_PK_KEY AND

Line 94: MTH_EQUIPMENT_DENORM_D_SQ.LEVEL9_LEVEL_KEY = MTH_RESOURCE_COST_MV_SQ.RESOURCE_FK_KEY (+) And

90: MTH_EQUIP_HIERARCHY_SQ.HIERARCHY_ID = -2 and
91: MTH_EQUIP_HIERARCHY_SQ.HIERARCHY_ID = MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_HIERARCHY_KEY and
92: MTH_EQUIP_HIERARCHY_SQ.LEVEL_NUM = 10 and
93: MTH_EQUIP_HIERARCHY_SQ.LEVEL_FK_KEY = MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY And
94: MTH_EQUIPMENT_DENORM_D_SQ.LEVEL9_LEVEL_KEY = MTH_RESOURCE_COST_MV_SQ.RESOURCE_FK_KEY (+) And
95: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE = MTH_EQUIP_HIERARCHY_SQ.EFFECTIVE_DATE AND
96: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY = MTH_EQUIPMENT_SHIFTS_D_SQ.EQUIPMENT_FK_KEY AND
97: MTH_EQUIPMENT_SHIFTS_D_SQ.SHIFT_WORKDAY_FK_KEY = MTH_SHIFT_GREGORIAN_DENORM_SQ.SHIFT_WORKDAY_PK_KEY AND
98: MTH_SHIFT_GREGORIAN_DENORM_SQ.FROM_DATE between MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE AND

Line 95: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE = MTH_EQUIP_HIERARCHY_SQ.EFFECTIVE_DATE AND

91: MTH_EQUIP_HIERARCHY_SQ.HIERARCHY_ID = MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_HIERARCHY_KEY and
92: MTH_EQUIP_HIERARCHY_SQ.LEVEL_NUM = 10 and
93: MTH_EQUIP_HIERARCHY_SQ.LEVEL_FK_KEY = MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY And
94: MTH_EQUIPMENT_DENORM_D_SQ.LEVEL9_LEVEL_KEY = MTH_RESOURCE_COST_MV_SQ.RESOURCE_FK_KEY (+) And
95: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE = MTH_EQUIP_HIERARCHY_SQ.EFFECTIVE_DATE AND
96: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY = MTH_EQUIPMENT_SHIFTS_D_SQ.EQUIPMENT_FK_KEY AND
97: MTH_EQUIPMENT_SHIFTS_D_SQ.SHIFT_WORKDAY_FK_KEY = MTH_SHIFT_GREGORIAN_DENORM_SQ.SHIFT_WORKDAY_PK_KEY AND
98: MTH_SHIFT_GREGORIAN_DENORM_SQ.FROM_DATE between MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE AND
99: nvl( MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EXPIRATION_DATE,

Line 96: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY = MTH_EQUIPMENT_SHIFTS_D_SQ.EQUIPMENT_FK_KEY AND

92: MTH_EQUIP_HIERARCHY_SQ.LEVEL_NUM = 10 and
93: MTH_EQUIP_HIERARCHY_SQ.LEVEL_FK_KEY = MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY And
94: MTH_EQUIPMENT_DENORM_D_SQ.LEVEL9_LEVEL_KEY = MTH_RESOURCE_COST_MV_SQ.RESOURCE_FK_KEY (+) And
95: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE = MTH_EQUIP_HIERARCHY_SQ.EFFECTIVE_DATE AND
96: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY = MTH_EQUIPMENT_SHIFTS_D_SQ.EQUIPMENT_FK_KEY AND
97: MTH_EQUIPMENT_SHIFTS_D_SQ.SHIFT_WORKDAY_FK_KEY = MTH_SHIFT_GREGORIAN_DENORM_SQ.SHIFT_WORKDAY_PK_KEY AND
98: MTH_SHIFT_GREGORIAN_DENORM_SQ.FROM_DATE between MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE AND
99: nvl( MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EXPIRATION_DATE,
100: TO_DATE('4000-01-01', 'YYYY-MM-DD')))

Line 98: MTH_SHIFT_GREGORIAN_DENORM_SQ.FROM_DATE between MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE AND

94: MTH_EQUIPMENT_DENORM_D_SQ.LEVEL9_LEVEL_KEY = MTH_RESOURCE_COST_MV_SQ.RESOURCE_FK_KEY (+) And
95: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE = MTH_EQUIP_HIERARCHY_SQ.EFFECTIVE_DATE AND
96: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY = MTH_EQUIPMENT_SHIFTS_D_SQ.EQUIPMENT_FK_KEY AND
97: MTH_EQUIPMENT_SHIFTS_D_SQ.SHIFT_WORKDAY_FK_KEY = MTH_SHIFT_GREGORIAN_DENORM_SQ.SHIFT_WORKDAY_PK_KEY AND
98: MTH_SHIFT_GREGORIAN_DENORM_SQ.FROM_DATE between MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE AND
99: nvl( MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EXPIRATION_DATE,
100: TO_DATE('4000-01-01', 'YYYY-MM-DD')))
101: )
102: MERGE_EQUIP_SHIFTS_SQ

Line 99: nvl( MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EXPIRATION_DATE,

95: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE = MTH_EQUIP_HIERARCHY_SQ.EFFECTIVE_DATE AND
96: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY = MTH_EQUIPMENT_SHIFTS_D_SQ.EQUIPMENT_FK_KEY AND
97: MTH_EQUIPMENT_SHIFTS_D_SQ.SHIFT_WORKDAY_FK_KEY = MTH_SHIFT_GREGORIAN_DENORM_SQ.SHIFT_WORKDAY_PK_KEY AND
98: MTH_SHIFT_GREGORIAN_DENORM_SQ.FROM_DATE between MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE AND
99: nvl( MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EXPIRATION_DATE,
100: TO_DATE('4000-01-01', 'YYYY-MM-DD')))
101: )
102: MERGE_EQUIP_SHIFTS_SQ
103: ON

Line 126: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY "EQUIPMENT_FK_KEY",

122: INTO
123: MTH_EQUIP_OUTPUT_SUMMARY
124: USING
125: (SELECT
126: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY "EQUIPMENT_FK_KEY",
127: MTH_EQUIP_OUTPUT_SUMMARY_SQ.SHIFT_WORKDAY_FK_KEY "SHIFT_WORKDAY_FK_KEY",
128: v_log_to_date "LAST_UPDATE_DATE",
129: v_unassigned_val "LAST_UPDATE_SYSTEM_ID",
130: v_unassigned_val "LAST_UPDATED_BY",

Line 142: (MTH_RUN_LOG.FACT_TABLE = 'MTH_EQUIPMENT_DENORM_D_MV' )) MTH_RUN_LOG_SQ ,*/

138: MTH_RUN_LOG.TO_DATE
139: FROM
140: MTH_RUN_LOG
141: WHERE
142: (MTH_RUN_LOG.FACT_TABLE = 'MTH_EQUIPMENT_DENORM_D_MV' )) MTH_RUN_LOG_SQ ,*/
143: (SELECT
144: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_FK_KEY,
145: MTH_EQUIPMENT_DENORM_D.LEVEL9_LEVEL_KEY ,
146: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EFFECTIVE_DATE,

Line 144: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_FK_KEY,

140: MTH_RUN_LOG
141: WHERE
142: (MTH_RUN_LOG.FACT_TABLE = 'MTH_EQUIPMENT_DENORM_D_MV' )) MTH_RUN_LOG_SQ ,*/
143: (SELECT
144: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_FK_KEY,
145: MTH_EQUIPMENT_DENORM_D.LEVEL9_LEVEL_KEY ,
146: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EFFECTIVE_DATE,
147: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EXPIRATION_DATE,
148: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_HIERARCHY_KEY

Line 145: MTH_EQUIPMENT_DENORM_D.LEVEL9_LEVEL_KEY ,

141: WHERE
142: (MTH_RUN_LOG.FACT_TABLE = 'MTH_EQUIPMENT_DENORM_D_MV' )) MTH_RUN_LOG_SQ ,*/
143: (SELECT
144: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_FK_KEY,
145: MTH_EQUIPMENT_DENORM_D.LEVEL9_LEVEL_KEY ,
146: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EFFECTIVE_DATE,
147: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EXPIRATION_DATE,
148: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_HIERARCHY_KEY
149: FROM MTH_EQUIPMENT_DENORM_D ) MTH_EQUIPMENT_DENORM_D_SQ,

Line 146: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EFFECTIVE_DATE,

142: (MTH_RUN_LOG.FACT_TABLE = 'MTH_EQUIPMENT_DENORM_D_MV' )) MTH_RUN_LOG_SQ ,*/
143: (SELECT
144: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_FK_KEY,
145: MTH_EQUIPMENT_DENORM_D.LEVEL9_LEVEL_KEY ,
146: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EFFECTIVE_DATE,
147: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EXPIRATION_DATE,
148: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_HIERARCHY_KEY
149: FROM MTH_EQUIPMENT_DENORM_D ) MTH_EQUIPMENT_DENORM_D_SQ,
150: (SELECT

Line 147: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EXPIRATION_DATE,

143: (SELECT
144: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_FK_KEY,
145: MTH_EQUIPMENT_DENORM_D.LEVEL9_LEVEL_KEY ,
146: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EFFECTIVE_DATE,
147: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EXPIRATION_DATE,
148: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_HIERARCHY_KEY
149: FROM MTH_EQUIPMENT_DENORM_D ) MTH_EQUIPMENT_DENORM_D_SQ,
150: (SELECT
151: MTH_EQUIP_HIERARCHY.HIERARCHY_ID,

Line 148: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_HIERARCHY_KEY

144: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_FK_KEY,
145: MTH_EQUIPMENT_DENORM_D.LEVEL9_LEVEL_KEY ,
146: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EFFECTIVE_DATE,
147: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EXPIRATION_DATE,
148: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_HIERARCHY_KEY
149: FROM MTH_EQUIPMENT_DENORM_D ) MTH_EQUIPMENT_DENORM_D_SQ,
150: (SELECT
151: MTH_EQUIP_HIERARCHY.HIERARCHY_ID,
152: MTH_EQUIP_HIERARCHY.LEVEL_NUM,

Line 149: FROM MTH_EQUIPMENT_DENORM_D ) MTH_EQUIPMENT_DENORM_D_SQ,

145: MTH_EQUIPMENT_DENORM_D.LEVEL9_LEVEL_KEY ,
146: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EFFECTIVE_DATE,
147: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EXPIRATION_DATE,
148: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_HIERARCHY_KEY
149: FROM MTH_EQUIPMENT_DENORM_D ) MTH_EQUIPMENT_DENORM_D_SQ,
150: (SELECT
151: MTH_EQUIP_HIERARCHY.HIERARCHY_ID,
152: MTH_EQUIP_HIERARCHY.LEVEL_NUM,
153: MTH_EQUIP_HIERARCHY.LEVEL_FK_KEY,

Line 176: MTH_EQUIP_HIERARCHY_SQ.HIERARCHY_ID = MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_HIERARCHY_KEY and

172: WHERE
173: ( MTH_EQUIP_HIERARCHY_SQ.LAST_UPDATE_DATE > v_log_from_date AND
174: MTH_EQUIP_HIERARCHY_SQ.LAST_UPDATE_DATE <= v_log_to_date AND
175: MTH_EQUIP_HIERARCHY_SQ.HIERARCHY_ID = -2 and
176: MTH_EQUIP_HIERARCHY_SQ.HIERARCHY_ID = MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_HIERARCHY_KEY and
177: MTH_EQUIP_HIERARCHY_SQ.LEVEL_NUM = 10 and
178: MTH_EQUIP_HIERARCHY_SQ.LEVEL_FK_KEY = MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY And
179: MTH_EQUIPMENT_DENORM_D_SQ.LEVEL9_LEVEL_KEY = MTH_RESOURCE_COST_MV_SQ.RESOURCE_FK_KEY (+) And
180: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE = MTH_EQUIP_HIERARCHY_SQ.EFFECTIVE_DATE AND

Line 178: MTH_EQUIP_HIERARCHY_SQ.LEVEL_FK_KEY = MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY And

174: MTH_EQUIP_HIERARCHY_SQ.LAST_UPDATE_DATE <= v_log_to_date AND
175: MTH_EQUIP_HIERARCHY_SQ.HIERARCHY_ID = -2 and
176: MTH_EQUIP_HIERARCHY_SQ.HIERARCHY_ID = MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_HIERARCHY_KEY and
177: MTH_EQUIP_HIERARCHY_SQ.LEVEL_NUM = 10 and
178: MTH_EQUIP_HIERARCHY_SQ.LEVEL_FK_KEY = MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY And
179: MTH_EQUIPMENT_DENORM_D_SQ.LEVEL9_LEVEL_KEY = MTH_RESOURCE_COST_MV_SQ.RESOURCE_FK_KEY (+) And
180: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE = MTH_EQUIP_HIERARCHY_SQ.EFFECTIVE_DATE AND
181: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY = MTH_EQUIP_OUTPUT_SUMMARY_SQ.EQUIPMENT_FK_KEY AND
182: MTH_EQUIP_OUTPUT_SUMMARY_SQ.SHIFT_WORKDAY_FK_KEY = MTH_SHIFT_GREGORIAN_DENORM_SQ.SHIFT_WORKDAY_PK_KEY AND

Line 179: MTH_EQUIPMENT_DENORM_D_SQ.LEVEL9_LEVEL_KEY = MTH_RESOURCE_COST_MV_SQ.RESOURCE_FK_KEY (+) And

175: MTH_EQUIP_HIERARCHY_SQ.HIERARCHY_ID = -2 and
176: MTH_EQUIP_HIERARCHY_SQ.HIERARCHY_ID = MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_HIERARCHY_KEY and
177: MTH_EQUIP_HIERARCHY_SQ.LEVEL_NUM = 10 and
178: MTH_EQUIP_HIERARCHY_SQ.LEVEL_FK_KEY = MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY And
179: MTH_EQUIPMENT_DENORM_D_SQ.LEVEL9_LEVEL_KEY = MTH_RESOURCE_COST_MV_SQ.RESOURCE_FK_KEY (+) And
180: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE = MTH_EQUIP_HIERARCHY_SQ.EFFECTIVE_DATE AND
181: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY = MTH_EQUIP_OUTPUT_SUMMARY_SQ.EQUIPMENT_FK_KEY AND
182: MTH_EQUIP_OUTPUT_SUMMARY_SQ.SHIFT_WORKDAY_FK_KEY = MTH_SHIFT_GREGORIAN_DENORM_SQ.SHIFT_WORKDAY_PK_KEY AND
183: MTH_SHIFT_GREGORIAN_DENORM_SQ.FROM_DATE between MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE AND

Line 180: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE = MTH_EQUIP_HIERARCHY_SQ.EFFECTIVE_DATE AND

176: MTH_EQUIP_HIERARCHY_SQ.HIERARCHY_ID = MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_HIERARCHY_KEY and
177: MTH_EQUIP_HIERARCHY_SQ.LEVEL_NUM = 10 and
178: MTH_EQUIP_HIERARCHY_SQ.LEVEL_FK_KEY = MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY And
179: MTH_EQUIPMENT_DENORM_D_SQ.LEVEL9_LEVEL_KEY = MTH_RESOURCE_COST_MV_SQ.RESOURCE_FK_KEY (+) And
180: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE = MTH_EQUIP_HIERARCHY_SQ.EFFECTIVE_DATE AND
181: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY = MTH_EQUIP_OUTPUT_SUMMARY_SQ.EQUIPMENT_FK_KEY AND
182: MTH_EQUIP_OUTPUT_SUMMARY_SQ.SHIFT_WORKDAY_FK_KEY = MTH_SHIFT_GREGORIAN_DENORM_SQ.SHIFT_WORKDAY_PK_KEY AND
183: MTH_SHIFT_GREGORIAN_DENORM_SQ.FROM_DATE between MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE AND
184: nvl( MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EXPIRATION_DATE,

Line 181: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY = MTH_EQUIP_OUTPUT_SUMMARY_SQ.EQUIPMENT_FK_KEY AND

177: MTH_EQUIP_HIERARCHY_SQ.LEVEL_NUM = 10 and
178: MTH_EQUIP_HIERARCHY_SQ.LEVEL_FK_KEY = MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY And
179: MTH_EQUIPMENT_DENORM_D_SQ.LEVEL9_LEVEL_KEY = MTH_RESOURCE_COST_MV_SQ.RESOURCE_FK_KEY (+) And
180: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE = MTH_EQUIP_HIERARCHY_SQ.EFFECTIVE_DATE AND
181: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY = MTH_EQUIP_OUTPUT_SUMMARY_SQ.EQUIPMENT_FK_KEY AND
182: MTH_EQUIP_OUTPUT_SUMMARY_SQ.SHIFT_WORKDAY_FK_KEY = MTH_SHIFT_GREGORIAN_DENORM_SQ.SHIFT_WORKDAY_PK_KEY AND
183: MTH_SHIFT_GREGORIAN_DENORM_SQ.FROM_DATE between MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE AND
184: nvl( MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EXPIRATION_DATE,
185: TO_DATE('4000-01-01', 'YYYY-MM-DD')))

Line 183: MTH_SHIFT_GREGORIAN_DENORM_SQ.FROM_DATE between MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE AND

179: MTH_EQUIPMENT_DENORM_D_SQ.LEVEL9_LEVEL_KEY = MTH_RESOURCE_COST_MV_SQ.RESOURCE_FK_KEY (+) And
180: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE = MTH_EQUIP_HIERARCHY_SQ.EFFECTIVE_DATE AND
181: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY = MTH_EQUIP_OUTPUT_SUMMARY_SQ.EQUIPMENT_FK_KEY AND
182: MTH_EQUIP_OUTPUT_SUMMARY_SQ.SHIFT_WORKDAY_FK_KEY = MTH_SHIFT_GREGORIAN_DENORM_SQ.SHIFT_WORKDAY_PK_KEY AND
183: MTH_SHIFT_GREGORIAN_DENORM_SQ.FROM_DATE between MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE AND
184: nvl( MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EXPIRATION_DATE,
185: TO_DATE('4000-01-01', 'YYYY-MM-DD')))
186: )
187: MERGE_EQUIP_OUTPUT_SQ

Line 184: nvl( MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EXPIRATION_DATE,

180: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE = MTH_EQUIP_HIERARCHY_SQ.EFFECTIVE_DATE AND
181: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY = MTH_EQUIP_OUTPUT_SUMMARY_SQ.EQUIPMENT_FK_KEY AND
182: MTH_EQUIP_OUTPUT_SUMMARY_SQ.SHIFT_WORKDAY_FK_KEY = MTH_SHIFT_GREGORIAN_DENORM_SQ.SHIFT_WORKDAY_PK_KEY AND
183: MTH_SHIFT_GREGORIAN_DENORM_SQ.FROM_DATE between MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE AND
184: nvl( MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EXPIRATION_DATE,
185: TO_DATE('4000-01-01', 'YYYY-MM-DD')))
186: )
187: MERGE_EQUIP_OUTPUT_SQ
188: ON

Line 211: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY "EQUIPMENT_FK_KEY",

207: INTO
208: MTH_EQUIP_STATUS_SUMMARY
209: USING
210: (SELECT
211: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY "EQUIPMENT_FK_KEY",
212: MTH_EQUIP_STATUS_SUMMARY_SQ.SHIFT_WORKDAY_FK_KEY "SHIFT_WORKDAY_FK_KEY",
213: v_log_to_date "LAST_UPDATE_DATE",
214: v_unassigned_val "LAST_UPDATE_SYSTEM_ID",
215: v_unassigned_val "LAST_UPDATED_BY",

Line 227: (MTH_RUN_LOG.FACT_TABLE = 'MTH_EQUIPMENT_DENORM_D_MV' )) MTH_RUN_LOG_SQ ,*/

223: MTH_RUN_LOG.TO_DATE
224: FROM
225: MTH_RUN_LOG
226: WHERE
227: (MTH_RUN_LOG.FACT_TABLE = 'MTH_EQUIPMENT_DENORM_D_MV' )) MTH_RUN_LOG_SQ ,*/
228: (SELECT
229: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_FK_KEY,
230: MTH_EQUIPMENT_DENORM_D.LEVEL9_LEVEL_KEY ,
231: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EFFECTIVE_DATE,

Line 229: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_FK_KEY,

225: MTH_RUN_LOG
226: WHERE
227: (MTH_RUN_LOG.FACT_TABLE = 'MTH_EQUIPMENT_DENORM_D_MV' )) MTH_RUN_LOG_SQ ,*/
228: (SELECT
229: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_FK_KEY,
230: MTH_EQUIPMENT_DENORM_D.LEVEL9_LEVEL_KEY ,
231: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EFFECTIVE_DATE,
232: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EXPIRATION_DATE,
233: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_HIERARCHY_KEY

Line 230: MTH_EQUIPMENT_DENORM_D.LEVEL9_LEVEL_KEY ,

226: WHERE
227: (MTH_RUN_LOG.FACT_TABLE = 'MTH_EQUIPMENT_DENORM_D_MV' )) MTH_RUN_LOG_SQ ,*/
228: (SELECT
229: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_FK_KEY,
230: MTH_EQUIPMENT_DENORM_D.LEVEL9_LEVEL_KEY ,
231: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EFFECTIVE_DATE,
232: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EXPIRATION_DATE,
233: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_HIERARCHY_KEY
234: FROM MTH_EQUIPMENT_DENORM_D ) MTH_EQUIPMENT_DENORM_D_SQ,

Line 231: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EFFECTIVE_DATE,

227: (MTH_RUN_LOG.FACT_TABLE = 'MTH_EQUIPMENT_DENORM_D_MV' )) MTH_RUN_LOG_SQ ,*/
228: (SELECT
229: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_FK_KEY,
230: MTH_EQUIPMENT_DENORM_D.LEVEL9_LEVEL_KEY ,
231: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EFFECTIVE_DATE,
232: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EXPIRATION_DATE,
233: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_HIERARCHY_KEY
234: FROM MTH_EQUIPMENT_DENORM_D ) MTH_EQUIPMENT_DENORM_D_SQ,
235: (SELECT

Line 232: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EXPIRATION_DATE,

228: (SELECT
229: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_FK_KEY,
230: MTH_EQUIPMENT_DENORM_D.LEVEL9_LEVEL_KEY ,
231: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EFFECTIVE_DATE,
232: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EXPIRATION_DATE,
233: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_HIERARCHY_KEY
234: FROM MTH_EQUIPMENT_DENORM_D ) MTH_EQUIPMENT_DENORM_D_SQ,
235: (SELECT
236: MTH_EQUIP_HIERARCHY.HIERARCHY_ID,

Line 233: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_HIERARCHY_KEY

229: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_FK_KEY,
230: MTH_EQUIPMENT_DENORM_D.LEVEL9_LEVEL_KEY ,
231: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EFFECTIVE_DATE,
232: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EXPIRATION_DATE,
233: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_HIERARCHY_KEY
234: FROM MTH_EQUIPMENT_DENORM_D ) MTH_EQUIPMENT_DENORM_D_SQ,
235: (SELECT
236: MTH_EQUIP_HIERARCHY.HIERARCHY_ID,
237: MTH_EQUIP_HIERARCHY.LEVEL_NUM,

Line 234: FROM MTH_EQUIPMENT_DENORM_D ) MTH_EQUIPMENT_DENORM_D_SQ,

230: MTH_EQUIPMENT_DENORM_D.LEVEL9_LEVEL_KEY ,
231: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EFFECTIVE_DATE,
232: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EXPIRATION_DATE,
233: MTH_EQUIPMENT_DENORM_D.EQUIPMENT_HIERARCHY_KEY
234: FROM MTH_EQUIPMENT_DENORM_D ) MTH_EQUIPMENT_DENORM_D_SQ,
235: (SELECT
236: MTH_EQUIP_HIERARCHY.HIERARCHY_ID,
237: MTH_EQUIP_HIERARCHY.LEVEL_NUM,
238: MTH_EQUIP_HIERARCHY.LEVEL_FK_KEY,

Line 261: MTH_EQUIP_HIERARCHY_SQ.HIERARCHY_ID = MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_HIERARCHY_KEY and

257: WHERE
258: ( MTH_EQUIP_HIERARCHY_SQ.LAST_UPDATE_DATE > v_log_from_date AND
259: MTH_EQUIP_HIERARCHY_SQ.LAST_UPDATE_DATE <= v_log_to_date AND
260: MTH_EQUIP_HIERARCHY_SQ.HIERARCHY_ID = -2 and
261: MTH_EQUIP_HIERARCHY_SQ.HIERARCHY_ID = MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_HIERARCHY_KEY and
262: MTH_EQUIP_HIERARCHY_SQ.LEVEL_NUM = 10 and
263: MTH_EQUIP_HIERARCHY_SQ.LEVEL_FK_KEY = MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY And
264: MTH_EQUIPMENT_DENORM_D_SQ.LEVEL9_LEVEL_KEY = MTH_RESOURCE_COST_MV_SQ.RESOURCE_FK_KEY (+) And
265: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE = MTH_EQUIP_HIERARCHY_SQ.EFFECTIVE_DATE AND

Line 263: MTH_EQUIP_HIERARCHY_SQ.LEVEL_FK_KEY = MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY And

259: MTH_EQUIP_HIERARCHY_SQ.LAST_UPDATE_DATE <= v_log_to_date AND
260: MTH_EQUIP_HIERARCHY_SQ.HIERARCHY_ID = -2 and
261: MTH_EQUIP_HIERARCHY_SQ.HIERARCHY_ID = MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_HIERARCHY_KEY and
262: MTH_EQUIP_HIERARCHY_SQ.LEVEL_NUM = 10 and
263: MTH_EQUIP_HIERARCHY_SQ.LEVEL_FK_KEY = MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY And
264: MTH_EQUIPMENT_DENORM_D_SQ.LEVEL9_LEVEL_KEY = MTH_RESOURCE_COST_MV_SQ.RESOURCE_FK_KEY (+) And
265: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE = MTH_EQUIP_HIERARCHY_SQ.EFFECTIVE_DATE AND
266: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY = MTH_EQUIP_STATUS_SUMMARY_SQ.EQUIPMENT_FK_KEY AND
267: MTH_EQUIP_STATUS_SUMMARY_SQ.SHIFT_WORKDAY_FK_KEY = MTH_SHIFT_GREGORIAN_DENORM_SQ.SHIFT_WORKDAY_PK_KEY AND

Line 264: MTH_EQUIPMENT_DENORM_D_SQ.LEVEL9_LEVEL_KEY = MTH_RESOURCE_COST_MV_SQ.RESOURCE_FK_KEY (+) And

260: MTH_EQUIP_HIERARCHY_SQ.HIERARCHY_ID = -2 and
261: MTH_EQUIP_HIERARCHY_SQ.HIERARCHY_ID = MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_HIERARCHY_KEY and
262: MTH_EQUIP_HIERARCHY_SQ.LEVEL_NUM = 10 and
263: MTH_EQUIP_HIERARCHY_SQ.LEVEL_FK_KEY = MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY And
264: MTH_EQUIPMENT_DENORM_D_SQ.LEVEL9_LEVEL_KEY = MTH_RESOURCE_COST_MV_SQ.RESOURCE_FK_KEY (+) And
265: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE = MTH_EQUIP_HIERARCHY_SQ.EFFECTIVE_DATE AND
266: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY = MTH_EQUIP_STATUS_SUMMARY_SQ.EQUIPMENT_FK_KEY AND
267: MTH_EQUIP_STATUS_SUMMARY_SQ.SHIFT_WORKDAY_FK_KEY = MTH_SHIFT_GREGORIAN_DENORM_SQ.SHIFT_WORKDAY_PK_KEY AND
268: MTH_SHIFT_GREGORIAN_DENORM_SQ.FROM_DATE between MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE AND

Line 265: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE = MTH_EQUIP_HIERARCHY_SQ.EFFECTIVE_DATE AND

261: MTH_EQUIP_HIERARCHY_SQ.HIERARCHY_ID = MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_HIERARCHY_KEY and
262: MTH_EQUIP_HIERARCHY_SQ.LEVEL_NUM = 10 and
263: MTH_EQUIP_HIERARCHY_SQ.LEVEL_FK_KEY = MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY And
264: MTH_EQUIPMENT_DENORM_D_SQ.LEVEL9_LEVEL_KEY = MTH_RESOURCE_COST_MV_SQ.RESOURCE_FK_KEY (+) And
265: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE = MTH_EQUIP_HIERARCHY_SQ.EFFECTIVE_DATE AND
266: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY = MTH_EQUIP_STATUS_SUMMARY_SQ.EQUIPMENT_FK_KEY AND
267: MTH_EQUIP_STATUS_SUMMARY_SQ.SHIFT_WORKDAY_FK_KEY = MTH_SHIFT_GREGORIAN_DENORM_SQ.SHIFT_WORKDAY_PK_KEY AND
268: MTH_SHIFT_GREGORIAN_DENORM_SQ.FROM_DATE between MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE AND
269: nvl( MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EXPIRATION_DATE,

Line 266: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY = MTH_EQUIP_STATUS_SUMMARY_SQ.EQUIPMENT_FK_KEY AND

262: MTH_EQUIP_HIERARCHY_SQ.LEVEL_NUM = 10 and
263: MTH_EQUIP_HIERARCHY_SQ.LEVEL_FK_KEY = MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY And
264: MTH_EQUIPMENT_DENORM_D_SQ.LEVEL9_LEVEL_KEY = MTH_RESOURCE_COST_MV_SQ.RESOURCE_FK_KEY (+) And
265: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE = MTH_EQUIP_HIERARCHY_SQ.EFFECTIVE_DATE AND
266: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY = MTH_EQUIP_STATUS_SUMMARY_SQ.EQUIPMENT_FK_KEY AND
267: MTH_EQUIP_STATUS_SUMMARY_SQ.SHIFT_WORKDAY_FK_KEY = MTH_SHIFT_GREGORIAN_DENORM_SQ.SHIFT_WORKDAY_PK_KEY AND
268: MTH_SHIFT_GREGORIAN_DENORM_SQ.FROM_DATE between MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE AND
269: nvl( MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EXPIRATION_DATE,
270: TO_DATE('4000-01-01', 'YYYY-MM-DD')))

Line 268: MTH_SHIFT_GREGORIAN_DENORM_SQ.FROM_DATE between MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE AND

264: MTH_EQUIPMENT_DENORM_D_SQ.LEVEL9_LEVEL_KEY = MTH_RESOURCE_COST_MV_SQ.RESOURCE_FK_KEY (+) And
265: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE = MTH_EQUIP_HIERARCHY_SQ.EFFECTIVE_DATE AND
266: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY = MTH_EQUIP_STATUS_SUMMARY_SQ.EQUIPMENT_FK_KEY AND
267: MTH_EQUIP_STATUS_SUMMARY_SQ.SHIFT_WORKDAY_FK_KEY = MTH_SHIFT_GREGORIAN_DENORM_SQ.SHIFT_WORKDAY_PK_KEY AND
268: MTH_SHIFT_GREGORIAN_DENORM_SQ.FROM_DATE between MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE AND
269: nvl( MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EXPIRATION_DATE,
270: TO_DATE('4000-01-01', 'YYYY-MM-DD')))
271: )
272: MERGE_EQUIP_STATUS_SQ

Line 269: nvl( MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EXPIRATION_DATE,

265: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE = MTH_EQUIP_HIERARCHY_SQ.EFFECTIVE_DATE AND
266: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY = MTH_EQUIP_STATUS_SUMMARY_SQ.EQUIPMENT_FK_KEY AND
267: MTH_EQUIP_STATUS_SUMMARY_SQ.SHIFT_WORKDAY_FK_KEY = MTH_SHIFT_GREGORIAN_DENORM_SQ.SHIFT_WORKDAY_PK_KEY AND
268: MTH_SHIFT_GREGORIAN_DENORM_SQ.FROM_DATE between MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE AND
269: nvl( MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EXPIRATION_DATE,
270: TO_DATE('4000-01-01', 'YYYY-MM-DD')))
271: )
272: MERGE_EQUIP_STATUS_SQ
273: ON

Line 293: mth_util_pkg.mth_run_log_post_load('MTH_EQUIPMENT_DENORM_D_MV',v_unassigned_val);

289:
290:
291:
292: ----Call mth_run_log_post_load
293: mth_util_pkg.mth_run_log_post_load('MTH_EQUIPMENT_DENORM_D_MV',v_unassigned_val);
294:
295: COMMIT;
296: mth_util_pkg.log_msg('MTH_POPULATE_EQUIP_HRCHY_MV end', mth_util_pkg.G_DBG_PROC_FUN_END);
297: EXCEPTION