VIEW: APPS.OKS_AUTH_HEADERS_V

Source

View Text - Preformatted

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, DECODE(KHR.ELECTRONIC_RENEWAL_FLAG,'Y','ERN',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, CHRB.DOCUMENT_ID DOCUMENT_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, DECODE(KHR.ERN_FLAG_USED_YN,'Y','ERN', 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, CHRB.ORG_ID ORG_ID, KHR.PERIOD_TYPE PERIOD_TYPE, KHR.PERIOD_START PERIOD_START, KHR.PRICE_UOM PRICE_UOM, KHR.FOLLOW_UP_ACTION FOLLOW_UP_ACTION, KHR.FOLLOW_UP_DATE FOLLOW_UP_DATE, CHRB.APPROVAL_TYPE APPROVAL_TYPE, KHR.TRXN_EXTENSION_ID TRXN_EXTENSION_ID, CHRB.PAYMENT_INSTRUCTION_TYPE PAYMENT_INSTRUCTION_TYPE, KHR.TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE, KHR.EXEMPT_CERTIFICATE_NUMBER EXEMPT_CERTIFICATE_NUMBER, KHR.EXEMPT_REASON_CODE EXEMPT_REASON_CODE, CHRB.TERM_CANCEL_SOURCE TERM_CANCEL_SOURCE, KHR.DATE_ACCEPTED DATE_ACCEPTED, KHR.ACCEPTED_BY ACCEPTED_BY, KHR.RMNDR_SUPPRESS_FLAG RMNDR_SUPPRESS_FLAG, KHR.RMNDR_SENT_FLAG RMNDR_SENT_FLAG, KHR.QUOTE_SENT_FLAG QUOTE_SENT_FLAG, KHR.PROCESS_REQUEST_ID PROCESS_REQUEST_ID, KHR.WF_ITEM_KEY WF_ITEM_KEY, KHR.PERSON_PARTY_ID PERSON_PARTY_ID, KHR.APPROVAL_TYPE_USED APPROVAL_TYPE_USED, CHRB.CANCELLED_AMOUNT CANCELLED_AMOUNT, KHR.RENEWAL_COMMENT RENEWAL_COMMENT, KHR.CC_EMAIL_ADDRESS CC_EMAIL_ADDRESS 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'

View Text - HTML Formatted

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
, DECODE(KHR.ELECTRONIC_RENEWAL_FLAG
, 'Y'
, 'ERN'
, 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
, CHRB.DOCUMENT_ID DOCUMENT_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
, DECODE(KHR.ERN_FLAG_USED_YN
, 'Y'
, 'ERN'
, 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
, CHRB.ORG_ID ORG_ID
, KHR.PERIOD_TYPE PERIOD_TYPE
, KHR.PERIOD_START PERIOD_START
, KHR.PRICE_UOM PRICE_UOM
, KHR.FOLLOW_UP_ACTION FOLLOW_UP_ACTION
, KHR.FOLLOW_UP_DATE FOLLOW_UP_DATE
, CHRB.APPROVAL_TYPE APPROVAL_TYPE
, KHR.TRXN_EXTENSION_ID TRXN_EXTENSION_ID
, CHRB.PAYMENT_INSTRUCTION_TYPE PAYMENT_INSTRUCTION_TYPE
, KHR.TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE
, KHR.EXEMPT_CERTIFICATE_NUMBER EXEMPT_CERTIFICATE_NUMBER
, KHR.EXEMPT_REASON_CODE EXEMPT_REASON_CODE
, CHRB.TERM_CANCEL_SOURCE TERM_CANCEL_SOURCE
, KHR.DATE_ACCEPTED DATE_ACCEPTED
, KHR.ACCEPTED_BY ACCEPTED_BY
, KHR.RMNDR_SUPPRESS_FLAG RMNDR_SUPPRESS_FLAG
, KHR.RMNDR_SENT_FLAG RMNDR_SENT_FLAG
, KHR.QUOTE_SENT_FLAG QUOTE_SENT_FLAG
, KHR.PROCESS_REQUEST_ID PROCESS_REQUEST_ID
, KHR.WF_ITEM_KEY WF_ITEM_KEY
, KHR.PERSON_PARTY_ID PERSON_PARTY_ID
, KHR.APPROVAL_TYPE_USED APPROVAL_TYPE_USED
, CHRB.CANCELLED_AMOUNT CANCELLED_AMOUNT
, KHR.RENEWAL_COMMENT RENEWAL_COMMENT
, KHR.CC_EMAIL_ADDRESS CC_EMAIL_ADDRESS
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'