View: AHL_DOC_FILE_ASSOC_V

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	This view defintion stores the File uploaded with Document ID and Revision
Implementation/DBA Data:	APPS.AHL_DOC_FILE_ASSOC_V

View Text

SELECT ADB.ASSOCIATION_ID
, ADB.FILE_ID
, ADB.FILE_NAME
, ADB.REVISION_ID
, ADB.DATATYPE_CODE
, FND.MEANING
, ADB.FILE_DESC
, ADB.ATTRIBUTE_CATEGORY
, ADB.ATTRIBUTE1
, ADB.ATTRIBUTE2
, ADB.ATTRIBUTE3
, ADB.ATTRIBUTE4
, ADB.ATTRIBUTE5
, ADB.ATTRIBUTE6
, ADB.ATTRIBUTE7
, ADB.ATTRIBUTE8
, ADB.ATTRIBUTE9
, ADB.ATTRIBUTE10
, ADB.ATTRIBUTE11
, ADB.ATTRIBUTE12
, ADB.ATTRIBUTE13
, ADB.ATTRIBUTE14
, ADB.ATTRIBUTE15
FROM AHL_DOC_FILE_ASSOC_VL ADB
, FND_LOOKUP_VALUES_VL FND
WHERE FND.LOOKUP_CODE (+)=ADB.DATATYPE_CODE
AND FND.LOOKUP_TYPE (+)= 'AHL_DI_UPLOAD_FILE_TYPE'

Columns