DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.OKL_K_LINES_V

Object Details
Object Name: OKL_K_LINES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_K_LINES_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


OKL_K_LINES stores Oracle Lease Management specific attributes for each contract line. These attributes are not covered in the standard Contracts core line.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Identifier in the database
ID NUMBER
Yes Primary key column
OBJECT_VERSION_NUMBER NUMBER (9) Yes Column used for locking records during updates
KLE_ID NUMBER

Foreign key to table OKL_K_LINES
STY_ID NUMBER

Foreign key to table OKL_STRM_TYPE_B
PRC_CODE VARCHAR2 (30)
Property class code. Foreign key to FND_LOOKUPS
FCG_CODE VARCHAR2 (30)
Funding category code. Foreign key to FND_LOOKUPS
NTY_CODE VARCHAR2 (30)
Concept type code. Foreign key to FND_LOOKUPS
ESTIMATED_OEC NUMBER (14)
Estimated original equipment cost
LAO_AMOUNT NUMBER (14)
Amount of add ons to asset
TITLE_DATE DATE

Date the title was received by the title holder for the asset
FEE_CHARGE NUMBER (14)
Fee Charge
LRS_PERCENT NUMBER (5)
Not used
INITIAL_DIRECT_COST NUMBER (14)
Direct costs such as documentation fee associated with leasing a piece of land, built-area.
PERCENT_STAKE NUMBER (5)
Not used
PERCENT NUMBER (5)
Rate for insurance premium calculation
EVERGREEN_PERCENT NUMBER (5)
Evergreen Percentage
AMOUNT_STAKE NUMBER (14)
Not used
OCCUPANCY NUMBER (20)
The percentage of occupancy of the built facility
COVERAGE NUMBER (14)
The amount of coverage for insurance premium calculation
RESIDUAL_PERCENTAGE NUMBER (5)
The percentage of original equipment cost to be used for residual value
DATE_LAST_INSPECTION DATE

Date when the built area was last inspected
DATE_SOLD DATE

Date syndication was sold to the investor
LRV_AMOUNT NUMBER (14)
Residual value insurance amount
CAPITAL_REDUCTION NUMBER (14)
Currency amount applied to principle
DATE_NEXT_INSPECTION_DUE DATE

Next time the building will be inspected
DATE_RESIDUAL_LAST_REVIEW DATE

Date on which residual was reviewed last time
DATE_LAST_REAMORTISATION DATE

Date on which the amortisation was restarted
VENDOR_ADVANCE_PAID NUMBER (14)
Advance rent paid to the vendor
WEIGHTED_AVERAGE_LIFE NUMBER (30)
Average life the building can stand on the ground
TRADEIN_AMOUNT NUMBER (14)
Trade-in amount for the item/asset
BOND_EQUIVALENT_YIELD NUMBER (5)
The yield on the building lease as a percentage of return from Bonds for the same investment
TERMINATION_PURCHASE_AMOUNT NUMBER (14)
The amount paid for buyout
REFINANCE_AMOUNT NUMBER (14)
The amount used to refinance the lease of the building
YEAR_BUILT NUMBER (4)
Year the building was built.
DELIVERED_DATE DATE

Date in which the item is delivered
CREDIT_TENANT_YN VARCHAR2 (3)
Indicates whether tenant has to be credited or not. Used in real estate contracts only
DATE_LAST_CLEANUP DATE

Catchup when change of interest for fixed payment impacts interest payments
YEAR_OF_MANUFACTURE VARCHAR2 (240)
Year in which the item/asset is manufactured
COVERAGE_RATIO NUMBER (5)
Identifies the debt service coverage of the transaction
REMARKETED_AMOUNT NUMBER (14)
The currency amount received for sale of item
GROSS_SQUARE_FOOTAGE NUMBER (30)
Gross square footage of the building located on the property
PRESCRIBED_ASSET_YN VARCHAR2 (3)
Indicates wheter asset is a prescribed asset or not
DATE_REMARKETED DATE

Date when asset remarketed
NET_RENTABLE NUMBER (14)
Net square footage of the building which tenants will pay rent on
REMARKET_MARGIN NUMBER

The margin on the remarketing amount
DATE_LETTER_ACCEPTANCE DATE

Date the customer signed the acceptance letter.
REPURCHASED_AMOUNT NUMBER (14)
The currency amount received for sale of item to partner
DATE_COMMITMENT_EXPIRATION DATE

Date the commitment expires
DATE_REPURCHASED DATE

Date when asset was repurchased
DATE_APPRAISAL DATE

Appraisal date
RESIDUAL_VALUE NUMBER (20)
Residual value
APPRAISAL_VALUE NUMBER (14)
Appraisal value
SECURED_DEAL_YN VARCHAR2 (3)
Indicates whether this is a secured deal or not
GAIN_LOSS NUMBER (4)
Flag to indicate loss or gain on the leased asset
FLOOR_AMOUNT NUMBER (14)
The absolute minimum one should expect from a repurchase or remarket sale
RE_LEASE_YN VARCHAR2 (3)
Indicates whether asset is a re-leased asset or not
PREVIOUS_CONTRACT VARCHAR2 (40)
Previous Lessors Contract Number
TRACKED_RESIDUAL NUMBER (14)
Field for tracking residual other than what is in the contract
DATE_TITLE_RECEIVED DATE

Date on which a title was received for this asset
AMOUNT NUMBER (14)
Amount
ATTRIBUTE_CATEGORY VARCHAR2 (90)
Descriptive flexfield category column
ATTRIBUTE1 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE2 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE3 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE4 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE5 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE6 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE7 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE8 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE9 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE10 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE11 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE12 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE13 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE14 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE15 VARCHAR2 (450)
Descriptive flexfield column
STY_ID_FOR NUMBER (10)
Not used
CLG_ID NUMBER

Foreign key to table OKL_CNTR_LVLNG_GRPS_B
CREATED_BY NUMBER (15) Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
DATE_FUNDING DATE

Date on which funding is done
DATE_FUNDING_REQUIRED DATE

Date on which funding is required
DATE_ACCEPTED DATE

Acceptance date
DATE_DELIVERY_EXPECTED DATE

Date on which delivery of asset is expected
OEC NUMBER (14)
Original equipment cost of the asset
CAPITAL_AMOUNT NUMBER (14)
Capital amount
RESIDUAL_GRNTY_AMOUNT NUMBER (14)
Residual guaranty amount
RESIDUAL_CODE VARCHAR2 (30)
Residual code
RVI_PREMIUM NUMBER (14)
RVI Premium
CREDIT_NATURE VARCHAR2 (30)
For revolving line of credit indicates wherer the line is 'New', 'Add' or 'Reduce'
CAPITALIZED_INTEREST NUMBER (14)
Amount of capitalized interest
CAPITAL_REDUCTION_PERCENT NUMBER (5)
Capital reduction percentage
DATE_PAY_INVESTOR_START DATE

Investor agreement - date on which payment to investor starts
PAY_INVESTOR_FREQUENCY VARCHAR2 (30)
Investor agreement - investor payment frequency
PAY_INVESTOR_EVENT VARCHAR2 (30)
Investor agreement - event on which paymet to investor starts
PAY_INVESTOR_REMITTANCE_DAYS NUMBER

Investor agreement - investor payment remittance day
FEE_TYPE VARCHAR2 (30)
Fee type for financed fees
SUBSIDY_ID NUMBER

Unique identifier for subsidy. Foreign key to OKL_SUBSIDIES_B.ID
SUBSIDY_OVERRIDE_AMOUNT NUMBER

Subsidy override amount
PRE_TAX_YIELD NUMBER

Pre tax yield
AFTER_TAX_YIELD NUMBER

After tax yield
IMPLICIT_INTEREST_RATE NUMBER

Implicit interest rate
IMPLICIT_NON_IDC_INTEREST_RATE NUMBER

Implicit non-IDC interest rate
PRE_TAX_IRR NUMBER

Pre-tax IRR
AFTER_TAX_IRR NUMBER

After tax IRR
SUB_PRE_TAX_YIELD NUMBER

subsidized pre-tax yield
SUB_AFTER_TAX_YIELD NUMBER

Subsidized after tax yield
SUB_IMPL_INTEREST_RATE NUMBER

Subsidized implicit interest rate
SUB_IMPL_NON_IDC_INT_RATE NUMBER

Subsidized implicit non-IDC interest rate
SUB_PRE_TAX_IRR NUMBER

Subsidized Pe-tax IRR
SUB_AFTER_TAX_IRR NUMBER

Subsidized after tax IRR
ITEM_INSURANCE_CATEGORY NUMBER

Denormalized column to capture the item insurance asset category at the time of asset entry
QTE_ID NUMBER

Rollover Quote Identifier
FUNDING_DATE DATE

Funding Date
STREAM_TYPE_SUBCLASS VARCHAR2 (30)
The subclass of the stream type
DATE_FUNDING_EXPECTED DATE

Date on which funding is expected
MANUFACTURER_NAME VARCHAR2 (30)
Manufacturer name
MODEL_NUMBER VARCHAR2 (40)
Model number
DOWN_PAYMENT_RECEIVER_CODE VARCHAR2 (30)
Down payment receiver code
CAPITALIZE_DOWN_PAYMENT_YN VARCHAR2 (3)
Flag to indicate whether down payment is capitalized or not
FEE_PURPOSE_CODE VARCHAR2 (30)
Fee purpose code
TERMINATION_VALUE NUMBER

Termination value
EXPECTED_ASSET_COST NUMBER

Expected Asset Cost
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      ID
,      OBJECT_VERSION_NUMBER
,      KLE_ID
,      STY_ID
,      PRC_CODE
,      FCG_CODE
,      NTY_CODE
,      ESTIMATED_OEC
,      LAO_AMOUNT
,      TITLE_DATE
,      FEE_CHARGE
,      LRS_PERCENT
,      INITIAL_DIRECT_COST
,      PERCENT_STAKE
,      PERCENT
,      EVERGREEN_PERCENT
,      AMOUNT_STAKE
,      OCCUPANCY
,      COVERAGE
,      RESIDUAL_PERCENTAGE
,      DATE_LAST_INSPECTION
,      DATE_SOLD
,      LRV_AMOUNT
,      CAPITAL_REDUCTION
,      DATE_NEXT_INSPECTION_DUE
,      DATE_RESIDUAL_LAST_REVIEW
,      DATE_LAST_REAMORTISATION
,      VENDOR_ADVANCE_PAID
,      WEIGHTED_AVERAGE_LIFE
,      TRADEIN_AMOUNT
,      BOND_EQUIVALENT_YIELD
,      TERMINATION_PURCHASE_AMOUNT
,      REFINANCE_AMOUNT
,      YEAR_BUILT
,      DELIVERED_DATE
,      CREDIT_TENANT_YN
,      DATE_LAST_CLEANUP
,      YEAR_OF_MANUFACTURE
,      COVERAGE_RATIO
,      REMARKETED_AMOUNT
,      GROSS_SQUARE_FOOTAGE
,      PRESCRIBED_ASSET_YN
,      DATE_REMARKETED
,      NET_RENTABLE
,      REMARKET_MARGIN
,      DATE_LETTER_ACCEPTANCE
,      REPURCHASED_AMOUNT
,      DATE_COMMITMENT_EXPIRATION
,      DATE_REPURCHASED
,      DATE_APPRAISAL
,      RESIDUAL_VALUE
,      APPRAISAL_VALUE
,      SECURED_DEAL_YN
,      GAIN_LOSS
,      FLOOR_AMOUNT
,      RE_LEASE_YN
,      PREVIOUS_CONTRACT
,      TRACKED_RESIDUAL
,      DATE_TITLE_RECEIVED
,      AMOUNT
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      STY_ID_FOR
,      CLG_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      DATE_FUNDING
,      DATE_FUNDING_REQUIRED
,      DATE_ACCEPTED
,      DATE_DELIVERY_EXPECTED
,      OEC
,      CAPITAL_AMOUNT
,      RESIDUAL_GRNTY_AMOUNT
,      RESIDUAL_CODE
,      RVI_PREMIUM
,      CREDIT_NATURE
,      CAPITALIZED_INTEREST
,      CAPITAL_REDUCTION_PERCENT
,      DATE_PAY_INVESTOR_START
,      PAY_INVESTOR_FREQUENCY
,      PAY_INVESTOR_EVENT
,      PAY_INVESTOR_REMITTANCE_DAYS
,      FEE_TYPE
,      SUBSIDY_ID
,      SUBSIDY_OVERRIDE_AMOUNT
,      PRE_TAX_YIELD
,      AFTER_TAX_YIELD
,      IMPLICIT_INTEREST_RATE
,      IMPLICIT_NON_IDC_INTEREST_RATE
,      PRE_TAX_IRR
,      AFTER_TAX_IRR
,      SUB_PRE_TAX_YIELD
,      SUB_AFTER_TAX_YIELD
,      SUB_IMPL_INTEREST_RATE
,      SUB_IMPL_NON_IDC_INT_RATE
,      SUB_PRE_TAX_IRR
,      SUB_AFTER_TAX_IRR
,      ITEM_INSURANCE_CATEGORY
,      QTE_ID
,      FUNDING_DATE
,      STREAM_TYPE_SUBCLASS
,      DATE_FUNDING_EXPECTED
,      MANUFACTURER_NAME
,      MODEL_NUMBER
,      DOWN_PAYMENT_RECEIVER_CODE
,      CAPITALIZE_DOWN_PAYMENT_YN
,      FEE_PURPOSE_CODE
,      TERMINATION_VALUE
,      EXPECTED_ASSET_COST
FROM APPS.OKL_K_LINES_V;

Dependencies

[top of page]

APPS.OKL_K_LINES_V references the following:

SchemaAPPS
SynonymOKL_K_LINES
APPS.OKL_K_LINES_V is referenced by following:

SchemaAPPS
Package BodyOKL_ACD_PVT - show dependent code
Package BodyOKL_ACTIVATE_ASSET_PVT - show dependent code
Package BodyOKL_AM_CALC_QUOTE_STREAM_PVT - show dependent code
Package BodyOKL_AM_CNTRCT_LN_TRMNT_PVT - show dependent code
Package BodyOKL_ART_PVT - show dependent code
Package BodyOKL_ASD_PVT - show dependent code
Package BodyOKL_CONTRACT_PVT - show dependent code
Package BodyOKL_COPY_ASSET_PVT - show dependent code
Package BodyOKL_COPY_CONTRACT_PVT - show dependent code
Package BodyOKL_CREATE_KLE_PVT - show dependent code
PL/SQL PackageOKL_CREATE_STREAMS_PVT - show dependent code
Package BodyOKL_CREDIT_PUB - show dependent code
Package BodyOKL_CS_LEASE_RENEWAL_PVT - show dependent code
Package BodyOKL_CS_PRINCIPAL_PAYDOWN_PVT - show dependent code
Package BodyOKL_EXECUTE_FORMULA_PUB - show dependent code
PL/SQL PackageOKL_EXECUTE_FORMULA_PUB - show dependent code
PL/SQL PackageOKL_EXECUTE_FORMULA_PVT - show dependent code
Package BodyOKL_EXECUTE_FORMULA_PVT - show dependent code
PL/SQL PackageOKL_FORMULAEVALUATE_PUB - show dependent code
Package BodyOKL_FORMULAEVALUATE_PUB - show dependent code
Package BodyOKL_INA_PVT - show dependent code
Package BodyOKL_IPY_PVT - show dependent code
Package BodyOKL_ITI_PVT - show dependent code
Package BodyOKL_KLE_PVT - show dependent code
PL/SQL PackageOKL_KLE_PVT - show dependent code
Package BodyOKL_LA_PAYMENTS_PVT - show dependent code
Package BodyOKL_LA_STREAM_PVT - show dependent code
PL/SQL PackageOKL_MASS_REBOOK_PUB - show dependent code
Package BodyOKL_MASS_REBOOK_PUB - show dependent code
PL/SQL PackageOKL_MASS_REBOOK_PVT - show dependent code
Package BodyOKL_MASS_REBOOK_PVT - show dependent code
Package BodyOKL_OPEN_INTERFACE_PVT - show dependent code
Package BodyOKL_PFL_PVT - show dependent code
Package BodyOKL_POC_PVT - show dependent code
Package BodyOKL_PTC_PVT - show dependent code
PL/SQL PackageOKL_SEC_INVESTOR_PVT - show dependent code
Package BodyOKL_SEEDED_FUNCTIONS_PVT - show dependent code
Package BodyOKL_SFE_PVT - show dependent code
Package BodyOKL_SIL_PVT - show dependent code
Package BodyOKL_SPLIT_ASSET_PVT - show dependent code
Package BodyOKL_SPLIT_CONTRACT_PVT - show dependent code
Package BodyOKL_STM_PVT - show dependent code
Package BodyOKL_TAL_PVT - show dependent code
Package BodyOKL_TCL_PVT - show dependent code
Package BodyOKL_TPL_PVT - show dependent code
Package BodyOKL_TQD_PVT - show dependent code
Package BodyOKL_TQL_PVT - show dependent code