View: OKS_AUTH_HEADERS_V

Product:	OKS - Service Contracts
Description:
Implementation/DBA Data:	APPS.OKS_AUTH_HEADERS_V

View Text

SELECT CHRB.ROWID ROW_ID
, CHRB.ID ID
, CHRB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CHRT.SFWT_FLAG SFWT_FLAG
, CHRB.CHR_ID_RESPONSE CHR_ID_RESPONSE
, CHRB.CHR_ID_AWARD CHR_ID_AWARD
, CHRB.CHR_ID_RENEWED CHR_ID_RENEWED
, CHRB.INV_ORGANIZATION_ID INV_ORGANIZATION_ID
, CHRB.STS_CODE STS_CODE
, CHRB.QCL_ID QCL_ID
, CHRB.SCS_CODE SCS_CODE
, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER
, CHRB.CURRENCY_CODE CURRENCY_CODE
, CHRB.CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER_MODIFIER
, CHRB.ARCHIVED_YN ARCHIVED_YN
, CHRB.DELETED_YN DELETED_YN
, CHRB.CUST_PO_NUMBER_REQ_YN CUST_PO_NUMBER_REQ_YN
, CHRB.PRE_PAY_REQ_YN PRE_PAY_REQ_YN
, CHRB.CUST_PO_NUMBER CUST_PO_NUMBER
, CHRT.SHORT_DESCRIPTION SHORT_DESCRIPTION
, CHRT.COMMENTS COMMENTS
, CHRT.DESCRIPTION DESCRIPTION
, CHRB.DPAS_RATING DPAS_RATING
, CHRT.COGNOMEN COGNOMEN
, CHRB.TEMPLATE_YN TEMPLATE_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.DATETIME_RESPONDED DATETIME_RESPONDED
, CHRT.NON_RESPONSE_REASON NON_RESPONSE_REASON
, CHRT.NON_RESPONSE_EXPLAIN NON_RESPONSE_EXPLAIN
, CHRB.RFP_TYPE RFP_TYPE
, CHRB.CHR_TYPE CHR_TYPE
, CHRB.KEEP_ON_MAIL_LIST KEEP_ON_MAIL_LIST
, CHRT.SET_ASIDE_REASON SET_ASIDE_REASON
, CHRB.SET_ASIDE_PERCENT SET_ASIDE_PERCENT
, CHRB.RESPONSE_COPIES_REQ RESPONSE_COPIES_REQ
, CHRB.DATE_CLOSE_PROJECTED DATE_CLOSE_PROJECTED
, CHRB.DATETIME_PROPOSED DATETIME_PROPOSED
, 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.RESOLVED_UNTIL RESOLVED_UNTIL
, 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
, CHRB.GOVERNING_CONTRACT_YN GOVERNING_CONTRACT_YN
, CHRB.CONVERSION_TYPE CONVERSION_TYPE
, CHRB.CONVERSION_RATE CONVERSION_RATE
, CHRB.CONVERSION_RATE_DATE CONVERSION_RATE_DATE
, CHRB.CONVERSION_EURO_RATE CONVERSION_EURO_RATE
, CHRB.CUST_ACCT_ID CUST_ACCT_ID
, CHRB.BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID
, CHRB.INV_RULE_ID INV_RULE_ID
, CHRB.RENEWAL_TYPE_CODE RENEWAL_TYPE_CODE
, CHRB.RENEWAL_NOTIFY_TO RENEWAL_NOTIFY_TO
, CHRB.RENEWAL_END_DATE RENEWAL_END_DATE
, CHRB.SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID
, CHRB.PAYMENT_TERM_ID PAYMENT_TERM_ID
, CHRT.LANGUAGE LANGUAGE
, CHRT.SOURCE_LANG SOURCE_LANG
, KHR.ID KHR_ID
, KHR.OBJECT_VERSION_NUMBER KHR_OBJECT_VERSION_NUMBER
, KHR.ACCT_RULE_ID ACCT_RULE_ID
, KHR.PAYMENT_TYPE PAYMENT_TYPE
, KHR.CC_NO CC_NO
, KHR.CC_EXPIRY_DATE CC_EXPIRY_DATE
, KHR.CC_BANK_ACCT_ID CC_BANK_ACCT_ID
, KHR.CC_AUTH_CODE CC_AUTH_CODE
, KHR.COMMITMENT_ID COMMITMENT_ID
, KHR.GRACE_DURATION GRACE_DURATION
, KHR.GRACE_PERIOD GRACE_PERIOD
, KHR.EST_REV_PERCENT EST_REV_PERCENT
, KHR.EST_REV_DATE EST_REV_DATE
, KHR.TAX_AMOUNT TAX_AMOUNT
, KHR.TAX_STATUS TAX_STATUS
, KHR.TAX_CODE TAX_CODE
, KHR.TAX_EXEMPTION_ID TAX_EXEMPTION_ID
, KHR.BILLING_PROFILE_ID BILLING_PROFILE_ID
, KHR.RENEWAL_STATUS RENEWAL_STATUS
, KHR.ELECTRONIC_RENEWAL_FLAG ELECTRONIC_RENEWAL_FLAG
, KHR.QUOTE_TO_CONTACT_ID QUOTE_TO_CONTACT_ID
, KHR.QUOTE_TO_SITE_ID QUOTE_TO_SITE_ID
, KHR.QUOTE_TO_EMAIL_ID QUOTE_TO_EMAIL_ID
, KHR.QUOTE_TO_PHONE_ID QUOTE_TO_PHONE_ID
, KHR.QUOTE_TO_FAX_ID QUOTE_TO_FAX_ID
, KHR.RENEWAL_PO_REQUIRED RENEWAL_PO_REQUIRED
, KHR.RENEWAL_PO_NUMBER RENEWAL_PO_NUMBER
, KHR.RENEWAL_PRICE_LIST RENEWAL_PRICE_LIST
, KHR.RENEWAL_PRICING_TYPE RENEWAL_PRICING_TYPE
, KHR.RENEWAL_MARKUP_PERCENT RENEWAL_MARKUP_PERCENT
, KHR.RENEWAL_GRACE_DURATION RENEWAL_GRACE_DURATION
, KHR.RENEWAL_GRACE_PERIOD RENEWAL_GRACE_PERIOD
, KHR.RENEWAL_EST_REV_PERCENT RENEWAL_EST_REV_PERCENT
, KHR.RENEWAL_EST_REV_DURATION RENEWAL_EST_REV_DURATION
, KHR.RENEWAL_EST_REV_PERIOD RENEWAL_EST_REV_PERIOD
, KHR.RENEWAL_PRICE_LIST_USED RENEWAL_PRICE_LIST_USED
, KHR.RENEWAL_TYPE_USED RENEWAL_TYPE_USED
, KHR.RENEWAL_NOTIFICATION_TO RENEWAL_NOTIFICATION_TO
, KHR.RENEWAL_PO_USED RENEWAL_PO_USED
, KHR.RENEWAL_PRICING_TYPE_USED RENEWAL_PRICING_TYPE_USED
, KHR.RENEWAL_MARKUP_PERCENT_USED RENEWAL_MARKUP_PERCENT_USED
, KHR.REV_EST_PERCENT_USED REV_EST_PERCENT_USED
, KHR.REV_EST_DURATION_USED REV_EST_DURATION_USED
, KHR.REV_EST_PERIOD_USED REV_EST_PERIOD_USED
, KHR.BILLING_PROFILE_USED BILLING_PROFILE_USED
, KHR.ERN_FLAG_USED_YN ERN_FLAG_USED_YN
, KHR.EVN_THRESHOLD_AMT EVN_THRESHOLD_AMT
, KHR.EVN_THRESHOLD_CUR EVN_THRESHOLD_CUR
, KHR.ERN_THRESHOLD_AMT ERN_THRESHOLD_AMT
, KHR.ERN_THRESHOLD_CUR ERN_THRESHOLD_CUR
, KHR.RENEWAL_GRACE_DURATION_USED RENEWAL_GRACE_DURATION_USED
, KHR.RENEWAL_GRACE_PERIOD_USED RENEWAL_GRACE_PERIOD_USED
, KHR.INV_TRX_TYPE INV_TRX_TYPE
, KHR.INV_PRINT_PROFILE INV_PRINT_PROFILE
, KHR.AR_INTERFACE_YN AR_INTERFACE_YN
, KHR.HOLD_BILLING HOLD_BILLING
, KHR.SUMMARY_TRX_YN SUMMARY_TRX_YN
, KHR.SERVICE_PO_NUMBER SERVICE_PO_NUMBER
, KHR.SERVICE_PO_REQUIRED SERVICE_PO_REQUIRED
, KHR.BILLING_SCHEDULE_TYPE BILLING_SCHEDULE_TYPE
, STS.MEANING STS_MEANING
, CLS.MEANING CLASS_MEANING
FROM OKC_K_HEADERS_B CHRB
, OKC_K_HEADERS_TL CHRT
, OKS_K_HEADERS_B KHR
, OKC_STATUSES_V STS
, OKC_SUBCLASSES_V CLS
WHERE CHRB.ID = CHRT.ID
AND CHRB.ID = KHR.CHR_ID
AND CHRT.LANGUAGE = USERENV('LANG')
AND CHRB.STS_CODE = STS.CODE
AND CHRB.SCS_CODE = CLS.CODE
AND CLS.CLS_CODE = 'SERVICE'

Columns