View: OKL_K_LINES_FULL_V

Product:	OKL - Lease and Finance Management
Description:	OKL_K_LINES_FULL_V is the full view on tables OKC_K_LINES_B and OKL_K_LINES. It combines the attributes of contracts core and lease management contract line tables.
Implementation/DBA Data:	APPS.OKL_K_LINES_FULL_V

View Text

SELECT CLEB.ROWID ROW_ID
, CLEB.ID ID
, CLEB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CLET.SFWT_FLAG SFWT_FLAG
, CLEB.CHR_ID CHR_ID
, CLEB.CLE_ID CLE_ID
, CLEB.CLE_ID_RENEWED CLE_ID_RENEWED
, CLEB.CLE_ID_RENEWED_TO CLE_ID_RENEWED_TO
, CLEB.LSE_ID LSE_ID
, CLEB.LINE_NUMBER LINE_NUMBER
, CLEB.STS_CODE STS_CODE
, CLEB.DISPLAY_SEQUENCE DISPLAY_SEQUENCE
, CLEB.TRN_CODE TRN_CODE
, CLEB.DNZ_CHR_ID DNZ_CHR_ID
, CLET.COMMENTS COMMENTS
, CLET.ITEM_DESCRIPTION ITEM_DESCRIPTION
, CLET.OKE_BOE_DESCRIPTION
, CLEB.HIDDEN_IND HIDDEN_IND
, CLEB.PRICE_UNIT PRICE_UNIT
, CLEB.PRICE_UNIT_PERCENT PRICE_UNIT_PERCENT
, CLEB.PRICE_NEGOTIATED PRICE_NEGOTIATED
, CLEB.PRICE_NEGOTIATED_RENEWED PRICE_NEGOTIATED_RENEWED
, CLEB.PRICE_LEVEL_IND PRICE_LEVEL_IND
, CLEB.INVOICE_LINE_LEVEL_IND INVOICE_LINE_LEVEL_IND
, CLEB.DPAS_RATING DPAS_RATING
, CLET.BLOCK23TEXT BLOCK23TEXT
, CLEB.EXCEPTION_YN EXCEPTION_YN
, CLEB.TEMPLATE_USED TEMPLATE_USED
, CLEB.DATE_TERMINATED DATE_TERMINATED
, CLET.NAME NAME
, CLEB.START_DATE START_DATE
, CLEB.END_DATE END_DATE
, CLEB.UPG_ORIG_SYSTEM_REF UPG_ORIG_SYSTEM_REF
, CLEB.UPG_ORIG_SYSTEM_REF_ID UPG_ORIG_SYSTEM_REF_ID
, CLEB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CLEB.ATTRIBUTE1 ATTRIBUTE1
, CLEB.ATTRIBUTE2 ATTRIBUTE2
, CLEB.ATTRIBUTE3 ATTRIBUTE3
, CLEB.ATTRIBUTE4 ATTRIBUTE4
, CLEB.ATTRIBUTE5 ATTRIBUTE5
, CLEB.ATTRIBUTE6 ATTRIBUTE6
, CLEB.ATTRIBUTE7 ATTRIBUTE7
, CLEB.ATTRIBUTE8 ATTRIBUTE8
, CLEB.ATTRIBUTE9 ATTRIBUTE9
, CLEB.ATTRIBUTE10 ATTRIBUTE10
, CLEB.ATTRIBUTE11 ATTRIBUTE11
, CLEB.ATTRIBUTE12 ATTRIBUTE12
, CLEB.ATTRIBUTE13 ATTRIBUTE13
, CLEB.ATTRIBUTE14 ATTRIBUTE14
, CLEB.ATTRIBUTE15 ATTRIBUTE15
, CLEB.CREATED_BY CREATED_BY
, CLEB.CREATION_DATE CREATION_DATE
, CLEB.LAST_UPDATED_BY LAST_UPDATED_BY
, CLEB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CLEB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CLEB.PRICE_TYPE PRICE_TYPE
, CLEB.CURRENCY_CODE CURRENCY_CODE
, CLEB.CURRENCY_CODE_RENEWED CURRENCY_CODE_RENEWED
, CLEB.DATE_RENEWED DATE_RENEWED
, CLEB.ORIG_SYSTEM_SOURCE_CODE ORIG_SYSTEM_SOURCE_CODE
, CLEB.ORIG_SYSTEM_ID1 ORIG_SYSTEM_ID1
, CLEB.ORIG_SYSTEM_REFERENCE1 ORIG_SYSTEM_REFERENCE1
, CLEB.PROGRAM_APPLICATION_ID
, CLEB.PROGRAM_ID
, CLEB.PROGRAM_UPDATE_DATE
, CLEB.REQUEST_ID
, CLEB.PRICE_LIST_ID
, CLEB.PRICE_LIST_LINE_ID
, CLEB.LINE_LIST_PRICE
, CLEB.ITEM_TO_PRICE_YN
, CLEB.PRICING_DATE
, CLEB.PRICE_BASIS_YN
, CLEB.CONFIG_HEADER_ID
, CLEB.CONFIG_REVISION_NUMBER
, CLEB.CONFIG_COMPLETE_YN
, CLEB.CONFIG_VALID_YN
, CLEB.CONFIG_TOP_MODEL_LINE_ID
, CLEB.CONFIG_ITEM_TYPE
, CLEB.CONFIG_ITEM_ID
, CLEB.SERVICE_ITEM_YN
, CLEB.PH_PRICING_TYPE
, CLEB.PH_PRICE_BREAK_BASIS
, CLEB.PH_MIN_QTY
, CLEB.PH_MIN_AMT
, CLEB.PH_QP_REFERENCE_ID
, CLEB.PH_VALUE
, CLEB.PH_ENFORCE_PRICE_LIST_YN
, CLEB.PH_ADJUSTMENT
, CLEB.PH_INTEGRATED_WITH_QP
, CLEB.CUST_ACCT_ID
, CLEB.BILL_TO_SITE_USE_ID
, CLEB.INV_RULE_ID
, CLEB.LINE_RENEWAL_TYPE_CODE
, CLEB.SHIP_TO_SITE_USE_ID
, CLEB.PAYMENT_TERM_ID
, KLE.ROWID KLE_ROW_ID
, KLE.OBJECT_VERSION_NUMBER KLE_OBJECT_VERSION_NUMBER
, KLE.KLE_ID KLE_ID
, KLE.STY_ID STY_ID
, KLE.PRC_CODE PRC_CODE
, KLE.FCG_CODE FCG_CODE
, KLE.NTY_CODE NTY_CODE
, KLE.ESTIMATED_OEC ESTIMATED_OEC
, KLE.LAO_AMOUNT LAO_AMOUNT
, KLE.TITLE_DATE TITLE_DATE
, KLE.FEE_CHARGE FEE_CHARGE
, KLE.LRS_PERCENT LRS_PERCENT
, KLE.INITIAL_DIRECT_COST INITIAL_DIRECT_COST
, KLE.PERCENT_STAKE PERCENT_STAKE
, KLE.PERCENT PERCENT
, KLE.EVERGREEN_PERCENT EVERGREEN_PERCENT
, KLE.AMOUNT_STAKE AMOUNT_STAKE
, KLE.OCCUPANCY OCCUPANCY
, KLE.COVERAGE COVERAGE
, KLE.RESIDUAL_PERCENTAGE RESIDUAL_PERCENTAGE
, KLE.DATE_LAST_INSPECTION DATE_LAST_INSPECTION
, KLE.DATE_SOLD DATE_SOLD
, KLE.LRV_AMOUNT LRV_AMOUNT
, KLE.CAPITAL_REDUCTION CAPITAL_REDUCTION
, KLE.DATE_NEXT_INSPECTION_DUE DATE_NEXT_INSPECTION_DUE
, KLE.DATE_RESIDUAL_LAST_REVIEW DATE_RESIDUAL_LAST_REVIEW
, KLE.DATE_LAST_REAMORTISATION DATE_LAST_REAMORTISATION
, KLE.VENDOR_ADVANCE_PAID VENDOR_ADVANCE_PAID
, KLE.WEIGHTED_AVERAGE_LIFE WEIGHTED_AVERAGE_LIFE
, KLE.TRADEIN_AMOUNT TRADEIN_AMOUNT
, KLE.BOND_EQUIVALENT_YIELD BOND_EQUIVALENT_YIELD
, KLE.TERMINATION_PURCHASE_AMOUNT TERMINATION_PURCHASE_AMOUNT
, KLE.REFINANCE_AMOUNT REFINANCE_AMOUNT
, KLE.YEAR_BUILT YEAR_BUILT
, KLE.DELIVERED_DATE DELIVERED_DATE
, KLE.CREDIT_TENANT_YN CREDIT_TENANT_YN
, KLE.DATE_LAST_CLEANUP DATE_LAST_CLEANUP
, KLE.YEAR_OF_MANUFACTURE YEAR_OF_MANUFACTURE
, KLE.COVERAGE_RATIO COVERAGE_RATIO
, KLE.REMARKETED_AMOUNT REMARKETED_AMOUNT
, KLE.GROSS_SQUARE_FOOTAGE GROSS_SQUARE_FOOTAGE
, KLE.PRESCRIBED_ASSET_YN PRESCRIBED_ASSET_YN
, KLE.DATE_REMARKETED DATE_REMARKETED
, KLE.NET_RENTABLE NET_RENTABLE
, KLE.REMARKET_MARGIN REMARKET_MARGIN
, KLE.DATE_LETTER_ACCEPTANCE DATE_LETTER_ACCEPTANCE
, KLE.REPURCHASED_AMOUNT REPURCHASED_AMOUNT
, KLE.DATE_COMMITMENT_EXPIRATION DATE_COMMITMENT_EXPIRATION
, KLE.DATE_REPURCHASED DATE_REPURCHASED
, KLE.DATE_APPRAISAL DATE_APPRAISAL
, KLE.RESIDUAL_VALUE RESIDUAL_VALUE
, KLE.APPRAISAL_VALUE APPRAISAL_VALUE
, KLE.SECURED_DEAL_YN SECURED_DEAL_YN
, KLE.GAIN_LOSS GAIN_LOSS
, KLE.FLOOR_AMOUNT FLOOR_AMOUNT
, KLE.RE_LEASE_YN RE_LEASE_YN
, KLE.PREVIOUS_CONTRACT PREVIOUS_CONTRACT
, KLE.TRACKED_RESIDUAL TRACKED_RESIDUAL
, KLE.DATE_TITLE_RECEIVED DATE_TITLE_RECEIVED
, KLE.AMOUNT AMOUNT
, KLE.ATTRIBUTE_CATEGORY KLE_ATTRIBUTE_CATEGORY
, KLE.ATTRIBUTE1 KLE_ATTRIBUTE1
, KLE.ATTRIBUTE2 KLE_ATTRIBUTE2
, KLE.ATTRIBUTE3 KLE_ATTRIBUTE3
, KLE.ATTRIBUTE4 KLE_ATTRIBUTE4
, KLE.ATTRIBUTE5 KLE_ATTRIBUTE5
, KLE.ATTRIBUTE6 KLE_ATTRIBUTE6
, KLE.ATTRIBUTE7 KLE_ATTRIBUTE7
, KLE.ATTRIBUTE8 KLE_ATTRIBUTE8
, KLE.ATTRIBUTE9 KLE_ATTRIBUTE9
, KLE.ATTRIBUTE10 KLE_ATTRIBUTE10
, KLE.ATTRIBUTE11 KLE_ATTRIBUTE11
, KLE.ATTRIBUTE12 KLE_ATTRIBUTE12
, KLE.ATTRIBUTE13 KLE_ATTRIBUTE13
, KLE.ATTRIBUTE14 KLE_ATTRIBUTE14
, KLE.ATTRIBUTE15 KLE_ATTRIBUTE15
, KLE.STY_ID_FOR STY_ID_FOR
, KLE.CLG_ID CLG_ID
, KLE.CREATED_BY KLE_CREATED_BY
, KLE.CREATION_DATE KLE_CREATION_DATE
, KLE.LAST_UPDATED_BY KLE_LAST_UPDATED_BY
, KLE.LAST_UPDATE_DATE KLE_LAST_UPDATE_DATE
, KLE.LAST_UPDATE_LOGIN KLE_LAST_UPDATE_LOGIN
, KLE.DATE_FUNDING DATE_FUNDING
, KLE.DATE_FUNDING_REQUIRED DATE_FUNDING_REQUIRED
, KLE.DATE_ACCEPTED DATE_ACCEPTED
, KLE.DATE_DELIVERY_EXPECTED DATE_DELIVERY_EXPECTED
, KLE.OEC OEC
, KLE.CAPITAL_AMOUNT CAPITAL_AMOUNT
, KLE.RESIDUAL_GRNTY_AMOUNT RESIDUAL_GRNTY_AMOUNT
, KLE.RESIDUAL_CODE RESIDUAL_CODE
, KLE.RVI_PREMIUM RVI_PREMIUM
, KLE.CREDIT_NATURE CREDIT_NATURE
, KLE.CAPITALIZED_INTEREST CAPITALIZED_INTEREST
, KLE.CAPITAL_REDUCTION_PERCENT CAPITAL_REDUCTION_PERCENT
, KLE.DATE_PAY_INVESTOR_START DATE_PAY_INVESTOR_START
, KLE.PAY_INVESTOR_FREQUENCY PAY_INVESTOR_FREQUENCY
, KLE.PAY_INVESTOR_EVENT PAY_INVESTOR_EVENT
, KLE.PAY_INVESTOR_REMITTANCE_DAYS PAY_INVESTOR_REMITTANCE_DAYS
, KLE.FEE_TYPE FEE_TYPE
, KLE.SUBSIDY_ID SUBSIDY_ID
, KLE.SUBSIDY_OVERRIDE_AMOUNT SUBSIDY_OVERRIDE_AMOUNT
, KLE.PRE_TAX_YIELD PRE_TAX_YIELD
, KLE.AFTER_TAX_YIELD AFTER_TAX_YIELD
, KLE.IMPLICIT_INTEREST_RATE IMPLICIT_INTEREST_RATE
, KLE.IMPLICIT_NON_IDC_INTEREST_RATE IMPLICIT_NON_IDC_INTEREST_RATE
, KLE.PRE_TAX_IRR PRE_TAX_IRR
, KLE.AFTER_TAX_IRR AFTER_TAX_IRR
, KLE.SUB_PRE_TAX_YIELD SUB_PRE_TAX_YIELD
, KLE.SUB_AFTER_TAX_YIELD SUB_AFTER_TAX_YIELD
, KLE.SUB_IMPL_INTEREST_RATE SUB_IMPL_INTEREST_RATE
, KLE.SUB_IMPL_NON_IDC_INT_RATE SUB_IMPL_NON_IDC_INT_RATE
, KLE.SUB_PRE_TAX_IRR SUB_PRE_TAX_IRR
, KLE.SUB_AFTER_TAX_IRR SUB_AFTER_TAX_IRR
, KLE.ITEM_INSURANCE_CATEGORY ITEM_INSURANCE_CATEGORY
, KLE.QTE_ID QTE_ID
, KLE.FUNDING_DATE FUNDING_DATE
, KLE.STREAM_TYPE_SUBCLASS STREAM_TYPE_SUBCLASS
, KLE.DATE_FUNDING_EXPECTED DATE_FUNDING_EXPECTED
, KLE.MANUFACTURER_NAME MANUFACTURER_NAME
, KLE.MODEL_NUMBER MODEL_NUMBER
, KLE.DOWN_PAYMENT_RECEIVER_CODE DOWN_PAYMENT_RECEIVER_CODE
, KLE.CAPITALIZE_DOWN_PAYMENT_YN CAPITALIZE_DOWN_PAYMENT_YN
, KLE.FEE_PURPOSE_CODE FEE_PURPOSE_CODE
, KLE.TERMINATION_VALUE TERMINATION_VALUE
, KLE.EXPECTED_ASSET_COST
FROM OKC_K_LINES_B CLEB
, OKC_K_LINES_TL CLET
, OKL_K_LINES KLE
WHERE CLEB.ID = CLET.ID
AND CLET.LANGUAGE = USERENV('LANG')
AND KLE.ID = CLEB.ID
AND CLEB.STS_CODE <> 'ABANDONED'

Columns