DBA Data[Home] [Help]

APPS.MTH_SEED_DATA_PKG dependencies on MTH_LOOKUPS_D

Line 522: mth_util_pkg.log_msg('Inserting MTH_LOOKUPS_D ', mth_util_pkg.G_DBG_USER_INFO);

518: MTH_UTIL_PKG.MTH_UA_GET_VAL(),
519: MTH_UTIL_PKG.MTH_UA_GET_VAL());
520:
521: mth_util_pkg.log_msg('Inserted/Updated ' || SQL%ROWCOUNT || ' rows.',mth_util_pkg.G_DBG_USER_INFO);
522: mth_util_pkg.log_msg('Inserting MTH_LOOKUPS_D ', mth_util_pkg.G_DBG_USER_INFO);
523:
524: merge INTO MTH_LOOKUPS_D t
525: USING
526: (

Line 524: merge INTO MTH_LOOKUPS_D t

520:
521: mth_util_pkg.log_msg('Inserted/Updated ' || SQL%ROWCOUNT || ' rows.',mth_util_pkg.G_DBG_USER_INFO);
522: mth_util_pkg.log_msg('Inserting MTH_LOOKUPS_D ', mth_util_pkg.G_DBG_USER_INFO);
523:
524: merge INTO MTH_LOOKUPS_D t
525: USING
526: (
527: SELECT 'MTH_BATCH_TERM_IND_L' LOOKUP_TYPE, 0 LOOKUP_CODE, 'No' REPORTING_CODE FROM DUAL UNION ALL
528: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 1 LOOKUP_CODE, 'Unreleased' REPORTING_CODE FROM DUAL UNION ALL