VIEW: APPS.WMS_PAGE_CONFIG_UI_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'