FND Design Data [Home] [Help]

View: WMS_LABEL_FORMATS_V

Product: WMS - Warehouse Management
Description: This view serves as a base table for the LABELS_FORMATS block in WMSLABEL.fmb (starting version 115.3) replacing WMS_LABEL_V
Implementation/DBA Data: ViewAPPS.WMS_LABEL_FORMATS_V
View Text

SELECT WLF.ROWID ROW_ID
, WLF.LABEL_FORMAT_ID
, WLF.LABEL_FORMAT_NAME
, WLF.FORMAT_DESCRIPTION
, WLF.FORMAT_DISABLE_DATE
, WLF.DEFAULT_FORMAT_FLAG
, WLF.DOCUMENT_ID
, WLF.LAST_UPDATE_DATE
, WLF.LAST_UPDATED_BY
, WLF.CREATION_DATE
, WLF.CREATED_BY
, WLF.LAST_UPDATE_LOGIN
, WLF.REQUEST_ID
, WLF.PROGRAM_APPLICATION_ID
, WLF.PROGRAM_ID
, WLF.PROGRAM_UPDATE_DATE
, WLF.ATTRIBUTE_CATEGORY
, WLF.ATTRIBUTE1
, WLF.ATTRIBUTE2
, WLF.ATTRIBUTE3
, WLF.ATTRIBUTE4
, WLF.ATTRIBUTE5
, WLF.ATTRIBUTE6
, WLF.ATTRIBUTE7
, WLF.ATTRIBUTE8
, WLF.ATTRIBUTE9
, WLF.ATTRIBUTE10
, WLF.ATTRIBUTE11
, WLF.ATTRIBUTE12
, WLF.ATTRIBUTE13
, WLF.ATTRIBUTE14
, WLF.ATTRIBUTE15
, WLF.GENERATE_EPC
, WLF.EPC_RULE_TYPE
, WLF.FILTER_VALUE
, WLF.LABEL_ENTITY_TYPE
, WLF.EPC_CATEGORY_ID
FROM WMS_LABEL_FORMATS WLF

Columns

Name
ROW_ID
LABEL_FORMAT_ID
LABEL_FORMAT_NAME
FORMAT_DESCRIPTION
FORMAT_DISABLE_DATE
DEFAULT_FORMAT_FLAG
DOCUMENT_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
GENERATE_EPC
EPC_RULE_TYPE
FILTER_VALUE
LABEL_ENTITY_TYPE
EPC_CATEGORY_ID