VIEW: APPS.OKL_K_HEADERS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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