Product: | AK - Common Modules-AK |
---|---|
Description: | Stores region item properties customizations. |
Implementation/DBA Data: | APPS.AK_CUSTOM_REGION_ITEMS_VL |
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