eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OKL_K_HEADERS_FULL_UV

Source

View Text - Preformatted


SELECT TO_CHAR(CHRB.ID) ID , CHRB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER , CHRB.INV_ORGANIZATION_ID INV_ORGANIZATION_ID , CHRB.ORG_ID , CHRB.STS_CODE STS_CODE , TO_CHAR(NULL) STS_CODE_MEANING , TO_CHAR(CHRB.QCL_ID) QCL_ID , CHRB.SCS_CODE SCS_CODE , TO_CHAR(NULL) SCS_CODE_MEANING , 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.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 , KHR.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY , KHR.ATTRIBUTE1 ATTRIBUTE1 , KHR.ATTRIBUTE2 ATTRIBUTE2 , KHR.ATTRIBUTE3 ATTRIBUTE3 , KHR.ATTRIBUTE4 ATTRIBUTE4 , KHR.ATTRIBUTE5 ATTRIBUTE5 , KHR.ATTRIBUTE6 ATTRIBUTE6 , KHR.ATTRIBUTE7 ATTRIBUTE7 , KHR.ATTRIBUTE8 ATTRIBUTE8 , KHR.ATTRIBUTE9 ATTRIBUTE9 , KHR.ATTRIBUTE10 ATTRIBUTE10 , KHR.ATTRIBUTE11 ATTRIBUTE11 , KHR.ATTRIBUTE12 ATTRIBUTE12 , KHR.ATTRIBUTE13 ATTRIBUTE13 , KHR.ATTRIBUTE14 ATTRIBUTE14 , KHR.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 ORIG_SYSTEM_SOURCE_CODE , CHRB.ORIG_SYSTEM_ID1 ORIG_SYSTEM_ID1 , CHRB.ORIG_SYSTEM_REFERENCE1 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.CUST_ACCT_ID CUST_ACCT_ID , 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.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 , KHR.OBJECT_VERSION_NUMBER KHR_OBJECT_VERSION_NUMBER , TO_CHAR(KHR.ISG_ID) ISG_ID , TO_CHAR(KHR.KHR_ID) VPA_KHR_ID , TO_CHAR(KHR.PDT_ID) PDT_ID , TO_CHAR(NULL) PRODUCT_NAME , TO_CHAR(NULL) PRODUCT_DESCRIPTION , KHR.AMD_CODE AMD_CODE , KHR.DATE_FIRST_ACTIVITY DATE_FIRST_ACTIVITY , KHR.GENERATE_ACCRUAL_YN GENERATE_ACCRUAL_YN , KHR.GENERATE_ACCRUAL_OVERRIDE_YN GENERATE_ACCRUAL_OVERRIDE_YN , KHR.DATE_REFINANCED DATE_REFINANCED , KHR.CREDIT_ACT_YN CREDIT_ACT_YN , KHR.TERM_DURATION TERM_DURATION , KHR.CONVERTED_ACCOUNT_YN CONVERTED_ACCOUNT_YN , KHR.DATE_CONVERSION_EFFECTIVE DATE_CONVERSION_EFFECTIVE , KHR.SYNDICATABLE_YN SYNDICATABLE_YN , KHR.SALESTYPE_YN SALESTYPE_YN , KHR.DATE_DEAL_TRANSFERRED DATE_DEAL_TRANSFERRED , KHR.DATETIME_PROPOSAL_EFFECTIVE DATETIME_PROPOSAL_EFFECTIVE , KHR.DATETIME_PROPOSAL_INEFFECTIVE DATETIME_PROPOSAL_INEFFECTIVE , KHR.DATE_PROPOSAL_ACCEPTED DATE_PROPOSAL_ACCEPTED , KHR.PRE_TAX_YIELD PRE_TAX_YIELD , KHR.AFTER_TAX_YIELD AFTER_TAX_YIELD , KHR.IMPLICIT_INTEREST_RATE IMPLICIT_INTEREST_RATE , KHR.IMPLICIT_NON_IDC_INTEREST_RATE IMPLICIT_NON_IDC_INTEREST_RATE , KHR.TARGET_PRE_TAX_YIELD TARGET_PRE_TAX_YIELD , KHR.TARGET_AFTER_TAX_YIELD TARGET_AFTER_TAX_YIELD , KHR.TARGET_IMPLICIT_INTEREST_RATE TARGET_IMPLICIT_INTEREST_RATE , KHR.TARGET_IMPLICIT_NONIDC_INTRATE TARGET_IMPLICIT_NONIDC_INTRATE , KHR.DATE_LAST_INTERIM_INTEREST_CAL DATE_LAST_INTERIM_INTEREST_CAL , KHR.DEAL_TYPE DEAL_TYPE , KHR.PRE_TAX_IRR PRE_TAX_IRR , KHR.AFTER_TAX_IRR AFTER_TAX_IRR , KHR.EXPECTED_DELIVERY_DATE EXPECTED_DELIVERY_DATE , KHR.ACCEPTED_DATE ACCEPTED_DATE , KHR.PREFUNDING_ELIGIBLE_YN PREFUNDING_ELIGIBLE_YN , KHR.REVOLVING_CREDIT_YN REVOLVING_CREDIT_YN , KHR.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE , KHR.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE , KHR.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE , KHR.MULTI_GAAP_YN MULTI_GAAP_YN , KHR.RECOURSE_CODE RECOURSE_CODE , KHR.LESSOR_SERV_ORG_CODE LESSOR_SERV_ORG_CODE , KHR.ASSIGNABLE_YN ASSIGNABLE_YN , KHR.SECURITIZED_CODE SECURITIZED_CODE , KHR.SECURITIZATION_TYPE SECURITIZATION_TYPE , KHR.SUB_PRE_TAX_YIELD SUB_PRE_TAX_YIELD , KHR.SUB_AFTER_TAX_YIELD SUB_AFTER_TAX_YIELD , KHR.SUB_IMPL_INTEREST_RATE SUB_IMPL_INTEREST_RATE , KHR.SUB_IMPL_NON_IDC_INT_RATE SUB_IMPL_NON_IDC_INT_RATE , KHR.SUB_PRE_TAX_IRR SUB_PRE_TAX_IRR , KHR.SUB_AFTER_TAX_IRR SUB_AFTER_TAX_IRR , KHR.TOT_CL_TRANSFER_AMT TOT_CL_TRANSFER_AMT , KHR.TOT_CL_NET_TRANSFER_AMT TOT_CL_NET_TRANSFER_AMT , KHR.TOT_CL_LIMIT TOT_CL_LIMIT , KHR.TOT_CL_FUNDING_AMT TOT_CL_FUNDING_AMT , KHR.CRS_ID CRS_ID , KHR.TEMPLATE_TYPE_CODE TEMPLATE_TYPE_CODE , KHR.TRADEIN_DESCRIPTION TRADEIN_DESCRIPTION , KHR.TRADEIN_AMOUNT TRADEIN_AMOUNT , KHR.DATE_TRADEIN DATE_TRADEIN , KHR.DATE_FUNDING_EXPECTED DATE_FUNDING_EXPECTED , KHR.LEGAL_ENTITY_ID LEGAL_ENTITY_ID , TO_CHAR(NULL) CUSTOMER_CPL_ID , TO_CHAR(NULL) CUSTOMER_OBJECT1_ID1 , TO_CHAR(NULL) CUSTOMER_OBJECT1_ID2 , TO_CHAR(NULL) CUSTOMER_JTOT_OBJECT1_CODE , TO_CHAR(NULL) CUSTOMER_NAME , TO_CHAR(NULL) CUSTOMER_ACCOUNT , TO_CHAR(NULL) MLA_CONTRACT_NUMBER , TO_CHAR(NULL) MLA_CHR_ID , TO_CHAR(NULL) MLA_GVR_ID , TO_CHAR(NULL) CREDIT_LINE_CONTRACT_NUMBER , TO_CHAR(NULL) CREDIT_LINE_CHR_ID , TO_CHAR(NULL) CREDIT_GVR_ID , TO_CHAR(NULL) VPA_CONTRACT_NUMBER , TO_CHAR(NULL) LEGAL_ENTITY_NAME , TO_CHAR(NULL) OPERATING_UNIT_NAME , TO_CHAR(NULL) LEGAL_ADDRESS , TO_CHAR(NULL) LEGAL_ADDRESS_ID , TO_CHAR(NULL) SALES_REPRESENTATIVE_NAME , TO_NUMBER(NULL) REP_CONTACT_ID , TO_NUMBER(NULL) REP_CONTACT_OBJECT1_ID1 , TO_NUMBER(NULL) REP_CONTACT_OBJECT1_ID2 , TO_CHAR(NULL) REP_CONTACT_JTOT_OBJECT1_CODE , TO_CHAR(NULL) LEDGER_NAME , TO_NUMBER(NULL) LEDGER_ID , TO_CHAR(NULL) INTEREST_CALC_MEANING , TO_CHAR(NULL) REVENUE_RECOGNITION_MEANING , TO_CHAR(NULL) BOOK_CLASS_MEANING , TO_CHAR(NULL) PROGRAM_TEMPLATE_NAME , TO_CHAR(NULL) PROGRAM_TEMPLATE_CHR_ID , TO_CHAR(NULL) ORIGINATION_QUOTE_NAME , TO_CHAR(NULL) ORIGINATION_QUOTE_ID , TO_CHAR(NULL) LEASE_APPLICATION_NAME , TO_CHAR(NULL) LEASE_APPLICATION_ID , TO_CHAR(NULL) REPLACES_CONTRACT_NUMBER , TO_CHAR(NULL) REPLACES_CHR_ID , TO_CHAR(NULL) LEGACY_NUMBER , TO_CHAR(NULL) ELIG_FOR_PREFUNDING_MEANING , TO_CHAR(NULL) CAP_INTERIM_INTERST_MEANING , TO_CHAR(NULL) CONVERTED_ACCT_MEANING , TO_CHAR(NULL) PRIVATE_ACT_BOND_MEANING , TO_CHAR(NULL) CONSUMER_CREDIT_ACT_MEANING , TO_CHAR(NULL) NON_NOTIFICATION_MEANING , TO_CHAR(NULL) ASSIGNABLE_MEANING , TO_CHAR(NULL) LESSOR_INSURED_MEANING , TO_CHAR(NULL) LESSOR_PAYEE_MEANING , TO_CHAR(NULL) CURRENCY_CONV_TYPE_MEANING , TO_CHAR(NULL) ACCEPTANCE_METHOD_MEANING , TO_DATE(NULL) REBOOK_LIMIT_DATE , TO_CHAR(NULL) REBOOK_LIMIT_DATE_RGP_ID , TO_CHAR(NULL) REBOOK_LIMIT_DATE_RGD_CODE , TO_CHAR(NULL) REBOOK_LIMIT_DATE_RUL_ID , TO_CHAR(NULL) REBOOK_LIMIT_RUL_INF_CAT , TO_CHAR(NULL) REBOOK_LIMIT_RUL_INF1 , TO_CHAR(NULL) TAX_OWNER_CODE , TO_CHAR(NULL) TAX_OWNER_MEANING , TO_CHAR(NULL) TAX_OWNER_RGP_ID , TO_CHAR(NULL) TAX_OWNER_RGD_CODE , TO_CHAR(NULL) TAX_OWNER_RUL_ID , TO_CHAR(NULL) TAX_OWNER_RUL_INF_CAT , TO_CHAR(NULL) TAX_OWNER_RUL_INF1 , TO_CHAR(NULL) CAP_INTERIM_INT_RGP_ID , TO_CHAR(NULL) CAP_INTERIM_INT_RGD_CODE , TO_CHAR(NULL) CAP_INTERIM_INT_RUL_ID , TO_CHAR(NULL) CAP_INTERIM_INT_RUL_INF_CAT , TO_CHAR(NULL) CAP_INTERIM_INT_RUL_INF1 , TO_CHAR(NULL) PRV_ACT_BOND_RGP_ID , TO_CHAR(NULL) PRV_ACT_BOND_RGD_CODE , TO_CHAR(NULL) PRV_ACT_BOND_RUL_ID , TO_CHAR(NULL) PRV_ACT_BOND_RUL_INF_CAT , TO_CHAR(NULL) PRV_ACT_BOND_RUL_INF1 , TO_CHAR(NULL) NNTF_RGP_ID , TO_CHAR(NULL) NNTF_RGD_CODE , TO_CHAR(NULL) NNTF_RUL_ID , TO_CHAR(NULL) NNTF_RUL_INF_CAT , TO_CHAR(NULL) NNTF_RUL_INF1 , TO_CHAR(NULL) BILL_TO_ADDRESS_DESC , TO_CHAR(NULL) SPLIT_FROM_CONTRACT_NUMBER , TO_CHAR(NULL) SPLIT_FROM_CHR_ID , TO_CHAR(NULL) SOURCE_CODE , TO_CHAR(NULL) SOURCE_CHR_ID , TO_CHAR(NULL) SOURCE_CONTRACT_NUMBER , TO_CHAR(NULL) PRODUCT_SUBCLASS_CODE , TO_CHAR(NULL) BILL_TO_RGP_ID , TO_CHAR(NULL) BILL_TO_RUL_ID , TO_CHAR(NULL) BILL_TO_RGD_CODE , TO_CHAR(NULL) BILL_TO_RUL_INF_CAT , TO_NUMBER(NULL) BILL_TO_RUL_INF1 , TO_CHAR(NULL) RELEASED_ASSET_MEANING , TO_CHAR(NULL) RLES_RGD_CODE , TO_CHAR(NULL) RLES_RGP_ID , TO_CHAR(NULL) RLES_RUL_ID , TO_CHAR(NULL) RLES_RUL_INF1 , TO_CHAR(NULL) RLES_RUL_INF_CAT , TO_DATE(NULL) LAST_ACTIVATION_DATE FROM OKC_K_HEADERS_B CHRB,OKL_K_HEADERS KHR,OKC_K_HEADERS_TL CHRT WHERE CHRB.ID = CHRT.ID AND CHRT.LANGUAGE = USERENV('LANG') AND KHR.ID = CHRB.ID

View Text - HTML Formatted

SELECT TO_CHAR(CHRB.ID) ID
, CHRB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CHRB.INV_ORGANIZATION_ID INV_ORGANIZATION_ID
, CHRB.ORG_ID
, CHRB.STS_CODE STS_CODE
, TO_CHAR(NULL) STS_CODE_MEANING
, TO_CHAR(CHRB.QCL_ID) QCL_ID
, CHRB.SCS_CODE SCS_CODE
, TO_CHAR(NULL) SCS_CODE_MEANING
, 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.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
, KHR.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, KHR.ATTRIBUTE1 ATTRIBUTE1
, KHR.ATTRIBUTE2 ATTRIBUTE2
, KHR.ATTRIBUTE3 ATTRIBUTE3
, KHR.ATTRIBUTE4 ATTRIBUTE4
, KHR.ATTRIBUTE5 ATTRIBUTE5
, KHR.ATTRIBUTE6 ATTRIBUTE6
, KHR.ATTRIBUTE7 ATTRIBUTE7
, KHR.ATTRIBUTE8 ATTRIBUTE8
, KHR.ATTRIBUTE9 ATTRIBUTE9
, KHR.ATTRIBUTE10 ATTRIBUTE10
, KHR.ATTRIBUTE11 ATTRIBUTE11
, KHR.ATTRIBUTE12 ATTRIBUTE12
, KHR.ATTRIBUTE13 ATTRIBUTE13
, KHR.ATTRIBUTE14 ATTRIBUTE14
, KHR.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 ORIG_SYSTEM_SOURCE_CODE
, CHRB.ORIG_SYSTEM_ID1 ORIG_SYSTEM_ID1
, CHRB.ORIG_SYSTEM_REFERENCE1 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.CUST_ACCT_ID CUST_ACCT_ID
, 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.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
, KHR.OBJECT_VERSION_NUMBER KHR_OBJECT_VERSION_NUMBER
, TO_CHAR(KHR.ISG_ID) ISG_ID
, TO_CHAR(KHR.KHR_ID) VPA_KHR_ID
, TO_CHAR(KHR.PDT_ID) PDT_ID
, TO_CHAR(NULL) PRODUCT_NAME
, TO_CHAR(NULL) PRODUCT_DESCRIPTION
, KHR.AMD_CODE AMD_CODE
, KHR.DATE_FIRST_ACTIVITY DATE_FIRST_ACTIVITY
, KHR.GENERATE_ACCRUAL_YN GENERATE_ACCRUAL_YN
, KHR.GENERATE_ACCRUAL_OVERRIDE_YN GENERATE_ACCRUAL_OVERRIDE_YN
, KHR.DATE_REFINANCED DATE_REFINANCED
, KHR.CREDIT_ACT_YN CREDIT_ACT_YN
, KHR.TERM_DURATION TERM_DURATION
, KHR.CONVERTED_ACCOUNT_YN CONVERTED_ACCOUNT_YN
, KHR.DATE_CONVERSION_EFFECTIVE DATE_CONVERSION_EFFECTIVE
, KHR.SYNDICATABLE_YN SYNDICATABLE_YN
, KHR.SALESTYPE_YN SALESTYPE_YN
, KHR.DATE_DEAL_TRANSFERRED DATE_DEAL_TRANSFERRED
, KHR.DATETIME_PROPOSAL_EFFECTIVE DATETIME_PROPOSAL_EFFECTIVE
, KHR.DATETIME_PROPOSAL_INEFFECTIVE DATETIME_PROPOSAL_INEFFECTIVE
, KHR.DATE_PROPOSAL_ACCEPTED DATE_PROPOSAL_ACCEPTED
, KHR.PRE_TAX_YIELD PRE_TAX_YIELD
, KHR.AFTER_TAX_YIELD AFTER_TAX_YIELD
, KHR.IMPLICIT_INTEREST_RATE IMPLICIT_INTEREST_RATE
, KHR.IMPLICIT_NON_IDC_INTEREST_RATE IMPLICIT_NON_IDC_INTEREST_RATE
, KHR.TARGET_PRE_TAX_YIELD TARGET_PRE_TAX_YIELD
, KHR.TARGET_AFTER_TAX_YIELD TARGET_AFTER_TAX_YIELD
, KHR.TARGET_IMPLICIT_INTEREST_RATE TARGET_IMPLICIT_INTEREST_RATE
, KHR.TARGET_IMPLICIT_NONIDC_INTRATE TARGET_IMPLICIT_NONIDC_INTRATE
, KHR.DATE_LAST_INTERIM_INTEREST_CAL DATE_LAST_INTERIM_INTEREST_CAL
, KHR.DEAL_TYPE DEAL_TYPE
, KHR.PRE_TAX_IRR PRE_TAX_IRR
, KHR.AFTER_TAX_IRR AFTER_TAX_IRR
, KHR.EXPECTED_DELIVERY_DATE EXPECTED_DELIVERY_DATE
, KHR.ACCEPTED_DATE ACCEPTED_DATE
, KHR.PREFUNDING_ELIGIBLE_YN PREFUNDING_ELIGIBLE_YN
, KHR.REVOLVING_CREDIT_YN REVOLVING_CREDIT_YN
, KHR.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, KHR.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, KHR.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, KHR.MULTI_GAAP_YN MULTI_GAAP_YN
, KHR.RECOURSE_CODE RECOURSE_CODE
, KHR.LESSOR_SERV_ORG_CODE LESSOR_SERV_ORG_CODE
, KHR.ASSIGNABLE_YN ASSIGNABLE_YN
, KHR.SECURITIZED_CODE SECURITIZED_CODE
, KHR.SECURITIZATION_TYPE SECURITIZATION_TYPE
, KHR.SUB_PRE_TAX_YIELD SUB_PRE_TAX_YIELD
, KHR.SUB_AFTER_TAX_YIELD SUB_AFTER_TAX_YIELD
, KHR.SUB_IMPL_INTEREST_RATE SUB_IMPL_INTEREST_RATE
, KHR.SUB_IMPL_NON_IDC_INT_RATE SUB_IMPL_NON_IDC_INT_RATE
, KHR.SUB_PRE_TAX_IRR SUB_PRE_TAX_IRR
, KHR.SUB_AFTER_TAX_IRR SUB_AFTER_TAX_IRR
, KHR.TOT_CL_TRANSFER_AMT TOT_CL_TRANSFER_AMT
, KHR.TOT_CL_NET_TRANSFER_AMT TOT_CL_NET_TRANSFER_AMT
, KHR.TOT_CL_LIMIT TOT_CL_LIMIT
, KHR.TOT_CL_FUNDING_AMT TOT_CL_FUNDING_AMT
, KHR.CRS_ID CRS_ID
, KHR.TEMPLATE_TYPE_CODE TEMPLATE_TYPE_CODE
, KHR.TRADEIN_DESCRIPTION TRADEIN_DESCRIPTION
, KHR.TRADEIN_AMOUNT TRADEIN_AMOUNT
, KHR.DATE_TRADEIN DATE_TRADEIN
, KHR.DATE_FUNDING_EXPECTED DATE_FUNDING_EXPECTED
, KHR.LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, TO_CHAR(NULL) CUSTOMER_CPL_ID
, TO_CHAR(NULL) CUSTOMER_OBJECT1_ID1
, TO_CHAR(NULL) CUSTOMER_OBJECT1_ID2
, TO_CHAR(NULL) CUSTOMER_JTOT_OBJECT1_CODE
, TO_CHAR(NULL) CUSTOMER_NAME
, TO_CHAR(NULL) CUSTOMER_ACCOUNT
, TO_CHAR(NULL) MLA_CONTRACT_NUMBER
, TO_CHAR(NULL) MLA_CHR_ID
, TO_CHAR(NULL) MLA_GVR_ID
, TO_CHAR(NULL) CREDIT_LINE_CONTRACT_NUMBER
, TO_CHAR(NULL) CREDIT_LINE_CHR_ID
, TO_CHAR(NULL) CREDIT_GVR_ID
, TO_CHAR(NULL) VPA_CONTRACT_NUMBER
, TO_CHAR(NULL) LEGAL_ENTITY_NAME
, TO_CHAR(NULL) OPERATING_UNIT_NAME
, TO_CHAR(NULL) LEGAL_ADDRESS
, TO_CHAR(NULL) LEGAL_ADDRESS_ID
, TO_CHAR(NULL) SALES_REPRESENTATIVE_NAME
, TO_NUMBER(NULL) REP_CONTACT_ID
, TO_NUMBER(NULL) REP_CONTACT_OBJECT1_ID1
, TO_NUMBER(NULL) REP_CONTACT_OBJECT1_ID2
, TO_CHAR(NULL) REP_CONTACT_JTOT_OBJECT1_CODE
, TO_CHAR(NULL) LEDGER_NAME
, TO_NUMBER(NULL) LEDGER_ID
, TO_CHAR(NULL) INTEREST_CALC_MEANING
, TO_CHAR(NULL) REVENUE_RECOGNITION_MEANING
, TO_CHAR(NULL) BOOK_CLASS_MEANING
, TO_CHAR(NULL) PROGRAM_TEMPLATE_NAME
, TO_CHAR(NULL) PROGRAM_TEMPLATE_CHR_ID
, TO_CHAR(NULL) ORIGINATION_QUOTE_NAME
, TO_CHAR(NULL) ORIGINATION_QUOTE_ID
, TO_CHAR(NULL) LEASE_APPLICATION_NAME
, TO_CHAR(NULL) LEASE_APPLICATION_ID
, TO_CHAR(NULL) REPLACES_CONTRACT_NUMBER
, TO_CHAR(NULL) REPLACES_CHR_ID
, TO_CHAR(NULL) LEGACY_NUMBER
, TO_CHAR(NULL) ELIG_FOR_PREFUNDING_MEANING
, TO_CHAR(NULL) CAP_INTERIM_INTERST_MEANING
, TO_CHAR(NULL) CONVERTED_ACCT_MEANING
, TO_CHAR(NULL) PRIVATE_ACT_BOND_MEANING
, TO_CHAR(NULL) CONSUMER_CREDIT_ACT_MEANING
, TO_CHAR(NULL) NON_NOTIFICATION_MEANING
, TO_CHAR(NULL) ASSIGNABLE_MEANING
, TO_CHAR(NULL) LESSOR_INSURED_MEANING
, TO_CHAR(NULL) LESSOR_PAYEE_MEANING
, TO_CHAR(NULL) CURRENCY_CONV_TYPE_MEANING
, TO_CHAR(NULL) ACCEPTANCE_METHOD_MEANING
, TO_DATE(NULL) REBOOK_LIMIT_DATE
, TO_CHAR(NULL) REBOOK_LIMIT_DATE_RGP_ID
, TO_CHAR(NULL) REBOOK_LIMIT_DATE_RGD_CODE
, TO_CHAR(NULL) REBOOK_LIMIT_DATE_RUL_ID
, TO_CHAR(NULL) REBOOK_LIMIT_RUL_INF_CAT
, TO_CHAR(NULL) REBOOK_LIMIT_RUL_INF1
, TO_CHAR(NULL) TAX_OWNER_CODE
, TO_CHAR(NULL) TAX_OWNER_MEANING
, TO_CHAR(NULL) TAX_OWNER_RGP_ID
, TO_CHAR(NULL) TAX_OWNER_RGD_CODE
, TO_CHAR(NULL) TAX_OWNER_RUL_ID
, TO_CHAR(NULL) TAX_OWNER_RUL_INF_CAT
, TO_CHAR(NULL) TAX_OWNER_RUL_INF1
, TO_CHAR(NULL) CAP_INTERIM_INT_RGP_ID
, TO_CHAR(NULL) CAP_INTERIM_INT_RGD_CODE
, TO_CHAR(NULL) CAP_INTERIM_INT_RUL_ID
, TO_CHAR(NULL) CAP_INTERIM_INT_RUL_INF_CAT
, TO_CHAR(NULL) CAP_INTERIM_INT_RUL_INF1
, TO_CHAR(NULL) PRV_ACT_BOND_RGP_ID
, TO_CHAR(NULL) PRV_ACT_BOND_RGD_CODE
, TO_CHAR(NULL) PRV_ACT_BOND_RUL_ID
, TO_CHAR(NULL) PRV_ACT_BOND_RUL_INF_CAT
, TO_CHAR(NULL) PRV_ACT_BOND_RUL_INF1
, TO_CHAR(NULL) NNTF_RGP_ID
, TO_CHAR(NULL) NNTF_RGD_CODE
, TO_CHAR(NULL) NNTF_RUL_ID
, TO_CHAR(NULL) NNTF_RUL_INF_CAT
, TO_CHAR(NULL) NNTF_RUL_INF1
, TO_CHAR(NULL) BILL_TO_ADDRESS_DESC
, TO_CHAR(NULL) SPLIT_FROM_CONTRACT_NUMBER
, TO_CHAR(NULL) SPLIT_FROM_CHR_ID
, TO_CHAR(NULL) SOURCE_CODE
, TO_CHAR(NULL) SOURCE_CHR_ID
, TO_CHAR(NULL) SOURCE_CONTRACT_NUMBER
, TO_CHAR(NULL) PRODUCT_SUBCLASS_CODE
, TO_CHAR(NULL) BILL_TO_RGP_ID
, TO_CHAR(NULL) BILL_TO_RUL_ID
, TO_CHAR(NULL) BILL_TO_RGD_CODE
, TO_CHAR(NULL) BILL_TO_RUL_INF_CAT
, TO_NUMBER(NULL) BILL_TO_RUL_INF1
, TO_CHAR(NULL) RELEASED_ASSET_MEANING
, TO_CHAR(NULL) RLES_RGD_CODE
, TO_CHAR(NULL) RLES_RGP_ID
, TO_CHAR(NULL) RLES_RUL_ID
, TO_CHAR(NULL) RLES_RUL_INF1
, TO_CHAR(NULL) RLES_RUL_INF_CAT
, TO_DATE(NULL) LAST_ACTIVATION_DATE
FROM OKC_K_HEADERS_B CHRB
, OKL_K_HEADERS KHR
, OKC_K_HEADERS_TL CHRT
WHERE CHRB.ID = CHRT.ID
AND CHRT.LANGUAGE = USERENV('LANG')
AND KHR.ID = CHRB.ID