VIEW: APPS.AK_CUSTOM_REGION_ITEMS_VL

Source

View Text - Preformatted

SELECT ACRI.ROWID ROW_ID, ACRI.CUSTOMIZATION_APPLICATION_ID, ACRI.CUSTOMIZATION_CODE, ACRI.REGION_APPLICATION_ID, ACRI.REGION_CODE, ACRI.ATTRIBUTE_APPLICATION_ID, ACRI.ATTRIBUTE_CODE, FAV.APPLICATION_SHORT_NAME ATTRIBUTE_APPL_SHORT_NAME , FAV.APPLICATION_NAME ATTRIBUTE_APPL_NAME , AAT.NAME ATTRIBUTE_NAME, AAT.DESCRIPTION ATTRIBUTE_DESCRIPTION, ARI.ITEM_NAME, ACRI.PROPERTY_NAME, decode(ACREG.TRANSLATABLE,'Y' ,ACRIT.PROPERTY_VARCHAR2_VALUE, ACRI.PROPERTY_VARCHAR2_VALUE) PROPERTY_VARCHAR2_VALUE, ACRI.PROPERTY_NUMBER_VALUE, ACRI.PROPERTY_DATE_VALUE, ACRI.CREATED_BY, ACRI.CREATION_DATE, ACRI.LAST_UPDATED_BY, ACRI.LAST_UPDATE_DATE, ACRI.LAST_UPDATE_LOGIN from AK_CUSTOM_REGION_ITEMS ACRI, AK_CUSTOM_REGION_ITEMS_TL ACRIT, AK_CUSTOM_REGISTRY ACREG, AK_REGION_ITEMS ARI, AK_ATTRIBUTES_TL AAT, FND_APPLICATION_VL FAV where FAV.APPLICATION_ID = ACRI.ATTRIBUTE_APPLICATION_ID AND ACRI.ATTRIBUTE_APPLICATION_ID = AAT.ATTRIBUTE_APPLICATION_ID AND ACRI.ATTRIBUTE_CODE = AAT.ATTRIBUTE_CODE AND AAT.LANGUAGE = USERENV('LANG') AND ACRI.REGION_APPLICATION_ID = ACRIT.REGION_APPLICATION_ID AND ACRI.REGION_CODE = ACRIT.REGION_CODE AND ACRI.CUSTOMIZATION_APPLICATION_ID = ACRIT.CUSTOMIZATION_APPLICATION_ID AND ACRI.CUSTOMIZATION_CODE = ACRIT.CUSTOMIZATION_CODE AND ACRI.ATTRIBUTE_APPLICATION_ID = ACRIT.ATTRIBUTE_APPLICATION_ID AND ACRI.ATTRIBUTE_CODE = ACRIT.ATTRIBUTE_CODE AND ACRI.PROPERTY_NAME = ACRIT.PROPERTY_NAME AND ACRIT.LANGUAGE = USERENV('LANG') AND ACRI.PROPERTY_NAME = ACREG.PROPERTY_NAME(+) AND ACREG.CUSTOM_LEVEL(+) = 'REGION_ITEM' AND ACRI.REGION_APPLICATION_ID = ARI.REGION_APPLICATION_ID AND ACRI.REGION_CODE = ARI.REGION_CODE AND ACRI.ATTRIBUTE_APPLICATION_ID = ARI.ATTRIBUTE_APPLICATION_ID AND ACRI.ATTRIBUTE_CODE = ARI.ATTRIBUTE_CODE

View Text - HTML Formatted

SELECT ACRI.ROWID ROW_ID
, ACRI.CUSTOMIZATION_APPLICATION_ID
, ACRI.CUSTOMIZATION_CODE
, ACRI.REGION_APPLICATION_ID
, ACRI.REGION_CODE
, ACRI.ATTRIBUTE_APPLICATION_ID
, ACRI.ATTRIBUTE_CODE
, FAV.APPLICATION_SHORT_NAME ATTRIBUTE_APPL_SHORT_NAME
, FAV.APPLICATION_NAME ATTRIBUTE_APPL_NAME
, AAT.NAME ATTRIBUTE_NAME
, AAT.DESCRIPTION ATTRIBUTE_DESCRIPTION
, ARI.ITEM_NAME
, ACRI.PROPERTY_NAME
, DECODE(ACREG.TRANSLATABLE
, 'Y'
, ACRIT.PROPERTY_VARCHAR2_VALUE
, ACRI.PROPERTY_VARCHAR2_VALUE) PROPERTY_VARCHAR2_VALUE
, ACRI.PROPERTY_NUMBER_VALUE
, ACRI.PROPERTY_DATE_VALUE
, ACRI.CREATED_BY
, ACRI.CREATION_DATE
, ACRI.LAST_UPDATED_BY
, ACRI.LAST_UPDATE_DATE
, ACRI.LAST_UPDATE_LOGIN
FROM AK_CUSTOM_REGION_ITEMS ACRI
, AK_CUSTOM_REGION_ITEMS_TL ACRIT
, AK_CUSTOM_REGISTRY ACREG
, AK_REGION_ITEMS ARI
, AK_ATTRIBUTES_TL AAT
, FND_APPLICATION_VL FAV
WHERE FAV.APPLICATION_ID = ACRI.ATTRIBUTE_APPLICATION_ID
AND ACRI.ATTRIBUTE_APPLICATION_ID = AAT.ATTRIBUTE_APPLICATION_ID
AND ACRI.ATTRIBUTE_CODE = AAT.ATTRIBUTE_CODE
AND AAT.LANGUAGE = USERENV('LANG')
AND ACRI.REGION_APPLICATION_ID = ACRIT.REGION_APPLICATION_ID
AND ACRI.REGION_CODE = ACRIT.REGION_CODE
AND ACRI.CUSTOMIZATION_APPLICATION_ID = ACRIT.CUSTOMIZATION_APPLICATION_ID
AND ACRI.CUSTOMIZATION_CODE = ACRIT.CUSTOMIZATION_CODE
AND ACRI.ATTRIBUTE_APPLICATION_ID = ACRIT.ATTRIBUTE_APPLICATION_ID
AND ACRI.ATTRIBUTE_CODE = ACRIT.ATTRIBUTE_CODE
AND ACRI.PROPERTY_NAME = ACRIT.PROPERTY_NAME
AND ACRIT.LANGUAGE = USERENV('LANG')
AND ACRI.PROPERTY_NAME = ACREG.PROPERTY_NAME(+)
AND ACREG.CUSTOM_LEVEL(+) = 'REGION_ITEM'
AND ACRI.REGION_APPLICATION_ID = ARI.REGION_APPLICATION_ID
AND ACRI.REGION_CODE = ARI.REGION_CODE
AND ACRI.ATTRIBUTE_APPLICATION_ID = ARI.ATTRIBUTE_APPLICATION_ID
AND ACRI.ATTRIBUTE_CODE = ARI.ATTRIBUTE_CODE