View: OKL_K_HEADERS_V

Product:	OKL - Lease and Finance Management
Description:	Oracle Lease Management shadow table for Oracle Contracts Core header tables, OKC_K_HEADERS_B and OKC_K_HEADERS_TL. OKL_K_HEADERS contains attributes that relate to contracts created in OKL and do not fit into the standard header tables O
Implementation/DBA Data:	APPS.OKL_K_HEADERS_V

View Text

SELECT KHR.ROWID ROW_ID
, KHR.ID ID
, KHR.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, KHR.ISG_ID ISG_ID
, KHR.KHR_ID KHR_ID
, KHR.PDT_ID PDT_ID
, 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.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
, KHR.CREATED_BY CREATED_BY
, KHR.CREATION_DATE CREATION_DATE
, KHR.LAST_UPDATED_BY LAST_UPDATED_BY
, KHR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, KHR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, 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
FROM OKL_K_HEADERS KHR

Columns