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: CZBV_CONFIG_REGION_ATTRIBUTES

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

View Text

SELECT REIT.REGION_CODE
, RE.NAME
, AP1.APPLICATION_NAME
, REIT.ATTRIBUTE_CODE
, AT.NAME
, AP2.APPLICATION_NAME
, REIT.DISPLAY_SEQUENCE
, REIT.DISPLAY_VALUE_LENGTH
, '_LA:REIT.REQUIRED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, RETL.ATTRIBUTE_LABEL_LONG
, REIT.ATTRIBUTE_LABEL_LENGTH
, REIT.REGION_APPLICATION_ID
, REIT.ATTRIBUTE_APPLICATION_ID
, REIT.CREATION_DATE
, REIT.CREATED_BY
, REIT.LAST_UPDATE_DATE
, REIT.LAST_UPDATED_BY
FROM FND_APPLICATION_VL AP2
, FND_APPLICATION_VL AP1
, AK_REGIONS_VL RE
, AK_ATTRIBUTES_VL AT
, AK_REGION_ITEMS_TL RETL
, AK_REGION_ITEMS REIT
WHERE REIT.REGION_APPLICATION_ID = RETL.REGION_APPLICATION_ID
AND REIT.REGION_CODE = RETL.REGION_CODE
AND REIT.ATTRIBUTE_CODE = RETL.ATTRIBUTE_CODE
AND REIT.ATTRIBUTE_APPLICATION_ID = RETL.ATTRIBUTE_APPLICATION_ID
AND RETL.LANGUAGE = USERENV('LANG')
AND REIT.REGION_APPLICATION_ID = 702
AND REIT.ATTRIBUTE_APPLICATION_ID = 702
AND REIT.REGION_APPLICATION_ID = AP1.APPLICATION_ID
AND REIT.ATTRIBUTE_APPLICATION_ID = AP2.APPLICATION_ID
AND REIT.REGION_CODE = RE.REGION_CODE
AND REIT.REGION_APPLICATION_ID = RE.REGION_APPLICATION_ID
AND REIT.ATTRIBUTE_CODE = AT.ATTRIBUTE_CODE
AND REIT.ATTRIBUTE_APPLICATION_ID = AT.ATTRIBUTE_APPLICATION_ID WITH READ ONLY

Columns

Name
REGION_ID
REGION_NAME
REGION_APPLICATION_NAME
ATTRIBUTE_ID
ATTRIBUTE_NAME
ATTRIBUTE_APPLICATION_NAME
SEQUENCE
DISPLAY_LENGTH
"_LA:REQUIRED_FLAG"
LONG_LABEL
LABEL_LENGTH
REGION_APPLICATION_ID
ATTRIBUTE_APPLICATION_ID
CREATED_DATE
CREATED_BY
LAST_UPDATED_DATE
LAST_UPDATED_BY