View: AK_FLOW_REGION_RELATIONS_V

Product:	AK - Common Modules-AK
Description:	10SC ONLY
Implementation/DBA Data:	APPS.AK_FLOW_REGION_RELATIONS_V

View Text

SELECT AFR.ROWID ROW_ID
, AFR.FLOW_APPLICATION_ID
, AFR.FLOW_CODE
, DECODE(AFK.DATABASE_OBJECT_NAME
, AR2.DATABASE_OBJECT_NAME
, AFKT.FROM_TO_NAME
, AR1.DATABASE_OBJECT_NAME
, AFKT.TO_FROM_NAME
, AFKT.FROM_TO_NAME) FROM_TO_NAME
, DECODE(AFK.DATABASE_OBJECT_NAME
, AR2.DATABASE_OBJECT_NAME
, AFKT.FROM_TO_DESCRIPTION
, AR1.DATABASE_OBJECT_NAME
, AFKT.TO_FROM_DESCRIPTION
, AFKT.FROM_TO_DESCRIPTION) FROM_TO_DESCRIPTION
, AFR.FOREIGN_KEY_NAME
, AFR.FROM_PAGE_APPL_ID
, AFR.FROM_PAGE_CODE
, APT1.NAME FROM_PAGE_NAME
, AFR.TO_PAGE_APPL_ID
, AFR.TO_PAGE_CODE
, APT2.NAME TO_PAGE_NAME
, AFR.FROM_REGION_APPL_ID
, AFR.FROM_REGION_CODE
, ART1.NAME FROM_REGION_NAME
, AR1.DATABASE_OBJECT_NAME FROM_DATABASE_OBJECT_NAME
, AR1.REGION_STYLE FROM_REGION_STYLE
, AFR.TO_REGION_APPL_ID
, AFR.TO_REGION_CODE
, ART2.NAME TO_REGION_NAME
, AR2.DATABASE_OBJECT_NAME TO_DATABASE_OBJECT_NAME
, AR2.REGION_STYLE TO_REGION_STYLE
, AFR.APPLICATION_ID
, AFR.ATTRIBUTE_CATEGORY
, AFR.ATTRIBUTE1
, AFR.ATTRIBUTE2
, AFR.ATTRIBUTE3
, AFR.ATTRIBUTE4
, AFR.ATTRIBUTE5
, AFR.ATTRIBUTE6
, AFR.ATTRIBUTE7
, AFR.ATTRIBUTE8
, AFR.ATTRIBUTE9
, AFR.ATTRIBUTE10
, AFR.ATTRIBUTE11
, AFR.ATTRIBUTE12
, AFR.ATTRIBUTE13
, AFR.ATTRIBUTE14
, AFR.ATTRIBUTE15
, AFR.CREATED_BY
, AFR.CREATION_DATE
, AFR.LAST_UPDATED_BY
, AFR.LAST_UPDATE_DATE
, AFR.LAST_UPDATE_LOGIN
FROM AK_FLOW_PAGES_TL APT1
, AK_FLOW_PAGES_TL APT2
, AK_REGIONS_TL ART1
, AK_REGIONS AR1
, AK_REGIONS_TL ART2
, AK_REGIONS AR2
, AK_FOREIGN_KEYS_TL AFKT
, AK_FOREIGN_KEYS AFK
, AK_FLOW_REGION_RELATIONS AFR
WHERE APT1.FLOW_APPLICATION_ID = AFR.FLOW_APPLICATION_ID
AND APT1.FLOW_CODE = AFR.FLOW_CODE
AND APT1.PAGE_APPLICATION_ID = AFR.FROM_PAGE_APPL_ID
AND APT1.PAGE_CODE = AFR.FROM_PAGE_CODE
AND APT1.LANGUAGE = USERENV('LANG')
AND APT2.FLOW_APPLICATION_ID = AFR.FLOW_APPLICATION_ID
AND APT2.FLOW_CODE = AFR.FLOW_CODE
AND APT2.PAGE_APPLICATION_ID = AFR.TO_PAGE_APPL_ID
AND APT2.PAGE_CODE = AFR.TO_PAGE_CODE
AND APT2.LANGUAGE = USERENV('LANG')
AND AR1.REGION_APPLICATION_ID = AFR.FROM_REGION_APPL_ID
AND AR1.REGION_CODE = AFR.FROM_REGION_CODE
AND ART1.REGION_APPLICATION_ID = AFR.FROM_REGION_APPL_ID
AND ART1.REGION_CODE = AFR.FROM_REGION_CODE
AND ART1.LANGUAGE = USERENV('LANG')
AND AR2.REGION_APPLICATION_ID(+) = AFR.TO_REGION_APPL_ID
AND AR2.REGION_CODE(+) = AFR.TO_REGION_CODE
AND ART2.REGION_APPLICATION_ID(+) = AFR.TO_REGION_APPL_ID
AND ART2.REGION_CODE(+) = AFR.TO_REGION_CODE
AND ART2.LANGUAGE(+) = USERENV('LANG')
AND AFK.FOREIGN_KEY_NAME = AFR.FOREIGN_KEY_NAME
AND AFKT.FOREIGN_KEY_NAME = AFR.FOREIGN_KEY_NAME
AND AFKT.LANGUAGE = USERENV('LANG')

Columns