APPS.CSM_SYSTEM_ITEM_EVENT_PKG dependencies on MTL_SYSTEM_ITEMS_TL

Line 359: SELECT MAX(last_update_date) FROM mtl_system_items_tl;

355: SELECT MAX(last_update_date) FROM mtl_system_items_b;
356:
357: CURSOR c_max_last_upd_date_tl
358: IS
359: SELECT MAX(last_update_date) FROM mtl_system_items_tl;
360:
361: -- insert
362: CURSOR l_systemitems_ins_csr
363: IS

Line 426: mtl_system_items_tl msi_tl

422: msi_tl.inventory_item_id,
423: msi_tl.organization_id
424: FROM csm_system_items_acc acc,
425: asg_user au,
426: mtl_system_items_tl msi_tl
427: WHERE acc.user_id = au.user_id
428: AND acc.inventory_item_id = msi_tl.inventory_item_id
429: AND acc.organization_id = msi_tl.organization_id
430: AND au.LANGUAGE = msi_tl.LANGUAGE

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

514: l_org_id.DELETE;
515: END IF;
516:
517: /* This portion of code assumes indexes on last_update_date on MTL_SYSTEM_ITEMS_B */
518: /* , MTL_SYSTEM_ITEMS_TL which were custom created */
519:
520: -- get max last_upd_date from msi
521: OPEN c_max_last_upd_date_b;
522: FETCH c_max_last_upd_date_b INTO l_max_last_update_date_b;