[Home] [Help]
View: WMS_LABEL_SET_FORMATS_V
Product: | WMS - Warehouse Management |
Description: | Stores information about set and format |
Implementation/DBA Data: |
APPS.WMS_LABEL_SET_FORMATS_V
|
View Text
SELECT WLSF.ROWID ROW_ID
, WLSF.SET_ID
, WLSF.FORMAT_ID
, WLF1.DOCUMENT_ID SET_DOCUMENT_ID
, WLSF.DISABLE_DATE
, WLF1.LABEL_FORMAT_NAME LABEL_SET_NAME
, WLF1.FORMAT_DESCRIPTION SET_DESC
, WLF2.LABEL_FORMAT_NAME LABEL_FORMAT_NAME
, WLF2.FORMAT_DESCRIPTION FORMAT_DESC
, WLSF.CREATION_DATE
, WLSF.CREATED_BY
, WLSF.LAST_UPDATE_DATE
, WLSF.LAST_UPDATED_BY
, WLSF.LAST_UPDATE_LOGIN
FROM WMS_LABEL_SET_FORMATS WLSF
, WMS_LABEL_FORMATS WLF2
, WMS_LABEL_FORMATS WLF1
WHERE WLSF.FORMAT_ID = WLF2.LABEL_FORMAT_ID
AND NVL(WLF2.LABEL_ENTITY_TYPE
, 0) = 0
AND WLSF.SET_ID = WLF1.LABEL_FORMAT_ID
AND WLF1.LABEL_ENTITY_TYPE = 1
Columns
Name |
ROW_ID |
SET_ID |
FORMAT_ID |
SET_DOCUMENT_ID |
DISABLE_DATE |
LABEL_SET_NAME |
SET_DESC |
LABEL_FORMAT_NAME |
FORMAT_DESC |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |