Product: | WMS - Warehouse Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.WMS_PAGE_FIELDS_VL |
SELECT B.ROWID ROW_ID
, B.PAGE_ID
, B.FIELD_ID
, B.FIELD_NAME
, B.FIELD_DISP_SEQUENCE_NUMBER
, B.FIELD_PROMPT
, B.FIELD_TYPE
, B.FIELD_CONSTRUCTOR_PARAM
, B.FIELD_CATEGORY
, B.FIELD_IS_CONFIGURABLE
, B.FIELD_IS_VISIBLE
, B.FIELD_PROPERTY1_DEFAULT_VALUE
, B.FIELD_PROPERTY2_DEFAULT_VALUE
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, T.FIELD_USER_NAME
FROM WMS_PAGE_FIELDS_TL T
, WMS_PAGE_FIELDS_B B
WHERE B.PAGE_ID = T.PAGE_ID
AND B.FIELD_ID = T.FIELD_ID
AND T.LANGUAGE = USERENV('LANG')