eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: CZFV_CONFIGURATION_ATTRIBUTES

Product:	BOM - Bills of Material
Description:	- Retrofitted
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT AT.ATTRIBUTE_CODE
, AP.APPLICATION_NAME
, ATTL.NAME
, '_LA:DATA_TYPE:AK_LOOKUP_CODES:DATA_TYPE:DESCRIPTION'
, AT.ATTRIBUTE_VALUE_LENGTH
, '_LA:UPPER_CASE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, ATTL.ATTRIBUTE_LABEL_LONG
, AT.ATTRIBUTE_LABEL_LENGTH
, AT.DEFAULT_VALUE_VARCHAR2
, AT.DEFAULT_VALUE_NUMBER
, RE.NAME
, '_DF:AK:AK_ATTRIBUTES:AT'
, AT.ATTRIBUTE_APPLICATION_ID
, AT.LOV_REGION_CODE
, AT.LOV_REGION_APPLICATION_ID
, AT.CREATION_DATE
, AT.CREATED_BY
, AT.LAST_UPDATE_DATE
, AT.LAST_UPDATED_BY
FROM FND_APPLICATION_VL AP
, AK_REGIONS_VL RE
, AK_ATTRIBUTES_TL ATTL
, AK_ATTRIBUTES AT
WHERE AT.ATTRIBUTE_APPLICATION_ID = ATTL.ATTRIBUTE_APPLICATION_ID
AND AT.ATTRIBUTE_CODE = ATTL.ATTRIBUTE_CODE
AND ATTL.LANGUAGE = USERENV('LANG')
AND AT.ATTRIBUTE_APPLICATION_ID = 702
AND AT.LOV_REGION_CODE = RE.REGION_CODE(+)
AND RE.REGION_APPLICATION_ID(+) = 702
AND AT.ATTRIBUTE_APPLICATION_ID = AP.APPLICATION_ID WITH READ ONLY

Columns

Name
CONFIGURATION_ATTRIBUTE_ID
APPLICATION_NAME
CONFIGURATION_ATTRIBUTE_NAME
"_LA:DATA_TYPE"
VALUE_LENGTH
"_LA:UPPERCASE_FLAG"
LABEL
LABEL_LENGTH
DEFAULT_CHARACTER_VALUE
DEFAULT_NUMBER_VALUE
LIST_ATTRIBUTE_DATATYPE
"_DF"
ATTRIBUTE_APPLICATION_ID
LOV_REGION_CODE
LOV_REGION_APPLICATION_ID
CREATED_DATE
CREATED_BY
LAST_UPDATED_DATE
LAST_UPDATED_BY