View: WMS_OBJECTS_STRATEGY_LOV_V

Product:	WMS - Warehouse Management
Description:	WMS business object available for strategy assignment LOV view
Implementation/DBA Data:	APPS.WMS_OBJECTS_STRATEGY_LOV_V

View Text

SELECT WOHO.ORGANIZATION_ID
, WOHO.OBJECT_ID
, WOVL.NAME
, WOVL.DESCRIPTION
FROM WMS_OBJECTS_VL WOVL
, WMS_ORG_HIERARCHY_OBJS WOHO
WHERE WOVL.OBJECT_ID = WOHO.OBJECT_ID
AND WOVL.STRAT_ASGMT_DB_OBJECT_ID IS NOT NULL
AND WOVL.STRAT_ASGMT_LOV_SQL IS NOT NULL

Columns