APPS.INVUPCTF dependencies on MTL_SYSTEM_ITEMS_B

Line 14: from mtl_system_items_B msi

10: el_value VARCHAR2(30);
11:
12: CURSOR get_iii_cursor IS
13: select msi.inventory_item_id III
14: from mtl_system_items_B msi
15: where msi.item_catalog_group_id = current_catalog_id
16: and msi.catalog_status_flag <> 'N';
17:
18: BEGIN

Line 30: UPDATE MTL_SYSTEM_ITEMS_B MSI

26: WHERE MDEV.INVENTORY_ITEM_ID = get_iii_cursor_row.III
27: AND MDEV.ELEMENT_NAME = current_element_name;
28:
29: IF el_value IS NULL THEN
30: UPDATE MTL_SYSTEM_ITEMS_B MSI
31: SET MSI.CATALOG_STATUS_FLAG = 'N'
32: WHERE MSI.INVENTORY_ITEM_ID = get_iii_cursor_row.III
33: AND MSI.ITEM_CATALOG_GROUP_ID = current_catalog_id;
34: END IF;

Line 45: UPDATE MTL_SYSTEM_ITEMS_B MSI

41: PROCEDURE UPDATE_CATSTAT_FLAG_NEW_DE(
42: current_catalog_id IN NUMBER)
43: IS
44: BEGIN
45: UPDATE MTL_SYSTEM_ITEMS_B MSI
46: SET MSI.CATALOG_STATUS_FLAG = 'N'
47: WHERE MSI.ITEM_CATALOG_GROUP_ID = current_catalog_id
48: AND MSI.CATALOG_STATUS_FLAG <> 'N';
49: