Product: | OKC - Contracts Core |
---|---|
Description: | This view lists contract attachments belonging to a business document type. |
Implementation/DBA Data: | APPS.OKC_CONTRACT_DOCS_DETAILS_VL |
SELECT KDOC.ROWID
, KDOC.BUSINESS_DOCUMENT_TYPE
, KDOC.BUSINESS_DOCUMENT_ID
, KDOC.BUSINESS_DOCUMENT_VERSION
, KDOC.ATTACHED_DOCUMENT_ID
, KDOC.EXTERNAL_VISIBILITY_FLAG
, KDOC.EFFECTIVE_FROM_TYPE
, KDOC.EFFECTIVE_FROM_ID
, KDOC.EFFECTIVE_FROM_VERSION
, KDOC.PARENT_ATTACHED_DOC_ID
, KDOC.INCLUDE_FOR_APPROVAL_FLAG
, KDOC.PRIMARY_CONTRACT_DOC_FLAG
, KDOC.MERGEABLE_DOC_FLAG
, KDOC.GENERATED_FLAG
, KDOC.DELETE_FLAG
, KDOC.OBJECT_VERSION_NUMBER
, KDOC.CREATED_BY
, KDOC.CREATION_DATE
, KDOC.LAST_UPDATED_BY
, KDOC.LAST_UPDATE_DATE
, KDOC.LAST_UPDATE_LOGIN
, KDOC.PROGRAM_ID
, KDOC.PROGRAM_APPLICATION_ID
, KDOC.REQUEST_ID
, FDCT.CATEGORY_ID
, FDCT.NAME
, FDCT.USER_NAME
, FDOT.DESCRIPTION
, DECODE(FDOB.DATATYPE_ID
, 5
, FDOB.URL
, 6
, FDOB.FILE_NAME)
, FDOB.MEDIA_ID
, FADB.ENTITY_NAME
, FADB.PK1_VALUE
, FADB.PK2_VALUE
, FADB.PK3_VALUE
, FADB.PK4_VALUE
, FADB.PK5_VALUE
, FDOB.DATATYPE_ID
, FDDB.NAME
, DECODE(KDOC.BUSINESS_DOCUMENT_VERSION - KDOC.EFFECTIVE_FROM_VERSION
, 0
, 'UPDATEENABLED'
, 'UPDATEDISABLED')
FROM FND_DOCUMENT_DATATYPES FDDB
, FND_ATTACHED_DOCUMENTS FADB
, FND_DOCUMENTS FDOB
, FND_DOCUMENTS_TL FDOT
, FND_DOCUMENT_CATEGORIES_TL FDCT
, OKC_CONTRACT_DOCS KDOC
WHERE KDOC.ATTACHED_DOCUMENT_ID = FADB.ATTACHED_DOCUMENT_ID
AND FDOB.DOCUMENT_ID = FADB.DOCUMENT_ID
AND FDOT.DOCUMENT_ID = FDOB.DOCUMENT_ID
AND FDOT.LANGUAGE = USERENV('LANG')
AND FDCT.CATEGORY_ID = FDOB.CATEGORY_ID
AND FDCT.LANGUAGE = USERENV('LANG')
AND FDDB.DATATYPE_ID = FDOB.DATATYPE_ID
AND FDDB.LANGUAGE = USERENV('LANG')