DBA Data[Home] [Help]

APPS.CSL_MTL_SYSTEM_ITEMS_ACC_PKG dependencies on MTL_SYSTEM_ITEMS_TL

Line 1250: /* , MTL_SYSTEM_ITEMS_TL which were custom created */

1246: END IF;
1247:
1248: --Bug 3929942
1249: /* This portion of code assumes indexes on last_update_date on MTL_SYSTEM_ITEMS_B */
1250: /* , MTL_SYSTEM_ITEMS_TL which were custom created */
1251: SELECT MAX(LAST_UPDATE_DATE) into l_max_last_update_date_b
1252: FROM MTL_SYSTEM_ITEMS_B;
1253: IF( l_max_last_update_date_b < p_last_run_date) THEN
1254: SELECT MAX(LAST_UPDATE_DATE) into l_max_last_update_date_tl

Line 1255: FROM MTL_SYSTEM_ITEMS_TL;

1251: SELECT MAX(LAST_UPDATE_DATE) into l_max_last_update_date_b
1252: FROM MTL_SYSTEM_ITEMS_B;
1253: IF( l_max_last_update_date_b < p_last_run_date) THEN
1254: SELECT MAX(LAST_UPDATE_DATE) into l_max_last_update_date_tl
1255: FROM MTL_SYSTEM_ITEMS_TL;
1256: IF(l_max_last_update_date_tl < p_last_run_date) THEN
1257: -- No updates
1258: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1259: jtm_message_log_pkg.Log_Msg