Product: | WMS - Warehouse Management |
---|---|
Description: | This view shows multilingual information for the WMS page configuration |
Implementation/DBA Data: | APPS.WMS_PAGE_CONFIG_UI_V |
SELECT WPF.PAGE_ID
, WPF.FIELD_ID
, WPF.FIELD_DISP_SEQUENCE_NUMBER
, WPF.FIELD_NAME
, WPF.FIELD_TYPE
, WPF.FIELD_CONSTRUCTOR_PARAM
, WPF.FIELD_PROMPT
, WPF.FIELD_IS_CONFIGURABLE
, WPF.FIELD_CATEGORY
, WPF.FIELD_PROPERTY1_DEFAULT_VALUE
, WPF.FIELD_PROPERTY2_DEFAULT_VALUE
, WPF.FIELD_IS_VISIBLE
, -1 TEMPLATE_ID
, NULL TEMPLATE_NAME
, NULL USER_TEMPLATE_NAME
, NULL TEMPLATE_DESCRIPTION
, -1 CREATING_ORGANIZATION_ID
, NULL CREATING_ORGANIZATION_CODE
, NULL COMMON_TO_ALL_ORGS
, NULL ENABLED
, -1 FIELD_PROPERTY1_VALUE
, -1 FIELD_PROPERTY2_VALUE
FROM WMS_PAGE_FIELDS_VL WPF UNION ALL SELECT WPF.PAGE_ID
, WPF.FIELD_ID
, WPF.FIELD_DISP_SEQUENCE_NUMBER
, WPF.FIELD_NAME
, WPF.FIELD_TYPE
, WPF.FIELD_CONSTRUCTOR_PARAM
, WPF.FIELD_PROMPT
, WPF.FIELD_IS_CONFIGURABLE
, WPF.FIELD_CATEGORY
, WPF.FIELD_PROPERTY1_DEFAULT_VALUE
, WPF.FIELD_PROPERTY2_DEFAULT_VALUE
, WPF.FIELD_IS_VISIBLE
, WPT.TEMPLATE_ID TEMPLATE_ID
, WPT.TEMPLATE_NAME TEMPLATE_NAME
, WPT.USER_TEMPLATE_NAME USER_TEMPLATE_NAME
, WPT.TEMPLATE_DESCRIPTION TEMPLATE_DESCRIPTION
, WPT.CREATING_ORGANIZATION_ID
, WPT.CREATING_ORGANIZATION_CODE
, WPT.COMMON_TO_ALL_ORGS
, WPT.ENABLED
, WTF.FIELD_PROPERTY1_VALUE
, WTF.FIELD_PROPERTY2_VALUE
FROM WMS_PAGE_FIELDS_VL WPF
, WMS_PAGE_TEMPLATES_VL WPT
, WMS_PAGE_TEMPLATE_FIELDS WTF
WHERE WPF.PAGE_ID = WPT.PAGE_ID (+)
AND NVL(WPT.PAGE_ID
, -99) = NVL(WTF.PAGE_ID
, -99)
AND NVL(WPT.TEMPLATE_ID
, -99) = NVL(WTF.TEMPLATE_ID
, -99)
AND WPF.FIELD_ID = WTF.FIELD_ID (+)
AND WPT.ENABLED ='Y'