APPS.MTH_MV_TO_FACT_PKG dependencies on STANDARD

Line 634: * Description :This procedure updates the Equip Standard Rates *

630:
631:
632: /*********************************************************************************
633: * Procedure :MTH_POPULATE_EQP_STD_RATES_MV *
634: * Description :This procedure updates the Equip Standard Rates *
635: * File Name :MTHMVFB.PLS *
636: * Visibility :Public *
637: * Parameters : *
638: * Modification log : *

Line 661: -- Update the standard rates and other columns on the euip production schedule table

657: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIP_STD_RATES_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
658: 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);
659: 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);
660:
661: -- Update the standard rates and other columns on the euip production schedule table
662:
663: MERGE
664: INTO
665: MTH_EQUIP_PROD_SCHEDULE_F MEPRSF

Line 672: MESRF.STANDARD_RATE_1 "STANDARD_RATE_1"

668: MESRF.EQUIPMENT_FK_KEY "EQUIPMENT_FK_KEY",
669: MESRF.SHIFT_WORKDAY_FK_KEY "SHIFT_WORKDAY_FK_KEY",
670: MESRF.ITEM_FK_KEY "ITEM_FK_KEY",
671: v_log_to_date "LAST_UPDATE_DATE",
672: MESRF.STANDARD_RATE_1 "STANDARD_RATE_1"
673: FROM
674: /*(SELECT
675: DISTINCT
676: MTH_RUN_LOG.FROM_DATE,

Line 682: MTH_EQUIP_STANDARD_RATES_F MESRF

678: FROM
679: MTH_RUN_LOG
680: WHERE
681: (MTH_RUN_LOG.FACT_TABLE= 'MTH_EQUIP_STD_RATES_MV')) MTH_RUN_LOG_SQ, */
682: MTH_EQUIP_STANDARD_RATES_F MESRF
683: WHERE
684: (MESRF.LAST_UPDATE_DATE > v_log_from_date AND MESRF.LAST_UPDATE_DATE <= v_log_to_date)
685: )
686: MERGE_EQUIP_PROD_SQ

Line 696: MEPRSF.STANDARD_RATE_1= MERGE_EQUIP_PROD_SQ.STANDARD_RATE_1;

692: WHEN MATCHED THEN
693: UPDATE
694: SET
695: MEPRSF.LAST_UPDATE_DATE = MERGE_EQUIP_PROD_SQ.LAST_UPDATE_DATE,
696: MEPRSF.STANDARD_RATE_1= MERGE_EQUIP_PROD_SQ.STANDARD_RATE_1;
697:
698: mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIP_PROD_SCHEDULE_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
699:
700: -- Update the standard rates and other columns on the output summary table

Line 700: -- Update the standard rates and other columns on the output summary table

696: MEPRSF.STANDARD_RATE_1= MERGE_EQUIP_PROD_SQ.STANDARD_RATE_1;
697:
698: mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIP_PROD_SCHEDULE_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
699:
700: -- Update the standard rates and other columns on the output summary table
701:
702: MERGE
703: INTO
704: MTH_EQUIP_OUTPUT_SUMMARY MEOS

Line 711: MESRF.STANDARD_RATE_1 "STANDARD_RATE_1"

707: MESRF.EQUIPMENT_FK_KEY "EQUIPMENT_FK_KEY",
708: MESRF.ITEM_FK_KEY "ITEM_FK_KEY",
709: MESRF.SHIFT_WORKDAY_FK_KEY "SHIFT_WORKDAY_FK_KEY",
710: v_log_to_date "LAST_UPDATE_DATE",
711: MESRF.STANDARD_RATE_1 "STANDARD_RATE_1"
712: FROM
713: /*(SELECT
714: DISTINCT
715: MTH_RUN_LOG.FROM_DATE,

Line 721: MTH_EQUIP_STANDARD_RATES_F MESRF

717: FROM
718: MTH_RUN_LOG
719: WHERE
720: (MTH_RUN_LOG.FACT_TABLE= 'MTH_EQUIP_STD_RATES_MV' )) MTH_RUN_LOG_SQ, */
721: MTH_EQUIP_STANDARD_RATES_F MESRF
722: WHERE
723: (MESRF.LAST_UPDATE_DATE > v_log_from_date AND MESRF.LAST_UPDATE_DATE <= v_log_to_date)
724: )
725: MERGE_EQUIP_OUTPUT_SQ

Line 735: MEOS.STANDARD_RATE_1= MERGE_EQUIP_OUTPUT_SQ.STANDARD_RATE_1;

731: WHEN MATCHED THEN
732: UPDATE
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