Product: | BOM - Bills of Material |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | Not implemented in this database |
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
, AT.ATTRIBUTE_APPLICATION_ID
, LOV_REGION_CODE
, AT.CREATION_DATE
, AT.CREATED_BY
, AT.LAST_UPDATE_DATE
, AT.LAST_UPDATED_BY
FROM FND_APPLICATION_VL AP
, 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 AP.APPLICATION_ID = AT.ATTRIBUTE_APPLICATION_ID WITH READ ONLY