View: AK_CUSTOMIZATIONS_VL

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

View Text

SELECT AKC.ROWID ROW_ID
, AKC.CUSTOMIZATION_APPLICATION_ID
, AKC.CUSTOMIZATION_CODE
, FAV.APPLICATION_SHORT_NAME CUSTOMIZATION_APPL_SHORT_NAME
, FAV.APPLICATION_NAME CUSTOMIZATION_APPL_NAME
, AKCT.NAME CUSTOMIZATION_NAME
, AKCT.DESCRIPTION CUSTOMIZATION_DESCRIPTION
, AKC.REGION_APPLICATION_ID
, AKC.REGION_CODE
, FAV1.APPLICATION_SHORT_NAME REGION_APPL_SHORT_NAME
, FAV1.APPLICATION_NAME REGION_APPL_NAME
, AKRT.NAME REGION_NAME
, AKRT.DESCRIPTION REGION_DESCRIPTION
, AKC.VERTICALIZATION_ID
, AKC.LOCALIZATION_CODE
, AKC.ORG_ID
, AKC.SITE_ID
, AKC.RESPONSIBILITY_ID
, AKC.WEB_USER_ID
, AKC.REFERENCE_PATH
, AKC.DEFAULT_CUSTOMIZATION_FLAG
, AKC.CUSTOMIZATION_LEVEL_ID
, AKC.CREATED_BY
, AKC.CREATION_DATE
, AKC.LAST_UPDATED_BY
, AKC.LAST_UPDATE_DATE
, AKC.LAST_UPDATE_LOGIN
, AKC.START_DATE_ACTIVE
, AKC.END_DATE_ACTIVE
, AKC.FUNCTION_NAME
, AKC.DEVELOPER_MODE
FROM AK_CUSTOMIZATIONS AKC
, AK_CUSTOMIZATIONS_TL AKCT
, AK_REGIONS_TL AKRT
, FND_APPLICATION_VL FAV
, FND_APPLICATION_VL FAV1
WHERE FAV.APPLICATION_ID = AKC.CUSTOMIZATION_APPLICATION_ID
AND FAV1.APPLICATION_ID = AKC.REGION_APPLICATION_ID
AND AKC.REGION_APPLICATION_ID = AKCT.REGION_APPLICATION_ID
AND AKC.REGION_CODE = AKCT.REGION_CODE
AND AKC.CUSTOMIZATION_APPLICATION_ID = AKCT.CUSTOMIZATION_APPLICATION_ID
AND AKC.CUSTOMIZATION_CODE = AKCT.CUSTOMIZATION_CODE
AND AKCT.LANGUAGE = USERENV('LANG')
AND AKC.REGION_APPLICATION_ID = AKRT.REGION_APPLICATION_ID
AND AKC.REGION_CODE = AKRT.REGION_CODE
AND AKRT.LANGUAGE = USERENV('LANG')

Columns