APPS.INVPULI4 dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 51: -- mtl_system_items_interface m

47: a.control_level
48: from mtl_item_status s,
49: mtl_status_attribute_values v,
50: mtl_item_attributes a
51: -- mtl_system_items_interface m
52: -- where s.inventory_item_status_code = m.inventory_item_status_code
53: -- and m.rowid = p_rowid
54: where s.inventory_item_status_code = p_status_code -- bug 7137702
55: and s.inventory_item_status_code = v.inventory_item_status_code

Line 95: AttRec MTL_SYSTEM_ITEMS_INTERFACE%ROWTYPE;

91: **STOCK_ENABLED_FLAG attribute be processed before the MTL_TRANSACTIONS_ENABLED_FLAG record
92: **since the logic of the latter is depenent on the former
93: */
94:
95: AttRec MTL_SYSTEM_ITEMS_INTERFACE%ROWTYPE;
96: master_rec master_cur%ROWTYPE;
97: Master_Org char(1);
98: Master_status_code varchar2(10);
99: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452

Line 112: FROM MTL_SYSTEM_ITEMS_INTERFACE

108: INVPUTLI.info('Inside INVPULI4.assign_status_attributes');
109: END IF;
110:
111: SELECT * INTO AttRec
112: FROM MTL_SYSTEM_ITEMS_INTERFACE
113: WHERE ROWID = p_rowid ;
114:
115: Master_Org := 'N';
116:

Line 394: update MTL_SYSTEM_ITEMS_INTERFACE

390: END IF;
391:
392: END LOOP;
393:
394: update MTL_SYSTEM_ITEMS_INTERFACE
395: set
396: STOCK_ENABLED_FLAG = AttRec.STOCK_ENABLED_FLAG,
397: MTL_TRANSACTIONS_ENABLED_FLAG = AttRec.MTL_TRANSACTIONS_ENABLED_FLAG,
398: PURCHASING_ENABLED_FLAG = AttRec.PURCHASING_ENABLED_FLAG,

Line 410: update mtl_system_items_interface

406: where rowid = p_rowid ;
407: end if ; -- Main end if
408:
409: IF (AttRec.INVENTORY_ITEM_STATUS_CODE is null and AttRec.TRANSACTION_TYPE = 'UPDATE') THEN
410: update mtl_system_items_interface
411: set inventory_item_status_code = (select msi.inventory_item_status_code
412: from mtl_system_items msi
413: where msi.inventory_item_id = AttRec.inventory_item_id
414: and msi.organization_id = AttRec.organization_id)