VIEW: APPS.AK_FLOW_PAGE_REGION_ITEMS_V

Source

View Text - Preformatted

SELECT AP.ROWID ROW_ID , AP.FLOW_APPLICATION_ID , AP.FLOW_CODE , AP.PAGE_APPLICATION_ID , AP.PAGE_CODE , APT1.NAME PAGE_NAME , APT1.DESCRIPTION PAGE_DESCRIPTION , AP.REGION_APPLICATION_ID , AP.REGION_CODE , ART1.NAME REGION_NAME , ART1.DESCRIPTION REGION_DESCRIPTION , AP.ATTRIBUTE_APPLICATION_ID , AP.ATTRIBUTE_CODE , AAT1.NAME ATTRIBUTE_NAME , AAT1.DESCRIPTION ATTRIBUTE_DESCRIPTION , AP.TO_PAGE_APPL_ID , AP.TO_PAGE_CODE , APT2.NAME TO_PAGE_NAME , APT2.DESCRIPTION TO_PAGE_DESCRIPTION , AP.TO_URL_ATTRIBUTE_APPL_ID , AP.TO_URL_ATTRIBUTE_CODE , AAT2.NAME TO_ATTRIBUTE_NAME , AAT2.DESCRIPTION TO_ATTRIBUTE_DESCRIPTION , AP.ATTRIBUTE_CATEGORY , AP.ATTRIBUTE1 , AP.ATTRIBUTE2 , AP.ATTRIBUTE3 , AP.ATTRIBUTE4 , AP.ATTRIBUTE5 , AP.ATTRIBUTE6 , AP.ATTRIBUTE7 , AP.ATTRIBUTE8 , AP.ATTRIBUTE9 , AP.ATTRIBUTE10 , AP.ATTRIBUTE11 , AP.ATTRIBUTE12 , AP.ATTRIBUTE13 , AP.ATTRIBUTE14 , AP.ATTRIBUTE15 , AP.CREATED_BY , AP.CREATION_DATE , AP.LAST_UPDATED_BY , AP.LAST_UPDATE_DATE , AP.LAST_UPDATE_LOGIN FROM AK_FLOW_PAGES_TL APT1, AK_FLOW_PAGES_TL APT2, AK_REGIONS_TL ART1, AK_ATTRIBUTES_TL AAT2, AK_ATTRIBUTES_TL AAT1, AK_FLOW_PAGE_REGION_ITEMS AP WHERE AP.REGION_APPLICATION_ID = ART1.REGION_APPLICATION_ID AND AP.REGION_CODE = ART1.REGION_CODE AND ART1.LANGUAGE =USERENV('LANG') AND AP.FLOW_APPLICATION_ID = APT1.FLOW_APPLICATION_ID AND AP.FLOW_CODE = APT1.FLOW_CODE AND AP.PAGE_APPLICATION_ID = APT1.PAGE_APPLICATION_ID AND AP.PAGE_CODE = APT1.PAGE_CODE AND APT1.LANGUAGE = USERENV('LANG') AND AP.FLOW_APPLICATION_ID = APT2.FLOW_APPLICATION_ID(+) AND AP.FLOW_CODE = APT2.FLOW_CODE(+) AND AP.TO_PAGE_APPL_ID = APT2.PAGE_APPLICATION_ID(+) AND AP.TO_PAGE_CODE = APT2.PAGE_CODE(+) AND APT2.LANGUAGE(+) = USERENV('LANG') AND AP.ATTRIBUTE_APPLICATION_ID = AAT1.ATTRIBUTE_APPLICATION_ID AND AP.ATTRIBUTE_CODE = AAT1.ATTRIBUTE_CODE AND AAT1.LANGUAGE = USERENV('LANG') AND AP.TO_URL_ATTRIBUTE_APPL_ID = AAT2.ATTRIBUTE_APPLICATION_ID(+) AND AP.TO_URL_ATTRIBUTE_CODE = AAT2.ATTRIBUTE_CODE(+) AND AAT2.LANGUAGE(+) = USERENV('LANG')

View Text - HTML Formatted

SELECT AP.ROWID ROW_ID
, AP.FLOW_APPLICATION_ID
, AP.FLOW_CODE
, AP.PAGE_APPLICATION_ID
, AP.PAGE_CODE
, APT1.NAME PAGE_NAME
, APT1.DESCRIPTION PAGE_DESCRIPTION
, AP.REGION_APPLICATION_ID
, AP.REGION_CODE
, ART1.NAME REGION_NAME
, ART1.DESCRIPTION REGION_DESCRIPTION
, AP.ATTRIBUTE_APPLICATION_ID
, AP.ATTRIBUTE_CODE
, AAT1.NAME ATTRIBUTE_NAME
, AAT1.DESCRIPTION ATTRIBUTE_DESCRIPTION
, AP.TO_PAGE_APPL_ID
, AP.TO_PAGE_CODE
, APT2.NAME TO_PAGE_NAME
, APT2.DESCRIPTION TO_PAGE_DESCRIPTION
, AP.TO_URL_ATTRIBUTE_APPL_ID
, AP.TO_URL_ATTRIBUTE_CODE
, AAT2.NAME TO_ATTRIBUTE_NAME
, AAT2.DESCRIPTION TO_ATTRIBUTE_DESCRIPTION
, AP.ATTRIBUTE_CATEGORY
, AP.ATTRIBUTE1
, AP.ATTRIBUTE2
, AP.ATTRIBUTE3
, AP.ATTRIBUTE4
, AP.ATTRIBUTE5
, AP.ATTRIBUTE6
, AP.ATTRIBUTE7
, AP.ATTRIBUTE8
, AP.ATTRIBUTE9
, AP.ATTRIBUTE10
, AP.ATTRIBUTE11
, AP.ATTRIBUTE12
, AP.ATTRIBUTE13
, AP.ATTRIBUTE14
, AP.ATTRIBUTE15
, AP.CREATED_BY
, AP.CREATION_DATE
, AP.LAST_UPDATED_BY
, AP.LAST_UPDATE_DATE
, AP.LAST_UPDATE_LOGIN
FROM AK_FLOW_PAGES_TL APT1
, AK_FLOW_PAGES_TL APT2
, AK_REGIONS_TL ART1
, AK_ATTRIBUTES_TL AAT2
, AK_ATTRIBUTES_TL AAT1
, AK_FLOW_PAGE_REGION_ITEMS AP
WHERE AP.REGION_APPLICATION_ID = ART1.REGION_APPLICATION_ID
AND AP.REGION_CODE = ART1.REGION_CODE
AND ART1.LANGUAGE =USERENV('LANG')
AND AP.FLOW_APPLICATION_ID = APT1.FLOW_APPLICATION_ID
AND AP.FLOW_CODE = APT1.FLOW_CODE
AND AP.PAGE_APPLICATION_ID = APT1.PAGE_APPLICATION_ID
AND AP.PAGE_CODE = APT1.PAGE_CODE
AND APT1.LANGUAGE = USERENV('LANG')
AND AP.FLOW_APPLICATION_ID = APT2.FLOW_APPLICATION_ID(+)
AND AP.FLOW_CODE = APT2.FLOW_CODE(+)
AND AP.TO_PAGE_APPL_ID = APT2.PAGE_APPLICATION_ID(+)
AND AP.TO_PAGE_CODE = APT2.PAGE_CODE(+)
AND APT2.LANGUAGE(+) = USERENV('LANG')
AND AP.ATTRIBUTE_APPLICATION_ID = AAT1.ATTRIBUTE_APPLICATION_ID
AND AP.ATTRIBUTE_CODE = AAT1.ATTRIBUTE_CODE
AND AAT1.LANGUAGE = USERENV('LANG')
AND AP.TO_URL_ATTRIBUTE_APPL_ID = AAT2.ATTRIBUTE_APPLICATION_ID(+)
AND AP.TO_URL_ATTRIBUTE_CODE = AAT2.ATTRIBUTE_CODE(+)
AND AAT2.LANGUAGE(+) = USERENV('LANG')