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_EQUIP_HIERARCHY

Line 65: MTH_EQUIP_HIERARCHY.HIERARCHY_ID,

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,
68: MTH_EQUIP_HIERARCHY.PARENT_FK_KEY,
69: MTH_EQUIP_HIERARCHY.EFFECTIVE_DATE,

Line 66: MTH_EQUIP_HIERARCHY.LEVEL_NUM,

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,
68: MTH_EQUIP_HIERARCHY.PARENT_FK_KEY,
69: MTH_EQUIP_HIERARCHY.EFFECTIVE_DATE,
70: MTH_EQUIP_HIERARCHY.LAST_UPDATE_DATE

Line 67: MTH_EQUIP_HIERARCHY.LEVEL_FK_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,
68: MTH_EQUIP_HIERARCHY.PARENT_FK_KEY,
69: MTH_EQUIP_HIERARCHY.EFFECTIVE_DATE,
70: MTH_EQUIP_HIERARCHY.LAST_UPDATE_DATE
71: FROM MTH_EQUIP_HIERARCHY) MTH_EQUIP_HIERARCHY_SQ ,

Line 68: MTH_EQUIP_HIERARCHY.PARENT_FK_KEY,

64: (SELECT
65: MTH_EQUIP_HIERARCHY.HIERARCHY_ID,
66: MTH_EQUIP_HIERARCHY.LEVEL_NUM,
67: MTH_EQUIP_HIERARCHY.LEVEL_FK_KEY,
68: MTH_EQUIP_HIERARCHY.PARENT_FK_KEY,
69: MTH_EQUIP_HIERARCHY.EFFECTIVE_DATE,
70: MTH_EQUIP_HIERARCHY.LAST_UPDATE_DATE
71: FROM MTH_EQUIP_HIERARCHY) MTH_EQUIP_HIERARCHY_SQ ,
72: (SELECT

Line 69: MTH_EQUIP_HIERARCHY.EFFECTIVE_DATE,

65: MTH_EQUIP_HIERARCHY.HIERARCHY_ID,
66: MTH_EQUIP_HIERARCHY.LEVEL_NUM,
67: MTH_EQUIP_HIERARCHY.LEVEL_FK_KEY,
68: MTH_EQUIP_HIERARCHY.PARENT_FK_KEY,
69: MTH_EQUIP_HIERARCHY.EFFECTIVE_DATE,
70: MTH_EQUIP_HIERARCHY.LAST_UPDATE_DATE
71: FROM MTH_EQUIP_HIERARCHY) MTH_EQUIP_HIERARCHY_SQ ,
72: (SELECT
73: MTH_RESOURCE_COST_MV.RESOURCE_FK_KEY,

Line 70: MTH_EQUIP_HIERARCHY.LAST_UPDATE_DATE

66: MTH_EQUIP_HIERARCHY.LEVEL_NUM,
67: MTH_EQUIP_HIERARCHY.LEVEL_FK_KEY,
68: MTH_EQUIP_HIERARCHY.PARENT_FK_KEY,
69: MTH_EQUIP_HIERARCHY.EFFECTIVE_DATE,
70: MTH_EQUIP_HIERARCHY.LAST_UPDATE_DATE
71: FROM MTH_EQUIP_HIERARCHY) MTH_EQUIP_HIERARCHY_SQ ,
72: (SELECT
73: MTH_RESOURCE_COST_MV.RESOURCE_FK_KEY,
74: MTH_RESOURCE_COST_MV.COST

Line 71: FROM MTH_EQUIP_HIERARCHY) MTH_EQUIP_HIERARCHY_SQ ,

67: MTH_EQUIP_HIERARCHY.LEVEL_FK_KEY,
68: MTH_EQUIP_HIERARCHY.PARENT_FK_KEY,
69: MTH_EQUIP_HIERARCHY.EFFECTIVE_DATE,
70: MTH_EQUIP_HIERARCHY.LAST_UPDATE_DATE
71: FROM MTH_EQUIP_HIERARCHY) MTH_EQUIP_HIERARCHY_SQ ,
72: (SELECT
73: MTH_RESOURCE_COST_MV.RESOURCE_FK_KEY,
74: MTH_RESOURCE_COST_MV.COST
75: FROM MTH_RESOURCE_COST_MV ) MTH_RESOURCE_COST_MV_SQ,

Line 88: ( MTH_EQUIP_HIERARCHY_SQ.LAST_UPDATE_DATE > v_log_from_date AND

84: FROM MTH_EQUIPMENT_SHIFTS_D
85: WHERE ENTITY_TYPE = 'EQUIPMENT'
86: GROUP BY EQUIPMENT_FK_KEY,SHIFT_WORKDAY_FK_KEY ) MTH_EQUIPMENT_SHIFTS_D_SQ
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

Line 89: MTH_EQUIP_HIERARCHY_SQ.LAST_UPDATE_DATE <= v_log_to_date AND

85: WHERE ENTITY_TYPE = 'EQUIPMENT'
86: GROUP BY EQUIPMENT_FK_KEY,SHIFT_WORKDAY_FK_KEY ) MTH_EQUIPMENT_SHIFTS_D_SQ
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

Line 90: MTH_EQUIP_HIERARCHY_SQ.HIERARCHY_ID = -2 and

86: GROUP BY EQUIPMENT_FK_KEY,SHIFT_WORKDAY_FK_KEY ) MTH_EQUIPMENT_SHIFTS_D_SQ
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

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 92: MTH_EQUIP_HIERARCHY_SQ.LEVEL_NUM = 10 and

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
96: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY = MTH_EQUIPMENT_SHIFTS_D_SQ.EQUIPMENT_FK_KEY 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 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 151: MTH_EQUIP_HIERARCHY.HIERARCHY_ID,

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,
154: MTH_EQUIP_HIERARCHY.PARENT_FK_KEY,
155: MTH_EQUIP_HIERARCHY.EFFECTIVE_DATE,

Line 152: MTH_EQUIP_HIERARCHY.LEVEL_NUM,

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,
154: MTH_EQUIP_HIERARCHY.PARENT_FK_KEY,
155: MTH_EQUIP_HIERARCHY.EFFECTIVE_DATE,
156: MTH_EQUIP_HIERARCHY.LAST_UPDATE_DATE

Line 153: MTH_EQUIP_HIERARCHY.LEVEL_FK_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,
154: MTH_EQUIP_HIERARCHY.PARENT_FK_KEY,
155: MTH_EQUIP_HIERARCHY.EFFECTIVE_DATE,
156: MTH_EQUIP_HIERARCHY.LAST_UPDATE_DATE
157: FROM MTH_EQUIP_HIERARCHY) MTH_EQUIP_HIERARCHY_SQ ,

Line 154: MTH_EQUIP_HIERARCHY.PARENT_FK_KEY,

150: (SELECT
151: MTH_EQUIP_HIERARCHY.HIERARCHY_ID,
152: MTH_EQUIP_HIERARCHY.LEVEL_NUM,
153: MTH_EQUIP_HIERARCHY.LEVEL_FK_KEY,
154: MTH_EQUIP_HIERARCHY.PARENT_FK_KEY,
155: MTH_EQUIP_HIERARCHY.EFFECTIVE_DATE,
156: MTH_EQUIP_HIERARCHY.LAST_UPDATE_DATE
157: FROM MTH_EQUIP_HIERARCHY) MTH_EQUIP_HIERARCHY_SQ ,
158: (SELECT

Line 155: MTH_EQUIP_HIERARCHY.EFFECTIVE_DATE,

151: MTH_EQUIP_HIERARCHY.HIERARCHY_ID,
152: MTH_EQUIP_HIERARCHY.LEVEL_NUM,
153: MTH_EQUIP_HIERARCHY.LEVEL_FK_KEY,
154: MTH_EQUIP_HIERARCHY.PARENT_FK_KEY,
155: MTH_EQUIP_HIERARCHY.EFFECTIVE_DATE,
156: MTH_EQUIP_HIERARCHY.LAST_UPDATE_DATE
157: FROM MTH_EQUIP_HIERARCHY) MTH_EQUIP_HIERARCHY_SQ ,
158: (SELECT
159: MTH_RESOURCE_COST_MV.RESOURCE_FK_KEY,

Line 156: MTH_EQUIP_HIERARCHY.LAST_UPDATE_DATE

152: MTH_EQUIP_HIERARCHY.LEVEL_NUM,
153: MTH_EQUIP_HIERARCHY.LEVEL_FK_KEY,
154: MTH_EQUIP_HIERARCHY.PARENT_FK_KEY,
155: MTH_EQUIP_HIERARCHY.EFFECTIVE_DATE,
156: MTH_EQUIP_HIERARCHY.LAST_UPDATE_DATE
157: FROM MTH_EQUIP_HIERARCHY) MTH_EQUIP_HIERARCHY_SQ ,
158: (SELECT
159: MTH_RESOURCE_COST_MV.RESOURCE_FK_KEY,
160: MTH_RESOURCE_COST_MV.COST

Line 157: FROM MTH_EQUIP_HIERARCHY) MTH_EQUIP_HIERARCHY_SQ ,

153: MTH_EQUIP_HIERARCHY.LEVEL_FK_KEY,
154: MTH_EQUIP_HIERARCHY.PARENT_FK_KEY,
155: MTH_EQUIP_HIERARCHY.EFFECTIVE_DATE,
156: MTH_EQUIP_HIERARCHY.LAST_UPDATE_DATE
157: FROM MTH_EQUIP_HIERARCHY) MTH_EQUIP_HIERARCHY_SQ ,
158: (SELECT
159: MTH_RESOURCE_COST_MV.RESOURCE_FK_KEY,
160: MTH_RESOURCE_COST_MV.COST
161: FROM MTH_RESOURCE_COST_MV ) MTH_RESOURCE_COST_MV_SQ,

Line 173: ( MTH_EQUIP_HIERARCHY_SQ.LAST_UPDATE_DATE > v_log_from_date AND

169: MTH_EQUIP_OUTPUT_SUMMARY.SHIFT_WORKDAY_FK_KEY
170: FROM MTH_EQUIP_OUTPUT_SUMMARY
171: GROUP BY EQUIPMENT_FK_KEY,SHIFT_WORKDAY_FK_KEY) MTH_EQUIP_OUTPUT_SUMMARY_SQ
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

Line 174: MTH_EQUIP_HIERARCHY_SQ.LAST_UPDATE_DATE <= v_log_to_date AND

170: FROM MTH_EQUIP_OUTPUT_SUMMARY
171: GROUP BY EQUIPMENT_FK_KEY,SHIFT_WORKDAY_FK_KEY) MTH_EQUIP_OUTPUT_SUMMARY_SQ
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

Line 175: MTH_EQUIP_HIERARCHY_SQ.HIERARCHY_ID = -2 and

171: GROUP BY EQUIPMENT_FK_KEY,SHIFT_WORKDAY_FK_KEY) MTH_EQUIP_OUTPUT_SUMMARY_SQ
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

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 177: MTH_EQUIP_HIERARCHY_SQ.LEVEL_NUM = 10 and

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
181: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY = MTH_EQUIP_OUTPUT_SUMMARY_SQ.EQUIPMENT_FK_KEY 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 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 236: MTH_EQUIP_HIERARCHY.HIERARCHY_ID,

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,
239: MTH_EQUIP_HIERARCHY.PARENT_FK_KEY,
240: MTH_EQUIP_HIERARCHY.EFFECTIVE_DATE,

Line 237: MTH_EQUIP_HIERARCHY.LEVEL_NUM,

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,
239: MTH_EQUIP_HIERARCHY.PARENT_FK_KEY,
240: MTH_EQUIP_HIERARCHY.EFFECTIVE_DATE,
241: MTH_EQUIP_HIERARCHY.LAST_UPDATE_DATE

Line 238: MTH_EQUIP_HIERARCHY.LEVEL_FK_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,
239: MTH_EQUIP_HIERARCHY.PARENT_FK_KEY,
240: MTH_EQUIP_HIERARCHY.EFFECTIVE_DATE,
241: MTH_EQUIP_HIERARCHY.LAST_UPDATE_DATE
242: FROM MTH_EQUIP_HIERARCHY) MTH_EQUIP_HIERARCHY_SQ ,

Line 239: MTH_EQUIP_HIERARCHY.PARENT_FK_KEY,

235: (SELECT
236: MTH_EQUIP_HIERARCHY.HIERARCHY_ID,
237: MTH_EQUIP_HIERARCHY.LEVEL_NUM,
238: MTH_EQUIP_HIERARCHY.LEVEL_FK_KEY,
239: MTH_EQUIP_HIERARCHY.PARENT_FK_KEY,
240: MTH_EQUIP_HIERARCHY.EFFECTIVE_DATE,
241: MTH_EQUIP_HIERARCHY.LAST_UPDATE_DATE
242: FROM MTH_EQUIP_HIERARCHY) MTH_EQUIP_HIERARCHY_SQ ,
243: (SELECT

Line 240: MTH_EQUIP_HIERARCHY.EFFECTIVE_DATE,

236: MTH_EQUIP_HIERARCHY.HIERARCHY_ID,
237: MTH_EQUIP_HIERARCHY.LEVEL_NUM,
238: MTH_EQUIP_HIERARCHY.LEVEL_FK_KEY,
239: MTH_EQUIP_HIERARCHY.PARENT_FK_KEY,
240: MTH_EQUIP_HIERARCHY.EFFECTIVE_DATE,
241: MTH_EQUIP_HIERARCHY.LAST_UPDATE_DATE
242: FROM MTH_EQUIP_HIERARCHY) MTH_EQUIP_HIERARCHY_SQ ,
243: (SELECT
244: MTH_RESOURCE_COST_MV.RESOURCE_FK_KEY,

Line 241: MTH_EQUIP_HIERARCHY.LAST_UPDATE_DATE

237: MTH_EQUIP_HIERARCHY.LEVEL_NUM,
238: MTH_EQUIP_HIERARCHY.LEVEL_FK_KEY,
239: MTH_EQUIP_HIERARCHY.PARENT_FK_KEY,
240: MTH_EQUIP_HIERARCHY.EFFECTIVE_DATE,
241: MTH_EQUIP_HIERARCHY.LAST_UPDATE_DATE
242: FROM MTH_EQUIP_HIERARCHY) MTH_EQUIP_HIERARCHY_SQ ,
243: (SELECT
244: MTH_RESOURCE_COST_MV.RESOURCE_FK_KEY,
245: MTH_RESOURCE_COST_MV.COST

Line 242: FROM MTH_EQUIP_HIERARCHY) MTH_EQUIP_HIERARCHY_SQ ,

238: MTH_EQUIP_HIERARCHY.LEVEL_FK_KEY,
239: MTH_EQUIP_HIERARCHY.PARENT_FK_KEY,
240: MTH_EQUIP_HIERARCHY.EFFECTIVE_DATE,
241: MTH_EQUIP_HIERARCHY.LAST_UPDATE_DATE
242: FROM MTH_EQUIP_HIERARCHY) MTH_EQUIP_HIERARCHY_SQ ,
243: (SELECT
244: MTH_RESOURCE_COST_MV.RESOURCE_FK_KEY,
245: MTH_RESOURCE_COST_MV.COST
246: FROM MTH_RESOURCE_COST_MV ) MTH_RESOURCE_COST_MV_SQ,

Line 258: ( MTH_EQUIP_HIERARCHY_SQ.LAST_UPDATE_DATE > v_log_from_date AND

254: MTH_EQUIP_STATUS_SUMMARY.SHIFT_WORKDAY_FK_KEY
255: FROM MTH_EQUIP_STATUS_SUMMARY
256: GROUP BY EQUIPMENT_FK_KEY,SHIFT_WORKDAY_FK_KEY) MTH_EQUIP_STATUS_SUMMARY_SQ
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

Line 259: MTH_EQUIP_HIERARCHY_SQ.LAST_UPDATE_DATE <= v_log_to_date AND

255: FROM MTH_EQUIP_STATUS_SUMMARY
256: GROUP BY EQUIPMENT_FK_KEY,SHIFT_WORKDAY_FK_KEY) MTH_EQUIP_STATUS_SUMMARY_SQ
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

Line 260: MTH_EQUIP_HIERARCHY_SQ.HIERARCHY_ID = -2 and

256: GROUP BY EQUIPMENT_FK_KEY,SHIFT_WORKDAY_FK_KEY) MTH_EQUIP_STATUS_SUMMARY_SQ
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

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 262: MTH_EQUIP_HIERARCHY_SQ.LEVEL_NUM = 10 and

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
266: MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY = MTH_EQUIP_STATUS_SUMMARY_SQ.EQUIPMENT_FK_KEY 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 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,