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_STATUS_SUMMARY

Line 208: MTH_EQUIP_STATUS_SUMMARY

204: -- Update the Resource cost and other columns on the status summary table
205:
206: MERGE
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",

Line 212: MTH_EQUIP_STATUS_SUMMARY_SQ.SHIFT_WORKDAY_FK_KEY "SHIFT_WORKDAY_FK_KEY",

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",
216: v_unassigned_val "LAST_UPDATE_LOGIN",

Line 253: MTH_EQUIP_STATUS_SUMMARY.EQUIPMENT_FK_KEY,

249: MTH_SHIFT_GREGORIAN_DENORM_MV.SHIFT_DATE,
250: MTH_SHIFT_GREGORIAN_DENORM_MV.FROM_DATE
251: FROM MTH_SHIFT_GREGORIAN_DENORM_MV) MTH_SHIFT_GREGORIAN_DENORM_SQ ,
252: (SELECT
253: MTH_EQUIP_STATUS_SUMMARY.EQUIPMENT_FK_KEY,
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

Line 254: MTH_EQUIP_STATUS_SUMMARY.SHIFT_WORKDAY_FK_KEY

250: MTH_SHIFT_GREGORIAN_DENORM_MV.FROM_DATE
251: FROM MTH_SHIFT_GREGORIAN_DENORM_MV) MTH_SHIFT_GREGORIAN_DENORM_SQ ,
252: (SELECT
253: MTH_EQUIP_STATUS_SUMMARY.EQUIPMENT_FK_KEY,
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

Line 255: FROM MTH_EQUIP_STATUS_SUMMARY

251: FROM MTH_SHIFT_GREGORIAN_DENORM_MV) MTH_SHIFT_GREGORIAN_DENORM_SQ ,
252: (SELECT
253: MTH_EQUIP_STATUS_SUMMARY.EQUIPMENT_FK_KEY,
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

Line 256: GROUP BY EQUIPMENT_FK_KEY,SHIFT_WORKDAY_FK_KEY) MTH_EQUIP_STATUS_SUMMARY_SQ

252: (SELECT
253: MTH_EQUIP_STATUS_SUMMARY.EQUIPMENT_FK_KEY,
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

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 267: MTH_EQUIP_STATUS_SUMMARY_SQ.SHIFT_WORKDAY_FK_KEY = MTH_SHIFT_GREGORIAN_DENORM_SQ.SHIFT_WORKDAY_PK_KEY 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')))
271: )

Line 274: ( MTH_EQUIP_STATUS_SUMMARY.EQUIPMENT_FK_KEY = MERGE_EQUIP_STATUS_SQ.EQUIPMENT_FK_KEY AND

270: TO_DATE('4000-01-01', 'YYYY-MM-DD')))
271: )
272: MERGE_EQUIP_STATUS_SQ
273: ON
274: ( MTH_EQUIP_STATUS_SUMMARY.EQUIPMENT_FK_KEY = MERGE_EQUIP_STATUS_SQ.EQUIPMENT_FK_KEY AND
275: MTH_EQUIP_STATUS_SUMMARY.SHIFT_WORKDAY_FK_KEY = MERGE_EQUIP_STATUS_SQ.SHIFT_WORKDAY_FK_KEY)
276: WHEN MATCHED THEN
277: UPDATE
278: SET

Line 275: MTH_EQUIP_STATUS_SUMMARY.SHIFT_WORKDAY_FK_KEY = MERGE_EQUIP_STATUS_SQ.SHIFT_WORKDAY_FK_KEY)

271: )
272: MERGE_EQUIP_STATUS_SQ
273: ON
274: ( MTH_EQUIP_STATUS_SUMMARY.EQUIPMENT_FK_KEY = MERGE_EQUIP_STATUS_SQ.EQUIPMENT_FK_KEY AND
275: MTH_EQUIP_STATUS_SUMMARY.SHIFT_WORKDAY_FK_KEY = MERGE_EQUIP_STATUS_SQ.SHIFT_WORKDAY_FK_KEY)
276: WHEN MATCHED THEN
277: UPDATE
278: SET
279: LAST_UPDATE_DATE = MERGE_EQUIP_STATUS_SQ.LAST_UPDATE_DATE,

Line 287: mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIP_STATUS_SUMMARY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

283: RESOURCE_FK_KEY = MERGE_EQUIP_STATUS_SQ.RESOURCE_FK_KEY,
284: RESOURCE_COST = MERGE_EQUIP_STATUS_SQ.COST ;
285:
286:
287: mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIP_STATUS_SUMMARY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
288:
289:
290:
291:

Line 1056: MTH_EQUIP_STATUS_SUMMARY

1052: -- Update the Resource cost and other columns on the status summary table
1053:
1054: MERGE
1055: INTO
1056: MTH_EQUIP_STATUS_SUMMARY
1057: USING
1058: (SELECT
1059: v_log_to_date "LAST_UPDATE_DATE",
1060: v_unassigned_val "LAST_UPDATE_SYSTEM_ID",

Line 1087: MTH_EQUIP_STATUS_SUMMARY.RESOURCE_FK_KEY = MERGE_EQUIP_STATUS_SUM_SQ.RESOURCE_FK_KEY

1083: ( RESOURCE_COST_SQ.LAST_UPDATE_DATE > v_log_from_date AND RESOURCE_COST_SQ.LAST_UPDATE_DATE <= v_log_to_date)
1084: )
1085: MERGE_EQUIP_STATUS_SUM_SQ
1086: ON (
1087: MTH_EQUIP_STATUS_SUMMARY.RESOURCE_FK_KEY = MERGE_EQUIP_STATUS_SUM_SQ.RESOURCE_FK_KEY
1088: )
1089: WHEN MATCHED THEN
1090: UPDATE
1091: SET

Line 1098: mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIP_STATUS_SUMMARY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

1094: LAST_UPDATED_BY = MERGE_EQUIP_STATUS_SUM_SQ.LAST_UPDATED_BY,
1095: LAST_UPDATE_LOGIN = MERGE_EQUIP_STATUS_SUM_SQ.LAST_UPDATE_LOGIN,
1096: RESOURCE_COST = MERGE_EQUIP_STATUS_SUM_SQ.RESOURCE_COST ;
1097:
1098: mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIP_STATUS_SUMMARY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
1099:
1100: -- Update the Resource cost and other columns on the output summary table
1101:
1102: MERGE