Product: | AK - Common Modules-AK |
---|---|
Description: | 10SC ONLY |
Implementation/DBA Data: | APPS.AK_FLOW_PAGE_REGIONS_V |
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')