VIEW: APPS.OKC_CONTRACT_DOCS_DETAILS_VL

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')