VIEW: APPS.AK_FLOW_PAGE_REGIONS_V

Source

View Text - Preformatted

SELECT AFPR.ROWID ROW_ID , AFPR.FLOW_APPLICATION_ID , AFPR.FLOW_CODE , AFPR.PAGE_APPLICATION_ID , AFPR.PAGE_CODE , AFPT.NAME PAGE_NAME , AFPT.DESCRIPTION PAGE_DESCRIPTION , AFPR.REGION_APPLICATION_ID , AFPR.REGION_CODE , ART1.NAME REGION_NAME , ART1.DESCRIPTION REGION_DESCRIPTION , AR1.DATABASE_OBJECT_NAME , AFPR.DISPLAY_SEQUENCE , AFPR.REGION_STYLE , AFPR.NUM_COLUMNS , AFPR.ICX_CUSTOM_CALL , AFPR.PARENT_REGION_APPLICATION_ID , AFPR.PARENT_REGION_CODE , ART2.NAME PARENT_REGION_NAME , ART2.DESCRIPTION PARENT_REGION_DESCRIPTION , AR2.DATABASE_OBJECT_NAME PARENT_DATABASE_OBJECT_NAME , decode(AFK.DATABASE_OBJECT_NAME, AR1.DATABASE_OBJECT_NAME, AFKT.FROM_TO_NAME, AR2.DATABASE_OBJECT_NAME, AFKT.TO_FROM_NAME, null, null, AFKT.FROM_TO_NAME) FROM_TO_NAME , decode(AFK.DATABASE_OBJECT_NAME, AR1.DATABASE_OBJECT_NAME, AFKT.FROM_TO_DESCRIPTION, AR2.DATABASE_OBJECT_NAME, AFKT.TO_FROM_DESCRIPTION, null, null, AFKT.FROM_TO_DESCRIPTION) FROM_TO_DESCRIPTION , AFRR.FOREIGN_KEY_NAME , AFRR.APPLICATION_ID , AFPR.ATTRIBUTE_CATEGORY , AFPR.ATTRIBUTE1 , AFPR.ATTRIBUTE2 , AFPR.ATTRIBUTE3 , AFPR.ATTRIBUTE4 , AFPR.ATTRIBUTE5 , AFPR.ATTRIBUTE6 , AFPR.ATTRIBUTE7 , AFPR.ATTRIBUTE8 , AFPR.ATTRIBUTE9 , AFPR.ATTRIBUTE10 , AFPR.ATTRIBUTE11 , AFPR.ATTRIBUTE12 , AFPR.ATTRIBUTE13 , AFPR.ATTRIBUTE14 , AFPR.ATTRIBUTE15 , AFPR.CREATED_BY , AFPR.CREATION_DATE , AFPR.LAST_UPDATED_BY , AFPR.LAST_UPDATE_DATE , AFPR.LAST_UPDATE_LOGIN FROM AK_REGIONS AR1, AK_REGIONS_TL ART1, AK_REGIONS AR2, AK_REGIONS_TL ART2, AK_FLOW_PAGES_TL AFPT, AK_FOREIGN_KEYS_TL AFKT, AK_FOREIGN_KEYS AFK, AK_FLOW_REGION_RELATIONS AFRR, AK_FLOW_PAGE_REGIONS AFPR WHERE AFPR.REGION_APPLICATION_ID = AR1.REGION_APPLICATION_ID AND AFPR.REGION_CODE = AR1.REGION_CODE AND AFPR.REGION_APPLICATION_ID = ART1.REGION_APPLICATION_ID AND AFPR.REGION_CODE = ART1.REGION_CODE AND ART1.LANGUAGE = USERENV('LANG') AND AFPR.PARENT_REGION_APPLICATION_ID = AR2.REGION_APPLICATION_ID(+) AND AFPR.PARENT_REGION_CODE = AR2.REGION_CODE(+) AND AFPR.PARENT_REGION_APPLICATION_ID = ART2.REGION_APPLICATION_ID(+) AND AFPR.PARENT_REGION_CODE = ART2.REGION_CODE(+) AND ART2.LANGUAGE (+) = USERENV('LANG') AND AFPR.FLOW_APPLICATION_ID = AFPT.FLOW_APPLICATION_ID AND AFPR.FLOW_CODE = AFPT.FLOW_CODE AND AFPR.PAGE_APPLICATION_ID = AFPT.PAGE_APPLICATION_ID AND AFPR.PAGE_CODE = AFPT.PAGE_CODE AND AFPT.LANGUAGE = USERENV('LANG') AND AFPR.FLOW_APPLICATION_ID = AFRR.FLOW_APPLICATION_ID(+) AND AFPR.FLOW_CODE = AFRR.FLOW_CODE(+) AND AFPR.PAGE_APPLICATION_ID = AFRR.FROM_PAGE_APPL_ID(+) AND AFPR.PAGE_CODE = AFRR.FROM_PAGE_CODE(+) AND AFPR.PAGE_APPLICATION_ID = AFRR.TO_PAGE_APPL_ID(+) AND AFPR.PAGE_CODE = AFRR.TO_PAGE_CODE(+) AND AFPR.REGION_APPLICATION_ID = AFRR.TO_REGION_APPL_ID(+) AND AFPR.REGION_CODE = AFRR.TO_REGION_CODE(+) AND AFPR.PARENT_REGION_APPLICATION_ID = AFRR.FROM_REGION_APPL_ID(+) AND AFPR.PARENT_REGION_CODE = AFRR.FROM_REGION_CODE(+) AND AFRR.FOREIGN_KEY_NAME = AFK.FOREIGN_KEY_NAME(+) AND AFRR.FOREIGN_KEY_NAME = AFKT.FOREIGN_KEY_NAME(+) AND AFKT.LANGUAGE(+) = USERENV('LANG')

View Text - HTML Formatted

SELECT AFPR.ROWID ROW_ID
, AFPR.FLOW_APPLICATION_ID
, AFPR.FLOW_CODE
, AFPR.PAGE_APPLICATION_ID
, AFPR.PAGE_CODE
, AFPT.NAME PAGE_NAME
, AFPT.DESCRIPTION PAGE_DESCRIPTION
, AFPR.REGION_APPLICATION_ID
, AFPR.REGION_CODE
, ART1.NAME REGION_NAME
, ART1.DESCRIPTION REGION_DESCRIPTION
, AR1.DATABASE_OBJECT_NAME
, AFPR.DISPLAY_SEQUENCE
, AFPR.REGION_STYLE
, AFPR.NUM_COLUMNS
, AFPR.ICX_CUSTOM_CALL
, AFPR.PARENT_REGION_APPLICATION_ID
, AFPR.PARENT_REGION_CODE
, ART2.NAME PARENT_REGION_NAME
, ART2.DESCRIPTION PARENT_REGION_DESCRIPTION
, AR2.DATABASE_OBJECT_NAME PARENT_DATABASE_OBJECT_NAME
, DECODE(AFK.DATABASE_OBJECT_NAME
, AR1.DATABASE_OBJECT_NAME
, AFKT.FROM_TO_NAME
, AR2.DATABASE_OBJECT_NAME
, AFKT.TO_FROM_NAME
, NULL
, NULL
, AFKT.FROM_TO_NAME) FROM_TO_NAME
, DECODE(AFK.DATABASE_OBJECT_NAME
, AR1.DATABASE_OBJECT_NAME
, AFKT.FROM_TO_DESCRIPTION
, AR2.DATABASE_OBJECT_NAME
, AFKT.TO_FROM_DESCRIPTION
, NULL
, NULL
, AFKT.FROM_TO_DESCRIPTION) FROM_TO_DESCRIPTION
, AFRR.FOREIGN_KEY_NAME
, AFRR.APPLICATION_ID
, AFPR.ATTRIBUTE_CATEGORY
, AFPR.ATTRIBUTE1
, AFPR.ATTRIBUTE2
, AFPR.ATTRIBUTE3
, AFPR.ATTRIBUTE4
, AFPR.ATTRIBUTE5
, AFPR.ATTRIBUTE6
, AFPR.ATTRIBUTE7
, AFPR.ATTRIBUTE8
, AFPR.ATTRIBUTE9
, AFPR.ATTRIBUTE10
, AFPR.ATTRIBUTE11
, AFPR.ATTRIBUTE12
, AFPR.ATTRIBUTE13
, AFPR.ATTRIBUTE14
, AFPR.ATTRIBUTE15
, AFPR.CREATED_BY
, AFPR.CREATION_DATE
, AFPR.LAST_UPDATED_BY
, AFPR.LAST_UPDATE_DATE
, AFPR.LAST_UPDATE_LOGIN
FROM AK_REGIONS AR1
, AK_REGIONS_TL ART1
, AK_REGIONS AR2
, AK_REGIONS_TL ART2
, AK_FLOW_PAGES_TL AFPT
, AK_FOREIGN_KEYS_TL AFKT
, AK_FOREIGN_KEYS AFK
, AK_FLOW_REGION_RELATIONS AFRR
, AK_FLOW_PAGE_REGIONS AFPR
WHERE AFPR.REGION_APPLICATION_ID = AR1.REGION_APPLICATION_ID
AND AFPR.REGION_CODE = AR1.REGION_CODE
AND AFPR.REGION_APPLICATION_ID = ART1.REGION_APPLICATION_ID
AND AFPR.REGION_CODE = ART1.REGION_CODE
AND ART1.LANGUAGE = USERENV('LANG')
AND AFPR.PARENT_REGION_APPLICATION_ID = AR2.REGION_APPLICATION_ID(+)
AND AFPR.PARENT_REGION_CODE = AR2.REGION_CODE(+)
AND AFPR.PARENT_REGION_APPLICATION_ID = ART2.REGION_APPLICATION_ID(+)
AND AFPR.PARENT_REGION_CODE = ART2.REGION_CODE(+)
AND ART2.LANGUAGE (+) = USERENV('LANG')
AND AFPR.FLOW_APPLICATION_ID = AFPT.FLOW_APPLICATION_ID
AND AFPR.FLOW_CODE = AFPT.FLOW_CODE
AND AFPR.PAGE_APPLICATION_ID = AFPT.PAGE_APPLICATION_ID
AND AFPR.PAGE_CODE = AFPT.PAGE_CODE
AND AFPT.LANGUAGE = USERENV('LANG')
AND AFPR.FLOW_APPLICATION_ID = AFRR.FLOW_APPLICATION_ID(+)
AND AFPR.FLOW_CODE = AFRR.FLOW_CODE(+)
AND AFPR.PAGE_APPLICATION_ID = AFRR.FROM_PAGE_APPL_ID(+)
AND AFPR.PAGE_CODE = AFRR.FROM_PAGE_CODE(+)
AND AFPR.PAGE_APPLICATION_ID = AFRR.TO_PAGE_APPL_ID(+)
AND AFPR.PAGE_CODE = AFRR.TO_PAGE_CODE(+)
AND AFPR.REGION_APPLICATION_ID = AFRR.TO_REGION_APPL_ID(+)
AND AFPR.REGION_CODE = AFRR.TO_REGION_CODE(+)
AND AFPR.PARENT_REGION_APPLICATION_ID = AFRR.FROM_REGION_APPL_ID(+)
AND AFPR.PARENT_REGION_CODE = AFRR.FROM_REGION_CODE(+)
AND AFRR.FOREIGN_KEY_NAME = AFK.FOREIGN_KEY_NAME(+)
AND AFRR.FOREIGN_KEY_NAME = AFKT.FOREIGN_KEY_NAME(+)
AND AFKT.LANGUAGE(+) = USERENV('LANG')