DBA Data[Home] [Help]

APPS.WSH_UTIL_VALIDATE dependencies on MTL_SYSTEM_ITEMS

Line 3623: FROM mtl_system_items

3619: l_wms_org VARCHAR2(1) := 'N';
3620:
3621: CURSOR veh_cont_item_cur(l_item_id NUMBER, l_organization_id NUMBER) IS
3622: SELECT container_item_flag, shippable_item_flag, vehicle_item_flag
3623: FROM mtl_system_items
3624: WHERE inventory_item_id = l_item_id AND
3625: organization_id = l_organization_id;
3626:
3627: --

Line 3867: FROM mtl_system_items

3863: weight_uom_code,
3864: unit_weight,
3865: volume_uom_code,
3866: unit_volume
3867: FROM mtl_system_items
3868: WHERE inventory_item_id = v_inventory_item_id
3869: AND organization_id = v_organization_id;
3870:
3871: BEGIN