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