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