APPS.INV_STATUS_PKG dependencies on MTL_SECONDARY_INVENTORIES

Line 25: MTL_SECONDARY_INVENTORIES msi

21:
22: select mms.status_code
23: into x_status_code
24: from mtl_material_statuses mms ,
25: MTL_SECONDARY_INVENTORIES msi
26: where mms.status_id = msi.status_id
27: and msi.SECONDARY_INVENTORY_NAME = p_sub_inv
28: and msi.organization_id = p_org_id;
29:

Line 381: update mtl_secondary_inventories

377: IF (l_debug = 1) THEN
378: mdebug('p_sub_status_id: '||p_sub_status_id);
379: END IF;
380: if p_sub_status_id >0 then
381: update mtl_secondary_inventories
382: set status_id = p_sub_status_id
383: , last_updated_by = FND_GLOBAL.USER_ID
384: , last_update_date = SYSDATE
385: , last_update_login = FND_GLOBAL.LOGIN_ID