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_REQUIREMENTS_F

Line 476: MTH_RESOURCE_REQUIREMENTS_F MRRF

472: -- Update the Prod Schedule and other columns on the Resource Requirement table
473:
474: MERGE
475: INTO
476: MTH_RESOURCE_REQUIREMENTS_F MRRF
477: USING
478: (SELECT
479: MPSF.WORKORDER_PK_KEY "WORKORDER_PK_KEY",
480: v_log_to_date "LAST_UPDATE_DATE",

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

513: MRRF.PLANNED_COMPLETION_DATE = MERGE_RESOURCE_REQUIREMENTS_SQ.PLANNED_COMPLETION_DATE,
514: MRRF.ACTUAL_START_DATE = MERGE_RESOURCE_REQUIREMENTS_SQ.ACTUAL_START_DATE,
515: MRRF.ACTUAL_COMPLETION_DATE = MERGE_RESOURCE_REQUIREMENTS_SQ.ACTUAL_COMPLETION_DATE;
516:
517: mth_util_pkg.log_msg('Number of rows updated in MTH_RESOURCE_REQUIREMENTS_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
518:
519:
520: -- Update the Prod Schedule and other columns on the Prod MTL Consumed table
521:

Line 1008: MTH_RESOURCE_REQUIREMENTS_F

1004: -- Update the Resource cost and other columns on the resource requirements table
1005:
1006: MERGE
1007: INTO
1008: MTH_RESOURCE_REQUIREMENTS_F
1009: USING
1010: (SELECT
1011: v_log_to_date "LAST_UPDATE_DATE",
1012: v_unassigned_val "LAST_UPDATE_SYSTEM_ID",

Line 1039: MTH_RESOURCE_REQUIREMENTS_F.RESOURCE_FK_KEY = MERGE_RESOURCE_REQ_SQ.RESOURCE_FK_KEY

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
1038: ON (
1039: MTH_RESOURCE_REQUIREMENTS_F.RESOURCE_FK_KEY = MERGE_RESOURCE_REQ_SQ.RESOURCE_FK_KEY
1040: )
1041: WHEN MATCHED THEN
1042: UPDATE
1043: SET

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

1046: LAST_UPDATED_BY = MERGE_RESOURCE_REQ_SQ.LAST_UPDATED_BY,
1047: LAST_UPDATE_LOGIN = MERGE_RESOURCE_REQ_SQ.LAST_UPDATE_LOGIN,
1048: RESOURCE_COST = MERGE_RESOURCE_REQ_SQ.RESOURCE_COST ;
1049:
1050: mth_util_pkg.log_msg('Number of rows updated in MTH_RESOURCE_REQUIREMENTS_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
1051:
1052: -- Update the Resource cost and other columns on the status summary table
1053:
1054: MERGE