APPS.CSM_MTL_SYSTEM_ITEMS_EVENT_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 42: TYPE inventory_item_id_tbl_typ IS TABLE OF mtl_system_items_b.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;

38: l_stmt1 VARCHAR2(4000);
39: l_markdirty BOOLEAN;
40:
41:
42: TYPE inventory_item_id_tbl_typ IS TABLE OF mtl_system_items_b.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
43: TYPE organization_id_tbl_typ IS TABLE OF mtl_system_items_b.organization_id%TYPE INDEX BY BINARY_INTEGER;
44:
45: l_inventory_item_id_tbl inventory_item_id_tbl_typ;
46: l_organization_id_tbl organization_id_tbl_typ;

Line 43: TYPE organization_id_tbl_typ IS TABLE OF mtl_system_items_b.organization_id%TYPE INDEX BY BINARY_INTEGER;

39: l_markdirty BOOLEAN;
40:
41:
42: TYPE inventory_item_id_tbl_typ IS TABLE OF mtl_system_items_b.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
43: TYPE organization_id_tbl_typ IS TABLE OF mtl_system_items_b.organization_id%TYPE INDEX BY BINARY_INTEGER;
44:
45: l_inventory_item_id_tbl inventory_item_id_tbl_typ;
46: l_organization_id_tbl organization_id_tbl_typ;
47: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

Line 55: FROM MTL_SYSTEM_ITEMS_B msi

51: CURSOR c_items (b_user_id NUMBER, b_organization_id NUMBER,
52: b_changed VARCHAR2, b_last_run_date DATE)
53: IS
54: SELECT csm_mtl_system_items_acc_s.NEXTVAL, inventory_item_id, organization_id, b_user_id
55: FROM MTL_SYSTEM_ITEMS_B msi
56: WHERE msi.organization_id = b_organization_id
57: AND (b_changed = 'Y'
58: OR msi.creation_date >= NVL(b_last_run_date, msi.creation_date))
59: AND NOT EXISTS

Line 71: FROM mtl_system_items_b msi

67: CURSOR c_items_Cat (b_user_id NUMBER, b_organization_id NUMBER,
68: b_changed VARCHAR2, b_last_run_date DATE, b_category_id NUMBER)
69: IS
70: SELECT csm_mtl_system_items_acc_s.NEXTVAL, inventory_item_id, organization_id, b_user_id
71: FROM mtl_system_items_b msi
72: WHERE NOT EXISTS
73: (SELECT 1
74: FROM csm_mtl_system_items_acc acc
75: WHERE user_id = b_user_id

Line 95: FROM mtl_system_items_b msi

91: CURSOR c_items_Cat_Set (b_user_id NUMBER, b_organization_id NUMBER,
92: b_changed VARCHAR2, b_last_run_date DATE, b_category_set_id NUMBER)
93: IS
94: SELECT csm_mtl_system_items_acc_s.NEXTVAL, inventory_item_id, organization_id, b_user_id
95: FROM mtl_system_items_b msi
96: WHERE NOT EXISTS
97: (SELECT 1
98: FROM csm_mtl_system_items_acc acc
99: WHERE user_id = b_user_id

Line 119: FROM mtl_system_items_b msi

115: CURSOR c_items_Cat_Set_Cat (b_user_id NUMBER, b_organization_id NUMBER,
116: b_changed VARCHAR2, b_last_run_date DATE, b_category_id NUMBER, b_category_set_id NUMBER)
117: IS
118: SELECT csm_mtl_system_items_acc_s.NEXTVAL, inventory_item_id, organization_id, b_user_id
119: FROM mtl_system_items_b msi
120: WHERE NOT EXISTS
121: (SELECT 1
122: FROM csm_mtl_system_items_acc acc
123: WHERE user_id = b_user_id

Line 445: SELECT /*+ INDEX (acc CSM_MTL_SYSTEM_ITEMS_ACC_U1) INDEX(msi MTL_SYSTEM_ITEMS_B_U1) */

441: l_max_last_update_date_tl DATE;
442:
443: CURSOR c_changed( b_last_date DATE)
444: IS
445: SELECT /*+ INDEX (acc CSM_MTL_SYSTEM_ITEMS_ACC_U1) INDEX(msi MTL_SYSTEM_ITEMS_B_U1) */
446: acc.access_id, acc.user_id
447: FROM csm_mtl_system_items_acc acc, mtl_system_items_b msi
448: WHERE msi.inventory_item_id = acc.inventory_item_id
449: AND msi.organization_id = acc.organization_id

Line 447: FROM csm_mtl_system_items_acc acc, mtl_system_items_b msi

443: CURSOR c_changed( b_last_date DATE)
444: IS
445: SELECT /*+ INDEX (acc CSM_MTL_SYSTEM_ITEMS_ACC_U1) INDEX(msi MTL_SYSTEM_ITEMS_B_U1) */
446: acc.access_id, acc.user_id
447: FROM csm_mtl_system_items_acc acc, mtl_system_items_b msi
448: WHERE msi.inventory_item_id = acc.inventory_item_id
449: AND msi.organization_id = acc.organization_id
450: AND (msi.last_update_date >= b_last_date);
451:

Line 458: /* This portion of code assumes indexes on last_update_date on MTL_SYSTEM_ITEMS_B */

454: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.UPDATE_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);
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

Line 461: FROM mtl_system_items_b;

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
464: FROM mtl_system_items_tl;
465: IF(l_max_last_update_date_tl < p_last_run_date) THEN