VIEW: APPS.WMS_OBJECTS_HIERARCHY_LOV_V

Source

View Text - Preformatted

SELECT wovl.OBJECT_ID ,wovl.NAME ,wovl.DESCRIPTION FROM WMS_OBJECTS_VL wovl WHERE wovl.STRAT_ASGMT_DB_OBJECT_ID is not null AND wovl.STRAT_ASGMT_LOV_SQL is not null

View Text - HTML Formatted

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