View: OKL_K_HEADERS_FULL_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_K_HEADERS_FULL_UV

View Text

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

Columns