VIEW: APPS.AK_FLOW_PAGES_VL

Source

View Text - Preformatted

SELECT AFP.ROWID ROW_ID , AFP.FLOW_APPLICATION_ID , AFP.FLOW_CODE , AFP.PAGE_APPLICATION_ID , AFP.PAGE_CODE , AFP.PRIMARY_REGION_APPL_ID , AFP.PRIMARY_REGION_CODE , ART.NAME PRIMARY_REGION_NAME , ART.DESCRIPTION PRIMARY_REGION_DESCRIPTION , AR.DATABASE_OBJECT_NAME , AFPT.NAME , AFPT.DESCRIPTION , AFP.ATTRIBUTE_CATEGORY , AFP.ATTRIBUTE1 , AFP.ATTRIBUTE2 , AFP.ATTRIBUTE3 , AFP.ATTRIBUTE4 , AFP.ATTRIBUTE5 , AFP.ATTRIBUTE6 , AFP.ATTRIBUTE7 , AFP.ATTRIBUTE8 , AFP.ATTRIBUTE9 , AFP.ATTRIBUTE10 , AFP.ATTRIBUTE11 , AFP.ATTRIBUTE12 , AFP.ATTRIBUTE13 , AFP.ATTRIBUTE14 , AFP.ATTRIBUTE15 , AFP.CREATED_BY , AFP.CREATION_DATE , AFP.LAST_UPDATED_BY , AFP.LAST_UPDATE_DATE , AFP.LAST_UPDATE_LOGIN FROM AK_REGIONS_TL ART, AK_REGIONS AR, AK_FLOW_PAGES_TL AFPT, AK_FLOW_PAGES AFP WHERE AFP.FLOW_APPLICATION_ID = AFPT.FLOW_APPLICATION_ID AND AFP.FLOW_CODE = AFPT.FLOW_CODE AND AFP.PAGE_APPLICATION_ID = AFPT.PAGE_APPLICATION_ID AND AFP.PAGE_CODE = AFPT.PAGE_CODE AND AFPT.LANGUAGE = USERENV('LANG') AND AR.REGION_APPLICATION_ID(+) = AFP.PRIMARY_REGION_APPL_ID AND AR.REGION_CODE(+) = AFP.PRIMARY_REGION_CODE AND ART.REGION_APPLICATION_ID(+) = AFP.PRIMARY_REGION_APPL_ID AND ART.REGION_CODE(+) = AFP.PRIMARY_REGION_CODE AND ART.LANGUAGE(+) = USERENV('LANG')

View Text - HTML Formatted

SELECT AFP.ROWID ROW_ID
, AFP.FLOW_APPLICATION_ID
, AFP.FLOW_CODE
, AFP.PAGE_APPLICATION_ID
, AFP.PAGE_CODE
, AFP.PRIMARY_REGION_APPL_ID
, AFP.PRIMARY_REGION_CODE
, ART.NAME PRIMARY_REGION_NAME
, ART.DESCRIPTION PRIMARY_REGION_DESCRIPTION
, AR.DATABASE_OBJECT_NAME
, AFPT.NAME
, AFPT.DESCRIPTION
, AFP.ATTRIBUTE_CATEGORY
, AFP.ATTRIBUTE1
, AFP.ATTRIBUTE2
, AFP.ATTRIBUTE3
, AFP.ATTRIBUTE4
, AFP.ATTRIBUTE5
, AFP.ATTRIBUTE6
, AFP.ATTRIBUTE7
, AFP.ATTRIBUTE8
, AFP.ATTRIBUTE9
, AFP.ATTRIBUTE10
, AFP.ATTRIBUTE11
, AFP.ATTRIBUTE12
, AFP.ATTRIBUTE13
, AFP.ATTRIBUTE14
, AFP.ATTRIBUTE15
, AFP.CREATED_BY
, AFP.CREATION_DATE
, AFP.LAST_UPDATED_BY
, AFP.LAST_UPDATE_DATE
, AFP.LAST_UPDATE_LOGIN
FROM AK_REGIONS_TL ART
, AK_REGIONS AR
, AK_FLOW_PAGES_TL AFPT
, AK_FLOW_PAGES AFP
WHERE AFP.FLOW_APPLICATION_ID = AFPT.FLOW_APPLICATION_ID
AND AFP.FLOW_CODE = AFPT.FLOW_CODE
AND AFP.PAGE_APPLICATION_ID = AFPT.PAGE_APPLICATION_ID
AND AFP.PAGE_CODE = AFPT.PAGE_CODE
AND AFPT.LANGUAGE = USERENV('LANG')
AND AR.REGION_APPLICATION_ID(+) = AFP.PRIMARY_REGION_APPL_ID
AND AR.REGION_CODE(+) = AFP.PRIMARY_REGION_CODE
AND ART.REGION_APPLICATION_ID(+) = AFP.PRIMARY_REGION_APPL_ID
AND ART.REGION_CODE(+) = AFP.PRIMARY_REGION_CODE
AND ART.LANGUAGE(+) = USERENV('LANG')