APPS.OZF_WEBADI_INTERFACE_PVT dependencies on MTL_SYSTEM_ITEMS_VL

Line 216: SELECT INVENTORY_ITEM_ID ID FROM MTL_SYSTEM_ITEMS_VL

212: AND TRUNC(cv_start_date_active) BETWEEN start_date_active and NVL(end_date_active,TRUNC(SYSDATE)) -- Bugfix 11822771
213: AND party_id IS NULL and cust_account_id IS NULL;
214:
215: CURSOR get_item_id(p_item_name VARCHAR2)IS
216: SELECT INVENTORY_ITEM_ID ID FROM MTL_SYSTEM_ITEMS_VL
217: WHERE ORGANIZATION_ID = FND_PROFILE.VALUE('AMS_ITEM_ORGANIZATION_ID')
218: AND CONCATENATED_SEGMENTS = p_item_name;
219:
220: BEGIN