VIEW: APPS.WMS_OBJECTS_STRATEGY_LOV_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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