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_ITEM_COST

Line 778: mth_util_pkg.mth_run_log_pre_load('MTH_ITEM_COST_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date);

774: v_log_to_date := sysdate;
775: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
776:
777: -- Call mth_run_log_pre_load
778: mth_util_pkg.mth_run_log_pre_load('MTH_ITEM_COST_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date);
779: mth_util_pkg.GET_RUN_LOG_DATES('MTH_ITEM_COST_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
780: 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);
781: 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);
782:

Line 779: mth_util_pkg.GET_RUN_LOG_DATES('MTH_ITEM_COST_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);

775: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
776:
777: -- Call mth_run_log_pre_load
778: mth_util_pkg.mth_run_log_pre_load('MTH_ITEM_COST_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date);
779: mth_util_pkg.GET_RUN_LOG_DATES('MTH_ITEM_COST_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
780: 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);
781: 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);
782:
783: -- Update the Item cost and other columns on the Production Schedules table

Line 801: ( MTH_RUN_LOG.FACT_TABLE = 'MTH_ITEM_COST_MV' )) MTH_RUN_LOG_SQ, */

797: MTH_RUN_LOG.TO_DATE
798: FROM
799: MTH_RUN_LOG
800: WHERE
801: ( MTH_RUN_LOG.FACT_TABLE = 'MTH_ITEM_COST_MV' )) MTH_RUN_LOG_SQ, */
802: (SELECT
803: SUM(MTH_ITEM_COST.COST) "COST",
804: MAX(MTH_ITEM_COST.LAST_UPDATE_DATE)"LAST_UPDATE_DATE",
805: MTH_ITEM_COST.ITEM_FK_KEY "ITEM_FK_KEY"

Line 803: SUM(MTH_ITEM_COST.COST) "COST",

799: MTH_RUN_LOG
800: WHERE
801: ( MTH_RUN_LOG.FACT_TABLE = 'MTH_ITEM_COST_MV' )) MTH_RUN_LOG_SQ, */
802: (SELECT
803: SUM(MTH_ITEM_COST.COST) "COST",
804: MAX(MTH_ITEM_COST.LAST_UPDATE_DATE)"LAST_UPDATE_DATE",
805: MTH_ITEM_COST.ITEM_FK_KEY "ITEM_FK_KEY"
806: FROM
807: MTH_ITEM_COST

Line 804: MAX(MTH_ITEM_COST.LAST_UPDATE_DATE)"LAST_UPDATE_DATE",

800: WHERE
801: ( MTH_RUN_LOG.FACT_TABLE = 'MTH_ITEM_COST_MV' )) MTH_RUN_LOG_SQ, */
802: (SELECT
803: SUM(MTH_ITEM_COST.COST) "COST",
804: MAX(MTH_ITEM_COST.LAST_UPDATE_DATE)"LAST_UPDATE_DATE",
805: MTH_ITEM_COST.ITEM_FK_KEY "ITEM_FK_KEY"
806: FROM
807: MTH_ITEM_COST
808: WHERE

Line 805: MTH_ITEM_COST.ITEM_FK_KEY "ITEM_FK_KEY"

801: ( MTH_RUN_LOG.FACT_TABLE = 'MTH_ITEM_COST_MV' )) MTH_RUN_LOG_SQ, */
802: (SELECT
803: SUM(MTH_ITEM_COST.COST) "COST",
804: MAX(MTH_ITEM_COST.LAST_UPDATE_DATE)"LAST_UPDATE_DATE",
805: MTH_ITEM_COST.ITEM_FK_KEY "ITEM_FK_KEY"
806: FROM
807: MTH_ITEM_COST
808: WHERE
809: ( MTH_ITEM_COST.ISCURRENT= 1)

Line 807: MTH_ITEM_COST

803: SUM(MTH_ITEM_COST.COST) "COST",
804: MAX(MTH_ITEM_COST.LAST_UPDATE_DATE)"LAST_UPDATE_DATE",
805: MTH_ITEM_COST.ITEM_FK_KEY "ITEM_FK_KEY"
806: FROM
807: MTH_ITEM_COST
808: WHERE
809: ( MTH_ITEM_COST.ISCURRENT= 1)
810: GROUP BY
811: MTH_ITEM_COST.ITEM_FK_KEY)"ITEM_COST_SQ"

Line 809: ( MTH_ITEM_COST.ISCURRENT= 1)

805: MTH_ITEM_COST.ITEM_FK_KEY "ITEM_FK_KEY"
806: FROM
807: MTH_ITEM_COST
808: WHERE
809: ( MTH_ITEM_COST.ISCURRENT= 1)
810: GROUP BY
811: MTH_ITEM_COST.ITEM_FK_KEY)"ITEM_COST_SQ"
812: WHERE
813: (ITEM_COST_SQ.LAST_UPDATE_DATE > v_log_from_date and ITEM_COST_SQ.LAST_UPDATE_DATE <= v_log_to_date)

Line 811: MTH_ITEM_COST.ITEM_FK_KEY)"ITEM_COST_SQ"

807: MTH_ITEM_COST
808: WHERE
809: ( MTH_ITEM_COST.ISCURRENT= 1)
810: GROUP BY
811: MTH_ITEM_COST.ITEM_FK_KEY)"ITEM_COST_SQ"
812: WHERE
813: (ITEM_COST_SQ.LAST_UPDATE_DATE > v_log_from_date and ITEM_COST_SQ.LAST_UPDATE_DATE <= v_log_to_date)
814: )
815: MERGE_EQUIP_PROD_SCHED_SQ

Line 845: ( MTH_RUN_LOG.FACT_TABLE = 'MTH_ITEM_COST_MV')) MTH_RUN_LOG_SQ, */

841: MTH_RUN_LOG.TO_DATE
842: FROM
843: MTH_RUN_LOG
844: WHERE
845: ( MTH_RUN_LOG.FACT_TABLE = 'MTH_ITEM_COST_MV')) MTH_RUN_LOG_SQ, */
846: (SELECT
847: SUM(MTH_ITEM_COST.COST) "COST",
848: MAX(MTH_ITEM_COST.LAST_UPDATE_DATE) "LAST_UPDATE_DATE",
849: MTH_ITEM_COST.ITEM_FK_KEY "ITEM_FK_KEY"

Line 847: SUM(MTH_ITEM_COST.COST) "COST",

843: MTH_RUN_LOG
844: WHERE
845: ( MTH_RUN_LOG.FACT_TABLE = 'MTH_ITEM_COST_MV')) MTH_RUN_LOG_SQ, */
846: (SELECT
847: SUM(MTH_ITEM_COST.COST) "COST",
848: MAX(MTH_ITEM_COST.LAST_UPDATE_DATE) "LAST_UPDATE_DATE",
849: MTH_ITEM_COST.ITEM_FK_KEY "ITEM_FK_KEY"
850: FROM
851: MTH_ITEM_COST

Line 848: MAX(MTH_ITEM_COST.LAST_UPDATE_DATE) "LAST_UPDATE_DATE",

844: WHERE
845: ( MTH_RUN_LOG.FACT_TABLE = 'MTH_ITEM_COST_MV')) MTH_RUN_LOG_SQ, */
846: (SELECT
847: SUM(MTH_ITEM_COST.COST) "COST",
848: MAX(MTH_ITEM_COST.LAST_UPDATE_DATE) "LAST_UPDATE_DATE",
849: MTH_ITEM_COST.ITEM_FK_KEY "ITEM_FK_KEY"
850: FROM
851: MTH_ITEM_COST
852: GROUP BY

Line 849: MTH_ITEM_COST.ITEM_FK_KEY "ITEM_FK_KEY"

845: ( MTH_RUN_LOG.FACT_TABLE = 'MTH_ITEM_COST_MV')) MTH_RUN_LOG_SQ, */
846: (SELECT
847: SUM(MTH_ITEM_COST.COST) "COST",
848: MAX(MTH_ITEM_COST.LAST_UPDATE_DATE) "LAST_UPDATE_DATE",
849: MTH_ITEM_COST.ITEM_FK_KEY "ITEM_FK_KEY"
850: FROM
851: MTH_ITEM_COST
852: GROUP BY
853: MTH_ITEM_COST.ITEM_FK_KEY) "ITEM_COST_SQ"

Line 851: MTH_ITEM_COST

847: SUM(MTH_ITEM_COST.COST) "COST",
848: MAX(MTH_ITEM_COST.LAST_UPDATE_DATE) "LAST_UPDATE_DATE",
849: MTH_ITEM_COST.ITEM_FK_KEY "ITEM_FK_KEY"
850: FROM
851: MTH_ITEM_COST
852: GROUP BY
853: MTH_ITEM_COST.ITEM_FK_KEY) "ITEM_COST_SQ"
854: WHERE
855: (ITEM_COST_SQ.LAST_UPDATE_DATE > v_log_from_date and ITEM_COST_SQ.LAST_UPDATE_DATE <= v_log_to_date)

Line 853: MTH_ITEM_COST.ITEM_FK_KEY) "ITEM_COST_SQ"

849: MTH_ITEM_COST.ITEM_FK_KEY "ITEM_FK_KEY"
850: FROM
851: MTH_ITEM_COST
852: GROUP BY
853: MTH_ITEM_COST.ITEM_FK_KEY) "ITEM_COST_SQ"
854: WHERE
855: (ITEM_COST_SQ.LAST_UPDATE_DATE > v_log_from_date and ITEM_COST_SQ.LAST_UPDATE_DATE <= v_log_to_date)
856: )
857: MERGE_EQUIP_OUTPUT_SUM_SQ

Line 887: ( MTH_RUN_LOG.FACT_TABLE = 'MTH_ITEM_COST_MV' ))MTH_RUN_LOG_SQ , */

883: MTH_RUN_LOG.TO_DATE
884: FROM
885: MTH_RUN_LOG
886: WHERE
887: ( MTH_RUN_LOG.FACT_TABLE = 'MTH_ITEM_COST_MV' ))MTH_RUN_LOG_SQ , */
888: (SELECT
889: SUM(MTH_ITEM_COST.COST) "COST",
890: MAX(MTH_ITEM_COST.LAST_UPDATE_DATE)"LAST_UPDATE_DATE",
891: MTH_ITEM_COST.ITEM_FK_KEY "ITEM_FK_KEY"

Line 889: SUM(MTH_ITEM_COST.COST) "COST",

885: MTH_RUN_LOG
886: WHERE
887: ( MTH_RUN_LOG.FACT_TABLE = 'MTH_ITEM_COST_MV' ))MTH_RUN_LOG_SQ , */
888: (SELECT
889: SUM(MTH_ITEM_COST.COST) "COST",
890: MAX(MTH_ITEM_COST.LAST_UPDATE_DATE)"LAST_UPDATE_DATE",
891: MTH_ITEM_COST.ITEM_FK_KEY "ITEM_FK_KEY"
892: FROM
893: MTH_ITEM_COST

Line 890: MAX(MTH_ITEM_COST.LAST_UPDATE_DATE)"LAST_UPDATE_DATE",

886: WHERE
887: ( MTH_RUN_LOG.FACT_TABLE = 'MTH_ITEM_COST_MV' ))MTH_RUN_LOG_SQ , */
888: (SELECT
889: SUM(MTH_ITEM_COST.COST) "COST",
890: MAX(MTH_ITEM_COST.LAST_UPDATE_DATE)"LAST_UPDATE_DATE",
891: MTH_ITEM_COST.ITEM_FK_KEY "ITEM_FK_KEY"
892: FROM
893: MTH_ITEM_COST
894: WHERE

Line 891: MTH_ITEM_COST.ITEM_FK_KEY "ITEM_FK_KEY"

887: ( MTH_RUN_LOG.FACT_TABLE = 'MTH_ITEM_COST_MV' ))MTH_RUN_LOG_SQ , */
888: (SELECT
889: SUM(MTH_ITEM_COST.COST) "COST",
890: MAX(MTH_ITEM_COST.LAST_UPDATE_DATE)"LAST_UPDATE_DATE",
891: MTH_ITEM_COST.ITEM_FK_KEY "ITEM_FK_KEY"
892: FROM
893: MTH_ITEM_COST
894: WHERE
895: ( MTH_ITEM_COST.ISCURRENT = 1 )

Line 893: MTH_ITEM_COST

889: SUM(MTH_ITEM_COST.COST) "COST",
890: MAX(MTH_ITEM_COST.LAST_UPDATE_DATE)"LAST_UPDATE_DATE",
891: MTH_ITEM_COST.ITEM_FK_KEY "ITEM_FK_KEY"
892: FROM
893: MTH_ITEM_COST
894: WHERE
895: ( MTH_ITEM_COST.ISCURRENT = 1 )
896: GROUP BY
897: MTH_ITEM_COST.ITEM_FK_KEY)"ITEM_COST_SQ"

Line 895: ( MTH_ITEM_COST.ISCURRENT = 1 )

891: MTH_ITEM_COST.ITEM_FK_KEY "ITEM_FK_KEY"
892: FROM
893: MTH_ITEM_COST
894: WHERE
895: ( MTH_ITEM_COST.ISCURRENT = 1 )
896: GROUP BY
897: MTH_ITEM_COST.ITEM_FK_KEY)"ITEM_COST_SQ"
898: WHERE
899: (ITEM_COST_SQ.LAST_UPDATE_DATE > v_log_from_date and ITEM_COST_SQ.LAST_UPDATE_DATE <= v_log_to_date)

Line 897: MTH_ITEM_COST.ITEM_FK_KEY)"ITEM_COST_SQ"

893: MTH_ITEM_COST
894: WHERE
895: ( MTH_ITEM_COST.ISCURRENT = 1 )
896: GROUP BY
897: MTH_ITEM_COST.ITEM_FK_KEY)"ITEM_COST_SQ"
898: WHERE
899: (ITEM_COST_SQ.LAST_UPDATE_DATE > v_log_from_date and ITEM_COST_SQ.LAST_UPDATE_DATE <= v_log_to_date)
900: )
901: MERGE_PR0D_CONSUMED_SQ

Line 914: mth_util_pkg.mth_run_log_post_load('MTH_ITEM_COST_MV',v_unassigned_val);

910:
911: mth_util_pkg.log_msg('Number of rows updated in MTH_PROD_MTL_CONSUMED_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
912:
913: ----Call mth_run_log_post_load
914: mth_util_pkg.mth_run_log_post_load('MTH_ITEM_COST_MV',v_unassigned_val);
915: COMMIT;
916: mth_util_pkg.log_msg('MTH_POPULATE_ITEM_COST_MV end', mth_util_pkg.G_DBG_PROC_FUN_END);
917: EXCEPTION
918: WHEN OTHERS THEN

Line 919: mth_util_pkg.log_msg('Exception OTHERS in MTH_ITEM_COST_MV_ALL_MAP', mth_util_pkg.G_DBG_EXCEPTION);

915: COMMIT;
916: mth_util_pkg.log_msg('MTH_POPULATE_ITEM_COST_MV end', mth_util_pkg.G_DBG_PROC_FUN_END);
917: EXCEPTION
918: WHEN OTHERS THEN
919: mth_util_pkg.log_msg('Exception OTHERS in MTH_ITEM_COST_MV_ALL_MAP', mth_util_pkg.G_DBG_EXCEPTION);
920: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
921: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
922: ROLLBACK;
923: RAISE;