View: WMS_ORG_HIERARCHY_OBJS_V

Product:	WMS - Warehouse Management
Description:	WMS search order view
Implementation/DBA Data:	APPS.WMS_ORG_HIERARCHY_OBJS_V

View Text

SELECT WOHO.ROWID
, WOHO.ORGANIZATION_ID
, WOHO.OBJECT_ID
, WOVL.NAME
, WOVL.DESCRIPTION
, WOHO.SEARCH_ORDER
, WOHO.CREATED_BY
, WOHO.CREATION_DATE
, WOHO.LAST_UPDATED_BY
, WOHO.LAST_UPDATE_DATE
, WOHO.LAST_UPDATE_LOGIN
, WOHO.ATTRIBUTE1
, WOHO.ATTRIBUTE2
, WOHO.ATTRIBUTE3
, WOHO.ATTRIBUTE4
, WOHO.ATTRIBUTE5
, WOHO.ATTRIBUTE6
, WOHO.ATTRIBUTE7
, WOHO.ATTRIBUTE8
, WOHO.ATTRIBUTE9
, WOHO.ATTRIBUTE10
, WOHO.ATTRIBUTE11
, WOHO.ATTRIBUTE12
, WOHO.ATTRIBUTE13
, WOHO.ATTRIBUTE14
, WOHO.ATTRIBUTE15
, WOHO.ATTRIBUTE_CATEGORY
, WOHO.TYPE_CODE
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