VIEW: APPS.AK_FLOWS_VL

Source

View Text - Preformatted

SELECT AF.ROWID ROW_ID , AF.FLOW_APPLICATION_ID , FAV.APPLICATION_SHORT_NAME , FAV.APPLICATION_NAME , AF.FLOW_CODE , AFT.NAME , AFT.DESCRIPTION , AF.PRIMARY_PAGE_APPL_ID , AF.PRIMARY_PAGE_CODE , AF.ATTRIBUTE_CATEGORY , AF.ATTRIBUTE1 , AF.ATTRIBUTE2 , AF.ATTRIBUTE3 , AF.ATTRIBUTE4 , AF.ATTRIBUTE5 , AF.ATTRIBUTE6 , AF.ATTRIBUTE7 , AF.ATTRIBUTE8 , AF.ATTRIBUTE9 , AF.ATTRIBUTE10 , AF.ATTRIBUTE11 , AF.ATTRIBUTE12 , AF.ATTRIBUTE13 , AF.ATTRIBUTE14 , AF.ATTRIBUTE15 , AF.CREATED_BY , AF.CREATION_DATE , AF.LAST_UPDATED_BY , AF.LAST_UPDATE_DATE , AF.LAST_UPDATE_LOGIN FROM FND_APPLICATION_VL FAV, AK_FLOWS_TL AFT, AK_FLOWS AF WHERE AF.FLOW_APPLICATION_ID = AFT.FLOW_APPLICATION_ID AND AF.FLOW_CODE = AFT.FLOW_CODE AND AFT.LANGUAGE = USERENV('LANG') AND AF.FLOW_APPLICATION_ID = FAV.APPLICATION_ID

View Text - HTML Formatted

SELECT AF.ROWID ROW_ID
, AF.FLOW_APPLICATION_ID
, FAV.APPLICATION_SHORT_NAME
, FAV.APPLICATION_NAME
, AF.FLOW_CODE
, AFT.NAME
, AFT.DESCRIPTION
, AF.PRIMARY_PAGE_APPL_ID
, AF.PRIMARY_PAGE_CODE
, AF.ATTRIBUTE_CATEGORY
, AF.ATTRIBUTE1
, AF.ATTRIBUTE2
, AF.ATTRIBUTE3
, AF.ATTRIBUTE4
, AF.ATTRIBUTE5
, AF.ATTRIBUTE6
, AF.ATTRIBUTE7
, AF.ATTRIBUTE8
, AF.ATTRIBUTE9
, AF.ATTRIBUTE10
, AF.ATTRIBUTE11
, AF.ATTRIBUTE12
, AF.ATTRIBUTE13
, AF.ATTRIBUTE14
, AF.ATTRIBUTE15
, AF.CREATED_BY
, AF.CREATION_DATE
, AF.LAST_UPDATED_BY
, AF.LAST_UPDATE_DATE
, AF.LAST_UPDATE_LOGIN
FROM FND_APPLICATION_VL FAV
, AK_FLOWS_TL AFT
, AK_FLOWS AF
WHERE AF.FLOW_APPLICATION_ID = AFT.FLOW_APPLICATION_ID
AND AF.FLOW_CODE = AFT.FLOW_CODE
AND AFT.LANGUAGE = USERENV('LANG')
AND AF.FLOW_APPLICATION_ID = FAV.APPLICATION_ID