APPS.WMS_OTM_DOCK_SYNC dependencies on MTL_ITEM_LOCATIONS

Line 53: FROM mtl_item_locations

49: -- NVL function added for Description since OTM always expects a Dock Name
50: CURSOR l_dock_info_csr(l_organization_id NUMBER) IS
51: SELECT 'DOCK-' || inventory_location_id LOCATION_RES_XID,
52: NVL(description, 'DOCK-' || inventory_location_id||' Name') LOCATION_RES_NAME
53: FROM mtl_item_locations
54: WHERE organization_id = l_organization_id
55: AND inventory_location_type = 1;
56:
57: l_domain_name VARCHAR2(100);