APPS.CSM_MTL_SYSTEM_ITEMS_EVENT_PKG dependencies on MTL_SYSTEM_ITEMS_TL

Line 577: AND EXISTS ( SELECT 1 FROM mtl_system_items_tl tl

573: WHERE acc.organization_id = uorg.organization_id
574: AND uorg.category_set_id IS NULL
575: AND uorg.category_id IS NULL
576: AND acc.USER_ID = -1
577: AND EXISTS ( SELECT 1 FROM mtl_system_items_tl tl
578: WHERE tl.inventory_item_id = acc.inventory_item_id
579: AND tl.organization_id = acc.organization_id
580: AND (tl.last_update_date >= b_last_date));
581:

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

613:
614: l_run_date := SYSDATE;
615:
616: /* This portion of code assumes indexes on last_update_date on MTL_SYSTEM_ITEMS_B */
617: /* , MTL_SYSTEM_ITEMS_TL which were custom created */
618: SELECT MAX(last_update_date) INTO l_max_last_update_date_b
619: FROM mtl_system_items_b;
620: IF( l_max_last_update_date_b < p_last_run_date) THEN
621: SELECT MAX(last_update_date) INTO l_max_last_update_date_tl

Line 622: FROM mtl_system_items_tl;

618: SELECT MAX(last_update_date) INTO l_max_last_update_date_b
619: FROM mtl_system_items_b;
620: IF( l_max_last_update_date_b < p_last_run_date) THEN
621: SELECT MAX(last_update_date) INTO l_max_last_update_date_tl
622: FROM mtl_system_items_tl;
623: IF(l_max_last_update_date_tl < p_last_run_date) THEN
624: -- No updates
625: CSM_UTIL_PKG.LOG('Leaving UPDATE_MTL_SYSTEM_ITEMS - No Updates ',
626: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.UPDATE_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);