DBA Data[Home] [Help]

APPS.CSM_MTL_SYSTEM_ITEMS_EVENT_PKG dependencies on MTL_SYSTEM_ITEMS_TL

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

455:
456: l_run_date := SYSDATE;
457:
458: /* This portion of code assumes indexes on last_update_date on MTL_SYSTEM_ITEMS_B */
459: /* , MTL_SYSTEM_ITEMS_TL which were custom created */
460: SELECT MAX(last_update_date) INTO l_max_last_update_date_b
461: FROM mtl_system_items_b;
462: IF( l_max_last_update_date_b < p_last_run_date) THEN
463: SELECT MAX(last_update_date) INTO l_max_last_update_date_tl

Line 464: FROM mtl_system_items_tl;

460: SELECT MAX(last_update_date) INTO l_max_last_update_date_b
461: FROM mtl_system_items_b;
462: IF( l_max_last_update_date_b < p_last_run_date) THEN
463: SELECT MAX(last_update_date) INTO l_max_last_update_date_tl
464: FROM mtl_system_items_tl;
465: IF(l_max_last_update_date_tl < p_last_run_date) THEN
466: -- No updates
467: CSM_UTIL_PKG.LOG('Leaving UPDATE_MTL_SYSTEM_ITEMS - No Updates ',
468: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.UPDATE_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);