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_SHIFTS_D

Line 37: MTH_EQUIPMENT_SHIFTS_D

33: -- Update the Resource cost and other columns on the equipment shifts table
34:
35: MERGE
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",

Line 41: MTH_EQUIPMENT_SHIFTS_D_SQ.SHIFT_WORKDAY_FK_KEY "SHIFT_WORKDAY_FK_KEY",

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

Line 82: MTH_EQUIPMENT_SHIFTS_D.EQUIPMENT_FK_KEY,

78: MTH_SHIFT_GREGORIAN_DENORM_MV.SHIFT_DATE,
79: MTH_SHIFT_GREGORIAN_DENORM_MV.FROM_DATE
80: FROM MTH_SHIFT_GREGORIAN_DENORM_MV) MTH_SHIFT_GREGORIAN_DENORM_SQ ,
81: (SELECT
82: MTH_EQUIPMENT_SHIFTS_D.EQUIPMENT_FK_KEY,
83: MTH_EQUIPMENT_SHIFTS_D.SHIFT_WORKDAY_FK_KEY
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

Line 83: MTH_EQUIPMENT_SHIFTS_D.SHIFT_WORKDAY_FK_KEY

79: MTH_SHIFT_GREGORIAN_DENORM_MV.FROM_DATE
80: FROM MTH_SHIFT_GREGORIAN_DENORM_MV) MTH_SHIFT_GREGORIAN_DENORM_SQ ,
81: (SELECT
82: MTH_EQUIPMENT_SHIFTS_D.EQUIPMENT_FK_KEY,
83: MTH_EQUIPMENT_SHIFTS_D.SHIFT_WORKDAY_FK_KEY
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

Line 84: FROM MTH_EQUIPMENT_SHIFTS_D

80: FROM MTH_SHIFT_GREGORIAN_DENORM_MV) MTH_SHIFT_GREGORIAN_DENORM_SQ ,
81: (SELECT
82: MTH_EQUIPMENT_SHIFTS_D.EQUIPMENT_FK_KEY,
83: MTH_EQUIPMENT_SHIFTS_D.SHIFT_WORKDAY_FK_KEY
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

Line 86: GROUP BY EQUIPMENT_FK_KEY,SHIFT_WORKDAY_FK_KEY ) MTH_EQUIPMENT_SHIFTS_D_SQ

82: MTH_EQUIPMENT_SHIFTS_D.EQUIPMENT_FK_KEY,
83: MTH_EQUIPMENT_SHIFTS_D.SHIFT_WORKDAY_FK_KEY
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

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 97: MTH_EQUIPMENT_SHIFTS_D_SQ.SHIFT_WORKDAY_FK_KEY = MTH_SHIFT_GREGORIAN_DENORM_SQ.SHIFT_WORKDAY_PK_KEY 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')))
101: )

Line 104: ( MTH_EQUIPMENT_SHIFTS_D.EQUIPMENT_FK_KEY = MERGE_EQUIP_SHIFTS_SQ.EQUIPMENT_FK_KEY AND

100: TO_DATE('4000-01-01', 'YYYY-MM-DD')))
101: )
102: MERGE_EQUIP_SHIFTS_SQ
103: ON
104: ( MTH_EQUIPMENT_SHIFTS_D.EQUIPMENT_FK_KEY = MERGE_EQUIP_SHIFTS_SQ.EQUIPMENT_FK_KEY AND
105: MTH_EQUIPMENT_SHIFTS_D.SHIFT_WORKDAY_FK_KEY = MERGE_EQUIP_SHIFTS_SQ.SHIFT_WORKDAY_FK_KEY)
106:
107: WHEN MATCHED THEN
108: UPDATE

Line 105: MTH_EQUIPMENT_SHIFTS_D.SHIFT_WORKDAY_FK_KEY = MERGE_EQUIP_SHIFTS_SQ.SHIFT_WORKDAY_FK_KEY)

101: )
102: MERGE_EQUIP_SHIFTS_SQ
103: ON
104: ( MTH_EQUIPMENT_SHIFTS_D.EQUIPMENT_FK_KEY = MERGE_EQUIP_SHIFTS_SQ.EQUIPMENT_FK_KEY AND
105: MTH_EQUIPMENT_SHIFTS_D.SHIFT_WORKDAY_FK_KEY = MERGE_EQUIP_SHIFTS_SQ.SHIFT_WORKDAY_FK_KEY)
106:
107: WHEN MATCHED THEN
108: UPDATE
109: SET

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

113: LAST_UPDATE_LOGIN = MERGE_EQUIP_SHIFTS_SQ.LAST_UPDATE_LOGIN,
114: RESOURCE_FK_KEY = MERGE_EQUIP_SHIFTS_SQ.RESOURCE_FK_KEY,
115: RESOURCE_COST = MERGE_EQUIP_SHIFTS_SQ.COST ;
116:
117: mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIPMENT_SHIFTS_D - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
118:
119: -- Update the Resource cost and other columns on the output summary table
120:
121: MERGE

Line 960: MTH_EQUIPMENT_SHIFTS_D

956: -- Update the Resource cost and other columns on the equipment shifts table
957:
958: MERGE
959: INTO
960: MTH_EQUIPMENT_SHIFTS_D
961: USING
962: (SELECT
963: v_log_to_date "LAST_UPDATE_DATE",
964: v_unassigned_val "LAST_UPDATE_SYSTEM_ID",

Line 991: MTH_EQUIPMENT_SHIFTS_D.RESOURCE_FK_KEY = MERGE_EQUIP_SHIFTS_SQ.RESOURCE_FK_KEY

987: ( RESOURCE_COST_SQ.LAST_UPDATE_DATE > v_log_from_date AND RESOURCE_COST_SQ.LAST_UPDATE_DATE <= v_log_to_date)
988: )
989: MERGE_EQUIP_SHIFTS_SQ
990: ON (
991: MTH_EQUIPMENT_SHIFTS_D.RESOURCE_FK_KEY = MERGE_EQUIP_SHIFTS_SQ.RESOURCE_FK_KEY
992: )
993: WHEN MATCHED THEN
994: UPDATE
995: SET

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

998: LAST_UPDATED_BY = MERGE_EQUIP_SHIFTS_SQ.LAST_UPDATED_BY,
999: LAST_UPDATE_LOGIN = MERGE_EQUIP_SHIFTS_SQ.LAST_UPDATE_LOGIN,
1000: RESOURCE_COST = MERGE_EQUIP_SHIFTS_SQ.RESOURCE_COST ;
1001:
1002: mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIPMENT_SHIFTS_D - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
1003:
1004: -- Update the Resource cost and other columns on the resource requirements table
1005:
1006: MERGE