DBA Data[Home] [Help]

APPS.WSH_ECE_VIEWS_DEF dependencies on MTL_SYSTEM_ITEMS

Line 290: SELECT item_type FROM mtl_system_items WHERE

286: p_vehicle_item_id IN NUMBER,
287: x_vehicle_type_code OUT NOCOPY VARCHAR2 ) IS
288:
289: CURSOR c_vehicle_item_type is
290: SELECT item_type FROM mtl_system_items WHERE
291: inventory_item_id = p_vehicle_item_id AND
292: organization_id = p_vehicle_org_id AND
293: vehicle_item_flag = 'Y' ;
294: --