VIEW: APPS.AK_CUSTOM_REGIONS_VL

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'