Product: | WMS - Warehouse Management |
---|---|
Description: | WMS business object MLS view |
Implementation/DBA Data: | APPS.WMS_OBJECTS_VL |
SELECT WOB.OBJECT_ID
, WOB.LAST_UPDATED_BY
, WOB.LAST_UPDATE_DATE
, WOB.CREATED_BY
, WOB.CREATION_DATE
, WOB.LAST_UPDATE_LOGIN
, WOTL.NAME
, WOTL.DESCRIPTION
, WOB.STRAT_ASGMT_DB_OBJECT_ID
, WOB.STRAT_ASGMT_LOV_SQL
, WOB.USER_DEFINED_FLAG
, WOB.ATTRIBUTE_CATEGORY
, WOB.ATTRIBUTE1
, WOB.ATTRIBUTE2
, WOB.ATTRIBUTE3
, WOB.ATTRIBUTE4
, WOB.ATTRIBUTE5
, WOB.ATTRIBUTE6
, WOB.ATTRIBUTE7
, WOB.ATTRIBUTE8
, WOB.ATTRIBUTE9
, WOB.ATTRIBUTE10
, WOB.ATTRIBUTE11
, WOB.ATTRIBUTE12
, WOB.ATTRIBUTE13
, WOB.ATTRIBUTE14
, WOB.ATTRIBUTE15
, WOB.ROWID
FROM WMS_OBJECTS_TL WOTL
, WMS_OBJECTS_B WOB
WHERE WOTL.OBJECT_ID = WOB.OBJECT_ID
AND WOTL.LANGUAGE = USERENV('LANG')