[Home] [Help]
| Product: | OKC - Contracts Core |
|---|---|
| Description: | Displays all the contracts, with their respective status, category, primary party name and role, and attached documents. Only contracts belonging to Contracts Core (OKC), Sales Contracts (OKO) and Contracts for Procurement (OKP) should be s |
| Implementation/DBA Data: | Not implemented in this database |
SELECT ATT.ATTACHED_DOCUMENT_ID ATTACHED_DOCUMENT_ID
, ATT.DOCUMENT_ID DOCUMENT_ID
, DOC.FILE_NAME ATTACHMENT_NAME
, DOC.MEDIA_ID MEDIA_ID
, CHRB.ID CHR_ID
, CHRB.CONTRACT_NUMBER CHR_NUM
, CHRB.CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER_MODIFIER
, CHRB.TEMPLATE_YN TEMPLATE_YN
, CHRB.CURRENCY_CODE CURRENCY_CODE
, CHRB.DATE_SIGNED DATE_SIGNED
, CHRB.START_DATE START_DATE
, CHRB.END_DATE END_DATE
, CHRB.BUY_OR_SELL INTENT
, CHRB.ESTIMATED_AMOUNT CONTRACT_AMOUNT
, CHRT.SHORT_DESCRIPTION SHORT_DESCRIPTION
, CHRT.COGNOMEN COGNOMEN
, STS.MEANING STATUS_MEANING
, SCL.MEANING SUBCLASS_MEANING
, OKC_UTIL.GET_NAME_FROM_JTFV(CPLB.JTOT_OBJECT1_CODE
, CPLB.OBJECT1_ID1
, CPLB.OBJECT1_ID2) PRIMARY_PARTY_NAME
, OKC_UTIL.DECODE_LOOKUP('OKC_ROLE'
, CPLB.RLE_CODE) PRIMARY_PARTY_ROLE
, OKC_UTIL.GET_K_ACCESS_LEVEL(CHRB.ID
, CHRB.SCS_CODE
, 'W'
, 'FALSE'
, NVL(CHRB.ORIG_SYSTEM_SOURCE_CODE
, 'NOSOURCECODE')) CHR_AL
FROM FND_ATTACHED_DOCUMENTS ATT
, FND_DOCUMENTS_TL DOC
, OKC_K_HEADERS_B CHRB
, OKC_K_HEADERS_TL CHRT
, OKC_K_PARTY_ROLES_B CPLB
, OKC_STATUSES_TL STS
, OKC_SUBCLASSES_TL SCL
WHERE CHRB.ID = CHRT.ID
AND CHRB.APPLICATION_ID IN (510
, 871
, 876
, 515)
AND CHRT.LANGUAGE = USERENV('LANG')
AND STS.CODE = CHRB.STS_CODE
AND STS.LANGUAGE = USERENV('LANG')
AND SCL.CODE = CHRB.SCS_CODE
AND SCL.LANGUAGE = USERENV('LANG')
AND (CPLB.DNZ_CHR_ID(+) = CHRB.ID
AND CPLB.CLE_ID IS NULL)
AND CPLB.PRIMARY_YN(+) = 'Y'
AND ATT.PK1_VALUE(+) = TO_CHAR(CHRB.ID)
AND ATT.ENTITY_NAME(+) LIKE 'OKC\_K\_HEADERS\_%' ESCAPE '\'
AND DOC.DOCUMENT_ID(+) = ATT.DOCUMENT_ID
AND DOC.LANGUAGE(+) = USERENV('LANG')
AND (ATT.PK2_VALUE IS NULL OR OKC_KOL_ATT_UTIL_PUB.GET_MAJOR_VERSION(ATT.PK1_VALUE) = ATT.PK2_VALUE)