VIEW: APPS.WMS_PAGE_TEMPLATES_FIELDS_F_V

Source

View Text - Preformatted

SELECT WPF.PAGE_ID ,WPF.FIELD_ID ,WPF.FIELD_DISP_SEQUENCE_NUMBER ,WPF.FIELD_IS_CONFIGURABLE ,WPF.FIELD_CATEGORY ,WPF.FIELD_PROPERTY1_DEFAULT_VALUE ,WPF.FIELD_PROPERTY2_DEFAULT_VALUE ,WPF.FIELD_USER_NAME ,WTF.FIELD_PROPERTY1_VALUE ,LKP1.MEANING FIELD_PROPERTY1_MEANING ,WTF.FIELD_PROPERTY2_VALUE ,LKP2.MEANING FIELD_PROPERTY2_MEANING ,WTF.LAST_UPDATE_DATE ,WTF.LAST_UPDATED_BY ,WTF.CREATION_DATE ,WTF.CREATED_BY ,WTF.LAST_UPDATE_LOGIN ,WPT.TEMPLATE_ID ,WTF.ATTRIBUTE_CATEGORY ,WTF.ATTRIBUTE1 ,WTF.ATTRIBUTE2 ,WTF.ATTRIBUTE3 ,WTF.ATTRIBUTE4 ,WTF.ATTRIBUTE5 ,WTF.ATTRIBUTE6 ,WTF.ATTRIBUTE7 ,WTF.ATTRIBUTE8 ,WTF.ATTRIBUTE9 ,WTF.ATTRIBUTE10 ,WTF.ATTRIBUTE11 ,WTF.ATTRIBUTE12 ,WTF.ATTRIBUTE13 ,WTF.ATTRIBUTE14 ,WTF.ATTRIBUTE15 ,WPF.FIELD_NAME FROM WMS_PAGE_FIELDS_VL WPF , WMS_PAGE_TEMPLATES_VL WPT , WMS_PAGE_TEMPLATE_FIELDS WTF , MFG_LOOKUPS LKP1 , MFG_LOOKUPS LKP2 WHERE WTF.TEMPLATE_ID = WPT.TEMPLATE_ID AND WPF.PAGE_ID = WTF.PAGE_ID AND WPF.FIELD_ID = WTF.FIELD_ID AND LKP1.LOOKUP_TYPE = 'CONFIG_FIELD_VALUES' AND LKP2.LOOKUP_TYPE (+) = 'CONFIG_FIELD_VALUES' AND LKP1.LOOKUP_CODE = WTF.FIELD_PROPERTY1_VALUE AND LKP2.LOOKUP_CODE (+) = WTF.FIELD_PROPERTY2_VALUE AND WPF.FIELD_CATEGORY IN ('PAGE', 'GENERAL', 'LPN') UNION ALL SELECT WPF.PAGE_ID ,WPF.FIELD_ID ,WPF.FIELD_DISP_SEQUENCE_NUMBER ,WPF.FIELD_IS_CONFIGURABLE ,WPF.FIELD_CATEGORY ,WPF.FIELD_PROPERTY1_DEFAULT_VALUE ,WPF.FIELD_PROPERTY2_DEFAULT_VALUE ,WPF.FIELD_USER_NAME ,WTF.FIELD_PROPERTY1_VALUE ,null ,WTF.FIELD_PROPERTY2_VALUE ,null ,WTF.LAST_UPDATE_DATE ,WTF.LAST_UPDATED_BY ,WTF.CREATION_DATE ,WTF.CREATED_BY ,WTF.LAST_UPDATE_LOGIN ,WPT.TEMPLATE_ID ,WTF.ATTRIBUTE_CATEGORY ,WTF.ATTRIBUTE1 ,WTF.ATTRIBUTE2 ,WTF.ATTRIBUTE3 ,WTF.ATTRIBUTE4 ,WTF.ATTRIBUTE5 ,WTF.ATTRIBUTE6 ,WTF.ATTRIBUTE7 ,WTF.ATTRIBUTE8 ,WTF.ATTRIBUTE9 ,WTF.ATTRIBUTE10 ,WTF.ATTRIBUTE11 ,WTF.ATTRIBUTE12 ,WTF.ATTRIBUTE13 ,WTF.ATTRIBUTE14 ,WTF.ATTRIBUTE15 ,WPF.FIELD_NAME FROM WMS_PAGE_FIELDS_VL WPF , WMS_PAGE_TEMPLATES_VL WPT , WMS_PAGE_TEMPLATE_FIELDS WTF WHERE WTF.TEMPLATE_ID = WPT.TEMPLATE_ID AND WPF.PAGE_ID = WTF.PAGE_ID AND WPF.FIELD_ID = WTF.FIELD_ID AND WPF.FIELD_CATEGORY = 'BUTTON' ORDER BY 3

View Text - HTML Formatted

SELECT WPF.PAGE_ID
, WPF.FIELD_ID
, WPF.FIELD_DISP_SEQUENCE_NUMBER
, WPF.FIELD_IS_CONFIGURABLE
, WPF.FIELD_CATEGORY
, WPF.FIELD_PROPERTY1_DEFAULT_VALUE
, WPF.FIELD_PROPERTY2_DEFAULT_VALUE
, WPF.FIELD_USER_NAME
, WTF.FIELD_PROPERTY1_VALUE
, LKP1.MEANING FIELD_PROPERTY1_MEANING
, WTF.FIELD_PROPERTY2_VALUE
, LKP2.MEANING FIELD_PROPERTY2_MEANING
, WTF.LAST_UPDATE_DATE
, WTF.LAST_UPDATED_BY
, WTF.CREATION_DATE
, WTF.CREATED_BY
, WTF.LAST_UPDATE_LOGIN
, WPT.TEMPLATE_ID
, WTF.ATTRIBUTE_CATEGORY
, WTF.ATTRIBUTE1
, WTF.ATTRIBUTE2
, WTF.ATTRIBUTE3
, WTF.ATTRIBUTE4
, WTF.ATTRIBUTE5
, WTF.ATTRIBUTE6
, WTF.ATTRIBUTE7
, WTF.ATTRIBUTE8
, WTF.ATTRIBUTE9
, WTF.ATTRIBUTE10
, WTF.ATTRIBUTE11
, WTF.ATTRIBUTE12
, WTF.ATTRIBUTE13
, WTF.ATTRIBUTE14
, WTF.ATTRIBUTE15
, WPF.FIELD_NAME
FROM WMS_PAGE_FIELDS_VL WPF
, WMS_PAGE_TEMPLATES_VL WPT
, WMS_PAGE_TEMPLATE_FIELDS WTF
, MFG_LOOKUPS LKP1
, MFG_LOOKUPS LKP2
WHERE WTF.TEMPLATE_ID = WPT.TEMPLATE_ID
AND WPF.PAGE_ID = WTF.PAGE_ID
AND WPF.FIELD_ID = WTF.FIELD_ID
AND LKP1.LOOKUP_TYPE = 'CONFIG_FIELD_VALUES'
AND LKP2.LOOKUP_TYPE (+) = 'CONFIG_FIELD_VALUES'
AND LKP1.LOOKUP_CODE = WTF.FIELD_PROPERTY1_VALUE
AND LKP2.LOOKUP_CODE (+) = WTF.FIELD_PROPERTY2_VALUE
AND WPF.FIELD_CATEGORY IN ('PAGE'
, 'GENERAL'
, 'LPN') UNION ALL SELECT WPF.PAGE_ID
, WPF.FIELD_ID
, WPF.FIELD_DISP_SEQUENCE_NUMBER
, WPF.FIELD_IS_CONFIGURABLE
, WPF.FIELD_CATEGORY
, WPF.FIELD_PROPERTY1_DEFAULT_VALUE
, WPF.FIELD_PROPERTY2_DEFAULT_VALUE
, WPF.FIELD_USER_NAME
, WTF.FIELD_PROPERTY1_VALUE
, NULL
, WTF.FIELD_PROPERTY2_VALUE
, NULL
, WTF.LAST_UPDATE_DATE
, WTF.LAST_UPDATED_BY
, WTF.CREATION_DATE
, WTF.CREATED_BY
, WTF.LAST_UPDATE_LOGIN
, WPT.TEMPLATE_ID
, WTF.ATTRIBUTE_CATEGORY
, WTF.ATTRIBUTE1
, WTF.ATTRIBUTE2
, WTF.ATTRIBUTE3
, WTF.ATTRIBUTE4
, WTF.ATTRIBUTE5
, WTF.ATTRIBUTE6
, WTF.ATTRIBUTE7
, WTF.ATTRIBUTE8
, WTF.ATTRIBUTE9
, WTF.ATTRIBUTE10
, WTF.ATTRIBUTE11
, WTF.ATTRIBUTE12
, WTF.ATTRIBUTE13
, WTF.ATTRIBUTE14
, WTF.ATTRIBUTE15
, WPF.FIELD_NAME
FROM WMS_PAGE_FIELDS_VL WPF
, WMS_PAGE_TEMPLATES_VL WPT
, WMS_PAGE_TEMPLATE_FIELDS WTF
WHERE WTF.TEMPLATE_ID = WPT.TEMPLATE_ID
AND WPF.PAGE_ID = WTF.PAGE_ID
AND WPF.FIELD_ID = WTF.FIELD_ID
AND WPF.FIELD_CATEGORY = 'BUTTON' ORDER BY 3