APPS.MTH_MV_TO_FACT_PKG dependencies on MTH_RESOURCE_TXN_F

Line 381: MTH_RESOURCE_TXN_F MRTF

377: -- Update the Prod Schedule and other columns on the Resource Transaction table
378:
379: MERGE
380: INTO
381: MTH_RESOURCE_TXN_F MRTF
382: USING
383: (SELECT
384: MPSF.WORKORDER_PK_KEY "WORKORDER_PK_KEY",
385: v_log_to_date "LAST_UPDATE_DATE",

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

418: MRTF.PLANNED_COMPLETION_DATE = MERGE_RESOURCE_TXN_SQ.PLANNED_COMPLETION_DATE,
419: MRTF.ACTUAL_START_DATE = MERGE_RESOURCE_TXN_SQ.ACTUAL_START_DATE,
420: MRTF.ACTUAL_COMPLETION_DATE = MERGE_RESOURCE_TXN_SQ.ACTUAL_COMPLETION_DATE;
421:
422: mth_util_pkg.log_msg('Number of rows updated in MTH_RESOURCE_TXN_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
423:
424:
425: -- Update the Prod Schedule and other columns on the WO Sales Orders table
426:

Line 1152: MTH_RESOURCE_TXN_F

1148: -- Update the Resource cost and other columns on the resource transactions table
1149:
1150: MERGE
1151: INTO
1152: MTH_RESOURCE_TXN_F
1153: USING
1154: (SELECT
1155: v_log_to_date "LAST_UPDATE_DATE",
1156: v_unassigned_val "LAST_UPDATE_SYSTEM_ID",

Line 1183: MTH_RESOURCE_TXN_F.RESOURCE_FK_KEY = MERGE_RESOURCE_TXN_SQ.RESOURCE_FK_KEY

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
1182: ON (
1183: MTH_RESOURCE_TXN_F.RESOURCE_FK_KEY = MERGE_RESOURCE_TXN_SQ.RESOURCE_FK_KEY
1184: )
1185: WHEN MATCHED THEN
1186: UPDATE
1187: SET

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

1190: LAST_UPDATED_BY = MERGE_RESOURCE_TXN_SQ.LAST_UPDATED_BY,
1191: LAST_UPDATE_LOGIN = MERGE_RESOURCE_TXN_SQ.LAST_UPDATE_LOGIN,
1192: RESOURCE_COST = MERGE_RESOURCE_TXN_SQ.RESOURCE_COST ;
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: