VIEW: APPS.OKC_GOVERNING_CONTRACT_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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