View: AK_CUSTOM_REGIONS_VL

Product:	AK - Common Modules-AK
Description:
Implementation/DBA Data:	APPS.AK_CUSTOM_REGIONS_VL

View Text

SELECT ACR.ROWID ROW_ID
, ACR.CUSTOMIZATION_APPLICATION_ID
, ACR.CUSTOMIZATION_CODE
, FAV.APPLICATION_SHORT_NAME CUSTOMIZATION_APPL_SHORT_NAME
, FAV.APPLICATION_NAME CUSTOMIZATION_APPL_NAME
, AKCT.NAME CUSTOMIZATION_NAME
, AKCT.DESCRIPTION CUSTOMIZATION_DESCRIPTION
, ACR.REGION_APPLICATION_ID
, ACR.REGION_CODE
, FAV1.APPLICATION_SHORT_NAME REGION_APPL_SHORT_NAME
, FAV1.APPLICATION_NAME REGION_APPL_NAME
, AKRT.NAME REGION_NAME
, AKRT.DESCRIPTION REGION_DESCRIPTION
, ACR.PROPERTY_NAME
, DECODE(ACREG.TRANSLATABLE
, 'Y'
, ACRT.PROPERTY_VARCHAR2_VALUE
, ACR.PROPERTY_VARCHAR2_VALUE) PROPERTY_VARCHAR2_VALUE
, ACR.PROPERTY_NUMBER_VALUE
, ACR.CRITERIA_JOIN_CONDITION
, ACR.CREATED_BY
, ACR.CREATION_DATE
, ACR.LAST_UPDATED_BY
, ACR.LAST_UPDATE_DATE
, ACR.LAST_UPDATE_LOGIN
FROM AK_CUSTOM_REGIONS ACR
, AK_CUSTOM_REGIONS_TL ACRT
, AK_CUSTOM_REGISTRY ACREG
, FND_APPLICATION_VL FAV
, FND_APPLICATION_VL FAV1
, AK_CUSTOMIZATIONS_TL AKCT
, AK_REGIONS_TL AKRT
WHERE FAV.APPLICATION_ID = ACR.CUSTOMIZATION_APPLICATION_ID
AND FAV1.APPLICATION_ID = ACR.REGION_APPLICATION_ID
AND ACR.REGION_APPLICATION_ID = AKCT.REGION_APPLICATION_ID
AND ACR.REGION_CODE = AKCT.REGION_CODE
AND ACR.CUSTOMIZATION_APPLICATION_ID = AKCT.CUSTOMIZATION_APPLICATION_ID
AND ACR.CUSTOMIZATION_CODE = AKCT.CUSTOMIZATION_CODE
AND AKCT.LANGUAGE = USERENV('LANG')
AND ACR.REGION_APPLICATION_ID = AKRT.REGION_APPLICATION_ID
AND ACR.REGION_CODE = AKRT.REGION_CODE
AND AKRT.LANGUAGE = USERENV('LANG')
AND ACR.REGION_APPLICATION_ID = ACRT.REGION_APPLICATION_ID
AND ACR.REGION_CODE = ACRT.REGION_CODE
AND ACR.CUSTOMIZATION_APPLICATION_ID = ACRT.CUSTOMIZATION_APPLICATION_ID
AND ACR.CUSTOMIZATION_CODE = ACRT.CUSTOMIZATION_CODE
AND ACR.PROPERTY_NAME = ACRT.PROPERTY_NAME
AND ACRT.LANGUAGE = USERENV('LANG')
AND ACR.PROPERTY_NAME = ACREG.PROPERTY_NAME(+)
AND ACREG.CUSTOM_LEVEL(+) = 'REGION'

Columns