View: OKC_GOVERNING_CONTRACT_V

Product:	OKC - Contracts Core
Description:	This view contains the hierarchy of the sales contracts. This view has been obsoleted
Implementation/DBA Data:	APPS.OKC_GOVERNING_CONTRACT_V

View Text

SELECT DISTINCT CHRB.ROWID ROW_ID
, CHRB.ID ID
, CHRB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CHRB.INV_ORGANIZATION_ID INV_ORGANIZATION_ID
, CHRB.STS_CODE STS_CODE
, CHRB.SCS_CODE SCS_CODE
, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER
, CHRB.CURRENCY_CODE CURRENCY_CODE
, CHRB.CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER_MODIFIER
, CHRT.SHORT_DESCRIPTION SHORT_DESCRIPTION
, CHRT.COMMENTS COMMENTS
, CHRT.DESCRIPTION DESCRIPTION
, ( SELECT OBJECT1_ID1
FROM OKC_RULES_B RUL
, OKC_RULE_GROUPS_B RGP
WHERE RUL.RGP_ID = RGP.ID
AND RGP.RGD_CODE ='BILLING'
AND RUL.RULE_INFORMATION_CATEGORY ='CAN'
AND RGP.DNZ_CHR_ID = CHRB.ID
AND RGP.CHR_ID IS NOT NULL ) CUSTOMER_ACCOUNT_ID
, CHRB.TEMPLATE_YN TEMPLATE_YN
, CHRB.GOVERNING_CONTRACT_YN GOVERNING_CONTRACT_YN
, CHRB.TEMPLATE_USED TEMPLATE_USED
, CHRB.DATE_APPROVED DATE_APPROVED
, CHRB.DATETIME_CANCELLED DATETIME_CANCELLED
, CHRB.AUTO_RENEW_DAYS AUTO_RENEW_DAYS
, CHRB.DATE_ISSUED DATE_ISSUED
, CHRB.CHR_TYPE CHR_TYPE
, CHRB.DATE_SIGNED DATE_SIGNED
, CHRB.DATE_TERMINATED DATE_TERMINATED
, CHRB.DATE_RENEWED DATE_RENEWED
, CHRB.TRN_CODE TRN_CODE
, CHRB.START_DATE START_DATE
, CHRB.END_DATE END_DATE
, CHRB.AUTHORING_ORG_ID AUTHORING_ORG_ID
, CHRB.BUY_OR_SELL BUY_OR_SELL
, CHRB.ISSUE_OR_RECEIVE ISSUE_OR_RECEIVE
, CHRB.ESTIMATED_AMOUNT ESTIMATED_AMOUNT
, CHRB.CHR_ID_RENEWED_TO CHR_ID_RENEWED_TO
, CHRB.ESTIMATED_AMOUNT_RENEWED ESTIMATED_AMOUNT_RENEWED
, CHRB.CURRENCY_CODE_RENEWED CURRENCY_CODE_RENEWED
, OKC_UTIL.GET_K_ACCESS_LEVEL(CHRB.ID
, CHRB.SCS_CODE) USER_ACCESS_LEVEL
, CHRB.UPG_ORIG_SYSTEM_REF UPG_ORIG_SYSTEM_REF
, CHRB.UPG_ORIG_SYSTEM_REF_ID UPG_ORIG_SYSTEM_REF_ID
, CHRB.APPLICATION_ID APPLICATION_ID
, CHRB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CHRB.ATTRIBUTE1 ATTRIBUTE1
, CHRB.ATTRIBUTE2 ATTRIBUTE2
, CHRB.ATTRIBUTE3 ATTRIBUTE3
, CHRB.ATTRIBUTE4 ATTRIBUTE4
, CHRB.ATTRIBUTE5 ATTRIBUTE5
, CHRB.ATTRIBUTE6 ATTRIBUTE6
, CHRB.ATTRIBUTE7 ATTRIBUTE7
, CHRB.ATTRIBUTE8 ATTRIBUTE8
, CHRB.ATTRIBUTE9 ATTRIBUTE9
, CHRB.ATTRIBUTE10 ATTRIBUTE10
, CHRB.ATTRIBUTE11 ATTRIBUTE11
, CHRB.ATTRIBUTE12 ATTRIBUTE12
, CHRB.ATTRIBUTE13 ATTRIBUTE13
, CHRB.ATTRIBUTE14 ATTRIBUTE14
, CHRB.ATTRIBUTE15 ATTRIBUTE15
, CHRB.CREATED_BY CREATED_BY
, CHRB.CREATION_DATE CREATION_DATE
, CHRB.LAST_UPDATED_BY LAST_UPDATED_BY
, CHRB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CHRB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CHRB.ORIG_SYSTEM_SOURCE_CODE
, CHRB.ORIG_SYSTEM_ID1
, CHRB.ORIG_SYSTEM_REFERENCE1
, CHRB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, CHRB.PROGRAM_ID PROGRAM_ID
, CHRB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CHRB.REQUEST_ID REQUEST_ID
, CHRB.PRICE_LIST_ID PRICE_LIST_ID
, CHRB.PRICING_DATE PRICING_DATE
, CHRB.TOTAL_LINE_LIST_PRICE TOTAL_LINE_LIST_PRICE
, CHRB.SIGN_BY_DATE SIGN_BY_DATE
, CHRB.USER_ESTIMATED_AMOUNT USER_ESTIMATED_AMOUNT
FROM OKC_SUBCLASSES_B SCS
, OKC_K_HEADERS_B CHRB
, OKC_K_HEADERS_TL CHRT
WHERE CHRB.ID = CHRT.ID
AND CHRB.BUY_OR_SELL='S'
AND CHRB.ISSUE_OR_RECEIVE='I'
AND CHRB.GOVERNING_CONTRACT_YN='Y'
AND CHRB.SCS_CODE = SCS.CODE
AND SCS.CLS_CODE IN ('SALES'
, 'MASTER'
, 'CORPORATE'
, 'LICENSE')
AND CHRT.LANGUAGE = USERENV('LANG')

Columns