VIEW: APPS.AK_FLOW_REGION_RELATIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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