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_RESOURCE_COST

Line 46: MTH_RESOURCE_COST_MV_SQ.RESOURCE_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",
46: MTH_RESOURCE_COST_MV_SQ.RESOURCE_FK_KEY,
47: MTH_RESOURCE_COST_MV_SQ.COST
48: FROM
49: /*(SELECT
50: DISTINCT

Line 47: MTH_RESOURCE_COST_MV_SQ.COST

43: v_unassigned_val "LAST_UPDATE_SYSTEM_ID",
44: v_unassigned_val "LAST_UPDATED_BY",
45: v_unassigned_val "LAST_UPDATE_LOGIN",
46: MTH_RESOURCE_COST_MV_SQ.RESOURCE_FK_KEY,
47: MTH_RESOURCE_COST_MV_SQ.COST
48: FROM
49: /*(SELECT
50: DISTINCT
51: MTH_RUN_LOG.FROM_DATE,

Line 73: MTH_RESOURCE_COST_MV.RESOURCE_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,
76: (SELECT
77: MTH_SHIFT_GREGORIAN_DENORM_MV.SHIFT_WORKDAY_PK_KEY,

Line 74: MTH_RESOURCE_COST_MV.COST

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,
76: (SELECT
77: MTH_SHIFT_GREGORIAN_DENORM_MV.SHIFT_WORKDAY_PK_KEY,
78: MTH_SHIFT_GREGORIAN_DENORM_MV.SHIFT_DATE,

Line 75: FROM MTH_RESOURCE_COST_MV ) MTH_RESOURCE_COST_MV_SQ,

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,
76: (SELECT
77: MTH_SHIFT_GREGORIAN_DENORM_MV.SHIFT_WORKDAY_PK_KEY,
78: MTH_SHIFT_GREGORIAN_DENORM_MV.SHIFT_DATE,
79: MTH_SHIFT_GREGORIAN_DENORM_MV.FROM_DATE

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 132: MTH_RESOURCE_COST_MV_SQ.RESOURCE_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",
132: MTH_RESOURCE_COST_MV_SQ.RESOURCE_FK_KEY,
133: MTH_RESOURCE_COST_MV_SQ.COST
134: FROM
135: /*(SELECT
136: DISTINCT

Line 133: MTH_RESOURCE_COST_MV_SQ.COST

129: v_unassigned_val "LAST_UPDATE_SYSTEM_ID",
130: v_unassigned_val "LAST_UPDATED_BY",
131: v_unassigned_val "LAST_UPDATE_LOGIN",
132: MTH_RESOURCE_COST_MV_SQ.RESOURCE_FK_KEY,
133: MTH_RESOURCE_COST_MV_SQ.COST
134: FROM
135: /*(SELECT
136: DISTINCT
137: MTH_RUN_LOG.FROM_DATE,

Line 159: MTH_RESOURCE_COST_MV.RESOURCE_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,
162: (SELECT
163: MTH_SHIFT_GREGORIAN_DENORM_MV.SHIFT_WORKDAY_PK_KEY,

Line 160: MTH_RESOURCE_COST_MV.COST

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,
162: (SELECT
163: MTH_SHIFT_GREGORIAN_DENORM_MV.SHIFT_WORKDAY_PK_KEY,
164: MTH_SHIFT_GREGORIAN_DENORM_MV.SHIFT_DATE,

Line 161: FROM MTH_RESOURCE_COST_MV ) MTH_RESOURCE_COST_MV_SQ,

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,
162: (SELECT
163: MTH_SHIFT_GREGORIAN_DENORM_MV.SHIFT_WORKDAY_PK_KEY,
164: MTH_SHIFT_GREGORIAN_DENORM_MV.SHIFT_DATE,
165: MTH_SHIFT_GREGORIAN_DENORM_MV.FROM_DATE

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 217: MTH_RESOURCE_COST_MV_SQ.RESOURCE_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",
217: MTH_RESOURCE_COST_MV_SQ.RESOURCE_FK_KEY,
218: MTH_RESOURCE_COST_MV_SQ.COST
219: FROM
220: /*(SELECT
221: DISTINCT

Line 218: MTH_RESOURCE_COST_MV_SQ.COST

214: v_unassigned_val "LAST_UPDATE_SYSTEM_ID",
215: v_unassigned_val "LAST_UPDATED_BY",
216: v_unassigned_val "LAST_UPDATE_LOGIN",
217: MTH_RESOURCE_COST_MV_SQ.RESOURCE_FK_KEY,
218: MTH_RESOURCE_COST_MV_SQ.COST
219: FROM
220: /*(SELECT
221: DISTINCT
222: MTH_RUN_LOG.FROM_DATE,

Line 244: MTH_RESOURCE_COST_MV.RESOURCE_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,
247: (SELECT
248: MTH_SHIFT_GREGORIAN_DENORM_MV.SHIFT_WORKDAY_PK_KEY,

Line 245: MTH_RESOURCE_COST_MV.COST

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,
247: (SELECT
248: MTH_SHIFT_GREGORIAN_DENORM_MV.SHIFT_WORKDAY_PK_KEY,
249: MTH_SHIFT_GREGORIAN_DENORM_MV.SHIFT_DATE,

Line 246: FROM MTH_RESOURCE_COST_MV ) MTH_RESOURCE_COST_MV_SQ,

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,
247: (SELECT
248: MTH_SHIFT_GREGORIAN_DENORM_MV.SHIFT_WORKDAY_PK_KEY,
249: MTH_SHIFT_GREGORIAN_DENORM_MV.SHIFT_DATE,
250: MTH_SHIFT_GREGORIAN_DENORM_MV.FROM_DATE

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 950: --mth_util_pkg.mth_run_log_pre_load('MTH_RESOURCE_COST_MV',v_unassigned_val,'INITIAL',NULL,0,v_log_date);

946: v_log_to_date := sysdate;
947: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
948:
949: -- Call mth_run_log_pre_load
950: --mth_util_pkg.mth_run_log_pre_load('MTH_RESOURCE_COST_MV',v_unassigned_val,'INITIAL',NULL,0,v_log_date);
951: mth_util_pkg.mth_run_log_pre_load('MTH_RESOURCE_COST_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date); -- changed mode (sasuren)
952: mth_util_pkg.GET_RUN_LOG_DATES('MTH_RESOURCE_COST_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
953: 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);
954: 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);

Line 951: mth_util_pkg.mth_run_log_pre_load('MTH_RESOURCE_COST_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date); -- changed mode (sasuren)

947: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
948:
949: -- Call mth_run_log_pre_load
950: --mth_util_pkg.mth_run_log_pre_load('MTH_RESOURCE_COST_MV',v_unassigned_val,'INITIAL',NULL,0,v_log_date);
951: mth_util_pkg.mth_run_log_pre_load('MTH_RESOURCE_COST_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date); -- changed mode (sasuren)
952: mth_util_pkg.GET_RUN_LOG_DATES('MTH_RESOURCE_COST_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
953: 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);
954: 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);
955:

Line 952: mth_util_pkg.GET_RUN_LOG_DATES('MTH_RESOURCE_COST_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);

948:
949: -- Call mth_run_log_pre_load
950: --mth_util_pkg.mth_run_log_pre_load('MTH_RESOURCE_COST_MV',v_unassigned_val,'INITIAL',NULL,0,v_log_date);
951: mth_util_pkg.mth_run_log_pre_load('MTH_RESOURCE_COST_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date); -- changed mode (sasuren)
952: mth_util_pkg.GET_RUN_LOG_DATES('MTH_RESOURCE_COST_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
953: 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);
954: 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);
955:
956: -- Update the Resource cost and other columns on the equipment shifts table

Line 977: (MTH_RUN_LOG.FACT_TABLE = 'MTH_RESOURCE_COST_MV' )) MTH_RUN_LOG_SQ , */

973: MTH_RUN_LOG.TO_DATE
974: FROM
975: MTH_RUN_LOG
976: WHERE
977: (MTH_RUN_LOG.FACT_TABLE = 'MTH_RESOURCE_COST_MV' )) MTH_RUN_LOG_SQ , */
978: (SELECT
979: SUM( CASE MTH_RESOURCE_COST.ISCURRENT WHEN 1 THEN MTH_RESOURCE_COST.COST ELSE NULL END) "RESOURCE_COST",
980: MAX(MTH_RESOURCE_COST.LAST_UPDATE_DATE) "LAST_UPDATE_DATE",
981: MTH_RESOURCE_COST.RESOURCE_FK_KEY "RESOURCE_FK_KEY"

Line 979: SUM( CASE MTH_RESOURCE_COST.ISCURRENT WHEN 1 THEN MTH_RESOURCE_COST.COST ELSE NULL END) "RESOURCE_COST",

975: MTH_RUN_LOG
976: WHERE
977: (MTH_RUN_LOG.FACT_TABLE = 'MTH_RESOURCE_COST_MV' )) MTH_RUN_LOG_SQ , */
978: (SELECT
979: SUM( CASE MTH_RESOURCE_COST.ISCURRENT WHEN 1 THEN MTH_RESOURCE_COST.COST ELSE NULL END) "RESOURCE_COST",
980: MAX(MTH_RESOURCE_COST.LAST_UPDATE_DATE) "LAST_UPDATE_DATE",
981: MTH_RESOURCE_COST.RESOURCE_FK_KEY "RESOURCE_FK_KEY"
982: FROM
983: MTH_RESOURCE_COST

Line 980: MAX(MTH_RESOURCE_COST.LAST_UPDATE_DATE) "LAST_UPDATE_DATE",

976: WHERE
977: (MTH_RUN_LOG.FACT_TABLE = 'MTH_RESOURCE_COST_MV' )) MTH_RUN_LOG_SQ , */
978: (SELECT
979: SUM( CASE MTH_RESOURCE_COST.ISCURRENT WHEN 1 THEN MTH_RESOURCE_COST.COST ELSE NULL END) "RESOURCE_COST",
980: MAX(MTH_RESOURCE_COST.LAST_UPDATE_DATE) "LAST_UPDATE_DATE",
981: MTH_RESOURCE_COST.RESOURCE_FK_KEY "RESOURCE_FK_KEY"
982: FROM
983: MTH_RESOURCE_COST
984: GROUP BY

Line 981: MTH_RESOURCE_COST.RESOURCE_FK_KEY "RESOURCE_FK_KEY"

977: (MTH_RUN_LOG.FACT_TABLE = 'MTH_RESOURCE_COST_MV' )) MTH_RUN_LOG_SQ , */
978: (SELECT
979: SUM( CASE MTH_RESOURCE_COST.ISCURRENT WHEN 1 THEN MTH_RESOURCE_COST.COST ELSE NULL END) "RESOURCE_COST",
980: MAX(MTH_RESOURCE_COST.LAST_UPDATE_DATE) "LAST_UPDATE_DATE",
981: MTH_RESOURCE_COST.RESOURCE_FK_KEY "RESOURCE_FK_KEY"
982: FROM
983: MTH_RESOURCE_COST
984: GROUP BY
985: MTH_RESOURCE_COST.RESOURCE_FK_KEY) "RESOURCE_COST_SQ"

Line 983: MTH_RESOURCE_COST

979: SUM( CASE MTH_RESOURCE_COST.ISCURRENT WHEN 1 THEN MTH_RESOURCE_COST.COST ELSE NULL END) "RESOURCE_COST",
980: MAX(MTH_RESOURCE_COST.LAST_UPDATE_DATE) "LAST_UPDATE_DATE",
981: MTH_RESOURCE_COST.RESOURCE_FK_KEY "RESOURCE_FK_KEY"
982: FROM
983: MTH_RESOURCE_COST
984: GROUP BY
985: MTH_RESOURCE_COST.RESOURCE_FK_KEY) "RESOURCE_COST_SQ"
986: WHERE
987: ( RESOURCE_COST_SQ.LAST_UPDATE_DATE > v_log_from_date AND RESOURCE_COST_SQ.LAST_UPDATE_DATE <= v_log_to_date)

Line 985: MTH_RESOURCE_COST.RESOURCE_FK_KEY) "RESOURCE_COST_SQ"

981: MTH_RESOURCE_COST.RESOURCE_FK_KEY "RESOURCE_FK_KEY"
982: FROM
983: MTH_RESOURCE_COST
984: GROUP BY
985: MTH_RESOURCE_COST.RESOURCE_FK_KEY) "RESOURCE_COST_SQ"
986: WHERE
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

Line 1025: (MTH_RUN_LOG.FACT_TABLE = 'MTH_RESOURCE_COST_MV' )) MTH_RUN_LOG_SQ , */

1021: MTH_RUN_LOG.TO_DATE
1022: FROM
1023: MTH_RUN_LOG
1024: WHERE
1025: (MTH_RUN_LOG.FACT_TABLE = 'MTH_RESOURCE_COST_MV' )) MTH_RUN_LOG_SQ , */
1026: (SELECT
1027: SUM( CASE MTH_RESOURCE_COST.ISCURRENT WHEN 1 THEN MTH_RESOURCE_COST.COST ELSE NULL END) "RESOURCE_COST",
1028: MAX(MTH_RESOURCE_COST.LAST_UPDATE_DATE) "LAST_UPDATE_DATE",
1029: MTH_RESOURCE_COST.RESOURCE_FK_KEY "RESOURCE_FK_KEY"

Line 1027: SUM( CASE MTH_RESOURCE_COST.ISCURRENT WHEN 1 THEN MTH_RESOURCE_COST.COST ELSE NULL END) "RESOURCE_COST",

1023: MTH_RUN_LOG
1024: WHERE
1025: (MTH_RUN_LOG.FACT_TABLE = 'MTH_RESOURCE_COST_MV' )) MTH_RUN_LOG_SQ , */
1026: (SELECT
1027: SUM( CASE MTH_RESOURCE_COST.ISCURRENT WHEN 1 THEN MTH_RESOURCE_COST.COST ELSE NULL END) "RESOURCE_COST",
1028: MAX(MTH_RESOURCE_COST.LAST_UPDATE_DATE) "LAST_UPDATE_DATE",
1029: MTH_RESOURCE_COST.RESOURCE_FK_KEY "RESOURCE_FK_KEY"
1030: FROM
1031: MTH_RESOURCE_COST

Line 1028: MAX(MTH_RESOURCE_COST.LAST_UPDATE_DATE) "LAST_UPDATE_DATE",

1024: WHERE
1025: (MTH_RUN_LOG.FACT_TABLE = 'MTH_RESOURCE_COST_MV' )) MTH_RUN_LOG_SQ , */
1026: (SELECT
1027: SUM( CASE MTH_RESOURCE_COST.ISCURRENT WHEN 1 THEN MTH_RESOURCE_COST.COST ELSE NULL END) "RESOURCE_COST",
1028: MAX(MTH_RESOURCE_COST.LAST_UPDATE_DATE) "LAST_UPDATE_DATE",
1029: MTH_RESOURCE_COST.RESOURCE_FK_KEY "RESOURCE_FK_KEY"
1030: FROM
1031: MTH_RESOURCE_COST
1032: GROUP BY

Line 1029: MTH_RESOURCE_COST.RESOURCE_FK_KEY "RESOURCE_FK_KEY"

1025: (MTH_RUN_LOG.FACT_TABLE = 'MTH_RESOURCE_COST_MV' )) MTH_RUN_LOG_SQ , */
1026: (SELECT
1027: SUM( CASE MTH_RESOURCE_COST.ISCURRENT WHEN 1 THEN MTH_RESOURCE_COST.COST ELSE NULL END) "RESOURCE_COST",
1028: MAX(MTH_RESOURCE_COST.LAST_UPDATE_DATE) "LAST_UPDATE_DATE",
1029: MTH_RESOURCE_COST.RESOURCE_FK_KEY "RESOURCE_FK_KEY"
1030: FROM
1031: MTH_RESOURCE_COST
1032: GROUP BY
1033: MTH_RESOURCE_COST.RESOURCE_FK_KEY) "RESOURCE_COST_SQ"

Line 1031: MTH_RESOURCE_COST

1027: SUM( CASE MTH_RESOURCE_COST.ISCURRENT WHEN 1 THEN MTH_RESOURCE_COST.COST ELSE NULL END) "RESOURCE_COST",
1028: MAX(MTH_RESOURCE_COST.LAST_UPDATE_DATE) "LAST_UPDATE_DATE",
1029: MTH_RESOURCE_COST.RESOURCE_FK_KEY "RESOURCE_FK_KEY"
1030: FROM
1031: MTH_RESOURCE_COST
1032: GROUP BY
1033: MTH_RESOURCE_COST.RESOURCE_FK_KEY) "RESOURCE_COST_SQ"
1034: WHERE
1035: ( RESOURCE_COST_SQ.LAST_UPDATE_DATE > v_log_from_date AND RESOURCE_COST_SQ.LAST_UPDATE_DATE <= v_log_to_date)

Line 1033: MTH_RESOURCE_COST.RESOURCE_FK_KEY) "RESOURCE_COST_SQ"

1029: MTH_RESOURCE_COST.RESOURCE_FK_KEY "RESOURCE_FK_KEY"
1030: FROM
1031: MTH_RESOURCE_COST
1032: GROUP BY
1033: MTH_RESOURCE_COST.RESOURCE_FK_KEY) "RESOURCE_COST_SQ"
1034: WHERE
1035: ( RESOURCE_COST_SQ.LAST_UPDATE_DATE > v_log_from_date AND RESOURCE_COST_SQ.LAST_UPDATE_DATE <= v_log_to_date)
1036: )
1037: MERGE_RESOURCE_REQ_SQ

Line 1073: (MTH_RUN_LOG.FACT_TABLE = 'MTH_RESOURCE_COST_MV' )) MTH_RUN_LOG_SQ , */

1069: MTH_RUN_LOG.TO_DATE
1070: FROM
1071: MTH_RUN_LOG
1072: WHERE
1073: (MTH_RUN_LOG.FACT_TABLE = 'MTH_RESOURCE_COST_MV' )) MTH_RUN_LOG_SQ , */
1074: (SELECT
1075: SUM( CASE MTH_RESOURCE_COST.ISCURRENT WHEN 1 THEN MTH_RESOURCE_COST.COST ELSE NULL END) "RESOURCE_COST",
1076: MAX(MTH_RESOURCE_COST.LAST_UPDATE_DATE) "LAST_UPDATE_DATE",
1077: MTH_RESOURCE_COST.RESOURCE_FK_KEY "RESOURCE_FK_KEY"

Line 1075: SUM( CASE MTH_RESOURCE_COST.ISCURRENT WHEN 1 THEN MTH_RESOURCE_COST.COST ELSE NULL END) "RESOURCE_COST",

1071: MTH_RUN_LOG
1072: WHERE
1073: (MTH_RUN_LOG.FACT_TABLE = 'MTH_RESOURCE_COST_MV' )) MTH_RUN_LOG_SQ , */
1074: (SELECT
1075: SUM( CASE MTH_RESOURCE_COST.ISCURRENT WHEN 1 THEN MTH_RESOURCE_COST.COST ELSE NULL END) "RESOURCE_COST",
1076: MAX(MTH_RESOURCE_COST.LAST_UPDATE_DATE) "LAST_UPDATE_DATE",
1077: MTH_RESOURCE_COST.RESOURCE_FK_KEY "RESOURCE_FK_KEY"
1078: FROM
1079: MTH_RESOURCE_COST

Line 1076: MAX(MTH_RESOURCE_COST.LAST_UPDATE_DATE) "LAST_UPDATE_DATE",

1072: WHERE
1073: (MTH_RUN_LOG.FACT_TABLE = 'MTH_RESOURCE_COST_MV' )) MTH_RUN_LOG_SQ , */
1074: (SELECT
1075: SUM( CASE MTH_RESOURCE_COST.ISCURRENT WHEN 1 THEN MTH_RESOURCE_COST.COST ELSE NULL END) "RESOURCE_COST",
1076: MAX(MTH_RESOURCE_COST.LAST_UPDATE_DATE) "LAST_UPDATE_DATE",
1077: MTH_RESOURCE_COST.RESOURCE_FK_KEY "RESOURCE_FK_KEY"
1078: FROM
1079: MTH_RESOURCE_COST
1080: GROUP BY

Line 1077: MTH_RESOURCE_COST.RESOURCE_FK_KEY "RESOURCE_FK_KEY"

1073: (MTH_RUN_LOG.FACT_TABLE = 'MTH_RESOURCE_COST_MV' )) MTH_RUN_LOG_SQ , */
1074: (SELECT
1075: SUM( CASE MTH_RESOURCE_COST.ISCURRENT WHEN 1 THEN MTH_RESOURCE_COST.COST ELSE NULL END) "RESOURCE_COST",
1076: MAX(MTH_RESOURCE_COST.LAST_UPDATE_DATE) "LAST_UPDATE_DATE",
1077: MTH_RESOURCE_COST.RESOURCE_FK_KEY "RESOURCE_FK_KEY"
1078: FROM
1079: MTH_RESOURCE_COST
1080: GROUP BY
1081: MTH_RESOURCE_COST.RESOURCE_FK_KEY) "RESOURCE_COST_SQ"

Line 1079: MTH_RESOURCE_COST

1075: SUM( CASE MTH_RESOURCE_COST.ISCURRENT WHEN 1 THEN MTH_RESOURCE_COST.COST ELSE NULL END) "RESOURCE_COST",
1076: MAX(MTH_RESOURCE_COST.LAST_UPDATE_DATE) "LAST_UPDATE_DATE",
1077: MTH_RESOURCE_COST.RESOURCE_FK_KEY "RESOURCE_FK_KEY"
1078: FROM
1079: MTH_RESOURCE_COST
1080: GROUP BY
1081: MTH_RESOURCE_COST.RESOURCE_FK_KEY) "RESOURCE_COST_SQ"
1082: WHERE
1083: ( RESOURCE_COST_SQ.LAST_UPDATE_DATE > v_log_from_date AND RESOURCE_COST_SQ.LAST_UPDATE_DATE <= v_log_to_date)

Line 1081: MTH_RESOURCE_COST.RESOURCE_FK_KEY) "RESOURCE_COST_SQ"

1077: MTH_RESOURCE_COST.RESOURCE_FK_KEY "RESOURCE_FK_KEY"
1078: FROM
1079: MTH_RESOURCE_COST
1080: GROUP BY
1081: MTH_RESOURCE_COST.RESOURCE_FK_KEY) "RESOURCE_COST_SQ"
1082: WHERE
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

Line 1121: (MTH_RUN_LOG.FACT_TABLE = 'MTH_RESOURCE_COST_MV' )) MTH_RUN_LOG_SQ ,*/

1117: MTH_RUN_LOG.TO_DATE
1118: FROM
1119: MTH_RUN_LOG
1120: WHERE
1121: (MTH_RUN_LOG.FACT_TABLE = 'MTH_RESOURCE_COST_MV' )) MTH_RUN_LOG_SQ ,*/
1122: (SELECT
1123: SUM( CASE MTH_RESOURCE_COST.ISCURRENT WHEN 1 THEN MTH_RESOURCE_COST.COST ELSE NULL END) "RESOURCE_COST",
1124: MAX(MTH_RESOURCE_COST.LAST_UPDATE_DATE) "LAST_UPDATE_DATE",
1125: MTH_RESOURCE_COST.RESOURCE_FK_KEY "RESOURCE_FK_KEY"

Line 1123: SUM( CASE MTH_RESOURCE_COST.ISCURRENT WHEN 1 THEN MTH_RESOURCE_COST.COST ELSE NULL END) "RESOURCE_COST",

1119: MTH_RUN_LOG
1120: WHERE
1121: (MTH_RUN_LOG.FACT_TABLE = 'MTH_RESOURCE_COST_MV' )) MTH_RUN_LOG_SQ ,*/
1122: (SELECT
1123: SUM( CASE MTH_RESOURCE_COST.ISCURRENT WHEN 1 THEN MTH_RESOURCE_COST.COST ELSE NULL END) "RESOURCE_COST",
1124: MAX(MTH_RESOURCE_COST.LAST_UPDATE_DATE) "LAST_UPDATE_DATE",
1125: MTH_RESOURCE_COST.RESOURCE_FK_KEY "RESOURCE_FK_KEY"
1126: FROM
1127: MTH_RESOURCE_COST

Line 1124: MAX(MTH_RESOURCE_COST.LAST_UPDATE_DATE) "LAST_UPDATE_DATE",

1120: WHERE
1121: (MTH_RUN_LOG.FACT_TABLE = 'MTH_RESOURCE_COST_MV' )) MTH_RUN_LOG_SQ ,*/
1122: (SELECT
1123: SUM( CASE MTH_RESOURCE_COST.ISCURRENT WHEN 1 THEN MTH_RESOURCE_COST.COST ELSE NULL END) "RESOURCE_COST",
1124: MAX(MTH_RESOURCE_COST.LAST_UPDATE_DATE) "LAST_UPDATE_DATE",
1125: MTH_RESOURCE_COST.RESOURCE_FK_KEY "RESOURCE_FK_KEY"
1126: FROM
1127: MTH_RESOURCE_COST
1128: GROUP BY

Line 1125: MTH_RESOURCE_COST.RESOURCE_FK_KEY "RESOURCE_FK_KEY"

1121: (MTH_RUN_LOG.FACT_TABLE = 'MTH_RESOURCE_COST_MV' )) MTH_RUN_LOG_SQ ,*/
1122: (SELECT
1123: SUM( CASE MTH_RESOURCE_COST.ISCURRENT WHEN 1 THEN MTH_RESOURCE_COST.COST ELSE NULL END) "RESOURCE_COST",
1124: MAX(MTH_RESOURCE_COST.LAST_UPDATE_DATE) "LAST_UPDATE_DATE",
1125: MTH_RESOURCE_COST.RESOURCE_FK_KEY "RESOURCE_FK_KEY"
1126: FROM
1127: MTH_RESOURCE_COST
1128: GROUP BY
1129: MTH_RESOURCE_COST.RESOURCE_FK_KEY) "RESOURCE_COST_SQ"

Line 1127: MTH_RESOURCE_COST

1123: SUM( CASE MTH_RESOURCE_COST.ISCURRENT WHEN 1 THEN MTH_RESOURCE_COST.COST ELSE NULL END) "RESOURCE_COST",
1124: MAX(MTH_RESOURCE_COST.LAST_UPDATE_DATE) "LAST_UPDATE_DATE",
1125: MTH_RESOURCE_COST.RESOURCE_FK_KEY "RESOURCE_FK_KEY"
1126: FROM
1127: MTH_RESOURCE_COST
1128: GROUP BY
1129: MTH_RESOURCE_COST.RESOURCE_FK_KEY) "RESOURCE_COST_SQ"
1130: WHERE
1131: ( RESOURCE_COST_SQ.LAST_UPDATE_DATE > v_log_from_date AND RESOURCE_COST_SQ.LAST_UPDATE_DATE <= v_log_to_date)

Line 1129: MTH_RESOURCE_COST.RESOURCE_FK_KEY) "RESOURCE_COST_SQ"

1125: MTH_RESOURCE_COST.RESOURCE_FK_KEY "RESOURCE_FK_KEY"
1126: FROM
1127: MTH_RESOURCE_COST
1128: GROUP BY
1129: MTH_RESOURCE_COST.RESOURCE_FK_KEY) "RESOURCE_COST_SQ"
1130: WHERE
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

Line 1169: (MTH_RUN_LOG.FACT_TABLE = 'MTH_RESOURCE_COST_MV' )) MTH_RUN_LOG_SQ ,*/

1165: MTH_RUN_LOG.TO_DATE
1166: FROM
1167: MTH_RUN_LOG
1168: WHERE
1169: (MTH_RUN_LOG.FACT_TABLE = 'MTH_RESOURCE_COST_MV' )) MTH_RUN_LOG_SQ ,*/
1170: (SELECT
1171: SUM( CASE MTH_RESOURCE_COST.ISCURRENT WHEN 1 THEN MTH_RESOURCE_COST.COST ELSE NULL END) "RESOURCE_COST",
1172: MAX(MTH_RESOURCE_COST.LAST_UPDATE_DATE) "LAST_UPDATE_DATE",
1173: MTH_RESOURCE_COST.RESOURCE_FK_KEY "RESOURCE_FK_KEY"

Line 1171: SUM( CASE MTH_RESOURCE_COST.ISCURRENT WHEN 1 THEN MTH_RESOURCE_COST.COST ELSE NULL END) "RESOURCE_COST",

1167: MTH_RUN_LOG
1168: WHERE
1169: (MTH_RUN_LOG.FACT_TABLE = 'MTH_RESOURCE_COST_MV' )) MTH_RUN_LOG_SQ ,*/
1170: (SELECT
1171: SUM( CASE MTH_RESOURCE_COST.ISCURRENT WHEN 1 THEN MTH_RESOURCE_COST.COST ELSE NULL END) "RESOURCE_COST",
1172: MAX(MTH_RESOURCE_COST.LAST_UPDATE_DATE) "LAST_UPDATE_DATE",
1173: MTH_RESOURCE_COST.RESOURCE_FK_KEY "RESOURCE_FK_KEY"
1174: FROM
1175: MTH_RESOURCE_COST

Line 1172: MAX(MTH_RESOURCE_COST.LAST_UPDATE_DATE) "LAST_UPDATE_DATE",

1168: WHERE
1169: (MTH_RUN_LOG.FACT_TABLE = 'MTH_RESOURCE_COST_MV' )) MTH_RUN_LOG_SQ ,*/
1170: (SELECT
1171: SUM( CASE MTH_RESOURCE_COST.ISCURRENT WHEN 1 THEN MTH_RESOURCE_COST.COST ELSE NULL END) "RESOURCE_COST",
1172: MAX(MTH_RESOURCE_COST.LAST_UPDATE_DATE) "LAST_UPDATE_DATE",
1173: MTH_RESOURCE_COST.RESOURCE_FK_KEY "RESOURCE_FK_KEY"
1174: FROM
1175: MTH_RESOURCE_COST
1176: GROUP BY

Line 1173: MTH_RESOURCE_COST.RESOURCE_FK_KEY "RESOURCE_FK_KEY"

1169: (MTH_RUN_LOG.FACT_TABLE = 'MTH_RESOURCE_COST_MV' )) MTH_RUN_LOG_SQ ,*/
1170: (SELECT
1171: SUM( CASE MTH_RESOURCE_COST.ISCURRENT WHEN 1 THEN MTH_RESOURCE_COST.COST ELSE NULL END) "RESOURCE_COST",
1172: MAX(MTH_RESOURCE_COST.LAST_UPDATE_DATE) "LAST_UPDATE_DATE",
1173: MTH_RESOURCE_COST.RESOURCE_FK_KEY "RESOURCE_FK_KEY"
1174: FROM
1175: MTH_RESOURCE_COST
1176: GROUP BY
1177: MTH_RESOURCE_COST.RESOURCE_FK_KEY) "RESOURCE_COST_SQ"

Line 1175: MTH_RESOURCE_COST

1171: SUM( CASE MTH_RESOURCE_COST.ISCURRENT WHEN 1 THEN MTH_RESOURCE_COST.COST ELSE NULL END) "RESOURCE_COST",
1172: MAX(MTH_RESOURCE_COST.LAST_UPDATE_DATE) "LAST_UPDATE_DATE",
1173: MTH_RESOURCE_COST.RESOURCE_FK_KEY "RESOURCE_FK_KEY"
1174: FROM
1175: MTH_RESOURCE_COST
1176: GROUP BY
1177: MTH_RESOURCE_COST.RESOURCE_FK_KEY) "RESOURCE_COST_SQ"
1178: WHERE
1179: ( RESOURCE_COST_SQ.LAST_UPDATE_DATE > v_log_from_date AND RESOURCE_COST_SQ.LAST_UPDATE_DATE <= v_log_to_date)

Line 1177: MTH_RESOURCE_COST.RESOURCE_FK_KEY) "RESOURCE_COST_SQ"

1173: MTH_RESOURCE_COST.RESOURCE_FK_KEY "RESOURCE_FK_KEY"
1174: FROM
1175: MTH_RESOURCE_COST
1176: GROUP BY
1177: MTH_RESOURCE_COST.RESOURCE_FK_KEY) "RESOURCE_COST_SQ"
1178: WHERE
1179: ( RESOURCE_COST_SQ.LAST_UPDATE_DATE > v_log_from_date AND RESOURCE_COST_SQ.LAST_UPDATE_DATE <= v_log_to_date)
1180: )
1181: MERGE_RESOURCE_TXN_SQ

Line 1197: mth_util_pkg.mth_run_log_post_load('MTH_RESOURCE_COST_MV',v_unassigned_val);

1193:
1194: mth_util_pkg.log_msg('Number of rows updated in MTH_RESOURCE_TXN_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
1195:
1196: ----Call mth_run_log_post_load
1197: mth_util_pkg.mth_run_log_post_load('MTH_RESOURCE_COST_MV',v_unassigned_val);
1198:
1199: COMMIT;
1200: mth_util_pkg.log_msg('MTH_POPULATE_RESOURCE_COST_MV end', mth_util_pkg.G_DBG_PROC_FUN_END);
1201: EXCEPTION

Line 1203: mth_util_pkg.log_msg('Exception OTHERS in MTH_RESOURCE_COST_MV_ALL_MAP', mth_util_pkg.G_DBG_EXCEPTION);

1199: COMMIT;
1200: mth_util_pkg.log_msg('MTH_POPULATE_RESOURCE_COST_MV end', mth_util_pkg.G_DBG_PROC_FUN_END);
1201: EXCEPTION
1202: WHEN OTHERS THEN
1203: mth_util_pkg.log_msg('Exception OTHERS in MTH_RESOURCE_COST_MV_ALL_MAP', mth_util_pkg.G_DBG_EXCEPTION);
1204: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
1205: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
1206: ROLLBACK;
1207: RAISE;