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_OUTPUT_SUMMARY

Line 123: MTH_EQUIP_OUTPUT_SUMMARY

119: -- Update the Resource cost and other columns on the output summary table
120:
121: MERGE
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",

Line 127: MTH_EQUIP_OUTPUT_SUMMARY_SQ.SHIFT_WORKDAY_FK_KEY "SHIFT_WORKDAY_FK_KEY",

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

Line 168: MTH_EQUIP_OUTPUT_SUMMARY.EQUIPMENT_FK_KEY,

164: MTH_SHIFT_GREGORIAN_DENORM_MV.SHIFT_DATE,
165: MTH_SHIFT_GREGORIAN_DENORM_MV.FROM_DATE
166: FROM MTH_SHIFT_GREGORIAN_DENORM_MV) MTH_SHIFT_GREGORIAN_DENORM_SQ ,
167: (SELECT
168: MTH_EQUIP_OUTPUT_SUMMARY.EQUIPMENT_FK_KEY,
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

Line 169: MTH_EQUIP_OUTPUT_SUMMARY.SHIFT_WORKDAY_FK_KEY

165: MTH_SHIFT_GREGORIAN_DENORM_MV.FROM_DATE
166: FROM MTH_SHIFT_GREGORIAN_DENORM_MV) MTH_SHIFT_GREGORIAN_DENORM_SQ ,
167: (SELECT
168: MTH_EQUIP_OUTPUT_SUMMARY.EQUIPMENT_FK_KEY,
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

Line 170: FROM MTH_EQUIP_OUTPUT_SUMMARY

166: FROM MTH_SHIFT_GREGORIAN_DENORM_MV) MTH_SHIFT_GREGORIAN_DENORM_SQ ,
167: (SELECT
168: MTH_EQUIP_OUTPUT_SUMMARY.EQUIPMENT_FK_KEY,
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

Line 171: GROUP BY EQUIPMENT_FK_KEY,SHIFT_WORKDAY_FK_KEY) MTH_EQUIP_OUTPUT_SUMMARY_SQ

167: (SELECT
168: MTH_EQUIP_OUTPUT_SUMMARY.EQUIPMENT_FK_KEY,
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

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 182: MTH_EQUIP_OUTPUT_SUMMARY_SQ.SHIFT_WORKDAY_FK_KEY = MTH_SHIFT_GREGORIAN_DENORM_SQ.SHIFT_WORKDAY_PK_KEY 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')))
186: )

Line 189: ( MTH_EQUIP_OUTPUT_SUMMARY.EQUIPMENT_FK_KEY = MERGE_EQUIP_OUTPUT_SQ.EQUIPMENT_FK_KEY AND

185: TO_DATE('4000-01-01', 'YYYY-MM-DD')))
186: )
187: MERGE_EQUIP_OUTPUT_SQ
188: ON
189: ( MTH_EQUIP_OUTPUT_SUMMARY.EQUIPMENT_FK_KEY = MERGE_EQUIP_OUTPUT_SQ.EQUIPMENT_FK_KEY AND
190: MTH_EQUIP_OUTPUT_SUMMARY.SHIFT_WORKDAY_FK_KEY = MERGE_EQUIP_OUTPUT_SQ.SHIFT_WORKDAY_FK_KEY)
191: WHEN MATCHED THEN
192: UPDATE
193: SET

Line 190: MTH_EQUIP_OUTPUT_SUMMARY.SHIFT_WORKDAY_FK_KEY = MERGE_EQUIP_OUTPUT_SQ.SHIFT_WORKDAY_FK_KEY)

186: )
187: MERGE_EQUIP_OUTPUT_SQ
188: ON
189: ( MTH_EQUIP_OUTPUT_SUMMARY.EQUIPMENT_FK_KEY = MERGE_EQUIP_OUTPUT_SQ.EQUIPMENT_FK_KEY AND
190: MTH_EQUIP_OUTPUT_SUMMARY.SHIFT_WORKDAY_FK_KEY = MERGE_EQUIP_OUTPUT_SQ.SHIFT_WORKDAY_FK_KEY)
191: WHEN MATCHED THEN
192: UPDATE
193: SET
194: LAST_UPDATE_DATE = MERGE_EQUIP_OUTPUT_SQ.LAST_UPDATE_DATE,

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

198: RESOURCE_FK_KEY = MERGE_EQUIP_OUTPUT_SQ.RESOURCE_FK_KEY,
199: RESOURCE_COST = MERGE_EQUIP_OUTPUT_SQ.COST ;
200:
201:
202: mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIP_OUTPUT_SUMMARY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
203:
204: -- Update the Resource cost and other columns on the status summary table
205:
206: MERGE

Line 704: MTH_EQUIP_OUTPUT_SUMMARY MEOS

700: -- Update the standard rates and other columns on the output summary table
701:
702: MERGE
703: INTO
704: MTH_EQUIP_OUTPUT_SUMMARY MEOS
705: USING
706: (SELECT
707: MESRF.EQUIPMENT_FK_KEY "EQUIPMENT_FK_KEY",
708: MESRF.ITEM_FK_KEY "ITEM_FK_KEY",

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

733: SET
734: MEOS.LAST_UPDATE_DATE = MERGE_EQUIP_OUTPUT_SQ.LAST_UPDATE_DATE,
735: MEOS.STANDARD_RATE_1= MERGE_EQUIP_OUTPUT_SQ.STANDARD_RATE_1;
736:
737: mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIP_OUTPUT_SUMMARY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
738:
739: ----Call mth_run_log_post_load
740: mth_util_pkg.mth_run_log_post_load('MTH_EQUIP_STD_RATES_MV',v_unassigned_val);
741:

Line 831: MTH_EQUIP_OUTPUT_SUMMARY "OUTPUT_SUMMARY"

827: -- Update the item cost and other columns on the output summary table
828:
829: MERGE
830: INTO
831: MTH_EQUIP_OUTPUT_SUMMARY "OUTPUT_SUMMARY"
832: USING
833: (SELECT
834: ITEM_COST_SQ.ITEM_FK_KEY "ITEM_FK_KEY",
835: v_log_to_date "LAST_UPDATE_DATE",

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

863: SET
864: OUTPUT_SUMMARY.LAST_UPDATE_DATE = MERGE_EQUIP_OUTPUT_SUM_SQ.LAST_UPDATE_DATE,
865: OUTPUT_SUMMARY.ITEM_COST = MERGE_EQUIP_OUTPUT_SUM_SQ.COST ;
866:
867: mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIP_OUTPUT_SUMMARY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
868:
869: -- Update the item cost and other columns on the Production Consumed table
870:
871: MERGE

Line 1104: MTH_EQUIP_OUTPUT_SUMMARY

1100: -- Update the Resource cost and other columns on the output summary table
1101:
1102: MERGE
1103: INTO
1104: MTH_EQUIP_OUTPUT_SUMMARY
1105: USING
1106: (SELECT
1107: v_log_to_date "LAST_UPDATE_DATE",
1108: v_unassigned_val "LAST_UPDATE_SYSTEM_ID",

Line 1135: MTH_EQUIP_OUTPUT_SUMMARY.RESOURCE_FK_KEY = MERGE_EQUIP_OUTPUT_SUM_SQ.RESOURCE_FK_KEY

1131: ( RESOURCE_COST_SQ.LAST_UPDATE_DATE > v_log_from_date AND RESOURCE_COST_SQ.LAST_UPDATE_DATE <= v_log_to_date)
1132: )
1133: MERGE_EQUIP_OUTPUT_SUM_SQ
1134: ON (
1135: MTH_EQUIP_OUTPUT_SUMMARY.RESOURCE_FK_KEY = MERGE_EQUIP_OUTPUT_SUM_SQ.RESOURCE_FK_KEY
1136: )
1137: WHEN MATCHED THEN
1138: UPDATE
1139: SET

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

1142: LAST_UPDATED_BY = MERGE_EQUIP_OUTPUT_SUM_SQ.LAST_UPDATED_BY,
1143: LAST_UPDATE_LOGIN = MERGE_EQUIP_OUTPUT_SUM_SQ.LAST_UPDATE_LOGIN,
1144: RESOURCE_COST = MERGE_EQUIP_OUTPUT_SUM_SQ.RESOURCE_COST ;
1145:
1146: mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIP_OUTPUT_SUMMARY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
1147:
1148: -- Update the Resource cost and other columns on the resource transactions table
1149:
1150: MERGE