VIEW: APPS.AK_CUSTOMIZATIONS_VL

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')