APPS.CSM_SYSTEM_ITEM_EVENT_PKG dependencies on MTL_SYSTEM_ITEMS_TL

Line 354: SELECT MAX(last_update_date) FROM mtl_system_items_tl;

350: SELECT MAX(last_update_date) FROM mtl_system_items_b;
351:
352: CURSOR c_max_last_upd_date_tl
353: IS
354: SELECT MAX(last_update_date) FROM mtl_system_items_tl;
355:
356: -- insert
357: CURSOR l_systemitems_ins_csr
358: IS

Line 402: SELECT /*+ INDEX (acc CSM_SYSTEM_ITEMS_ACC_U1) (msi_tl MTL_SYSTEM_ITEMS_TL_U1) */ acc.access_id,

398: ;
399:
400: CURSOR l_systemitems_upd_tl_csr(p_last_run_date DATE)
401: IS
402: SELECT /*+ INDEX (acc CSM_SYSTEM_ITEMS_ACC_U1) (msi_tl MTL_SYSTEM_ITEMS_TL_U1) */ acc.access_id,
403: acc.user_id,
404: msi_tl.inventory_item_id,
405: msi_tl.organization_id
406: FROM csm_system_items_acc acc,

Line 408: mtl_system_items_tl msi_tl

404: msi_tl.inventory_item_id,
405: msi_tl.organization_id
406: FROM csm_system_items_acc acc,
407: asg_user au,
408: mtl_system_items_tl msi_tl
409: WHERE acc.user_id = au.user_id
410: AND acc.inventory_item_id = msi_tl.inventory_item_id
411: AND acc.organization_id = msi_tl.organization_id
412: AND au.LANGUAGE = msi_tl.LANGUAGE

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

496: l_org_id.DELETE;
497: END IF;
498:
499: /* This portion of code assumes indexes on last_update_date on MTL_SYSTEM_ITEMS_B */
500: /* , MTL_SYSTEM_ITEMS_TL which were custom created */
501:
502: -- get max last_upd_date from msi
503: OPEN c_max_last_upd_date_b;
504: FETCH c_max_last_upd_date_b INTO l_max_last_update_date_b;