eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: OKL_LA_REAL_ESTATE_UV

Product:	OKL - Lease and Finance Management
Description:	User interface view for asset real estate page
Implementation/DBA Data:	APPS.OKL_LA_REAL_ESTATE_UV

View Text

SELECT KLE.ID ID
, TO_CHAR(KLE.INITIAL_DIRECT_COST) INITIAL_DIRECT_COST
, TO_CHAR(KLE.OCCUPANCY) OCCUPANCY
, TO_CHAR(KLE.COVERAGE) COVERAGE
, KLE.DATE_LAST_INSPECTION DATE_LAST_INSPECTION
, KLE.DATE_NEXT_INSPECTION_DUE DATE_NEXT_INSPECTION_DUE
, TO_CHAR(KLE.WEIGHTED_AVERAGE_LIFE) WEIGHTED_AVERAGE_LIFE
, TO_CHAR(KLE.BOND_EQUIVALENT_YIELD) BOND_EQUIVALENT_YIELD
, TO_CHAR(KLE.REFINANCE_AMOUNT) REFINANCE_AMOUNT
, TO_CHAR(KLE.YEAR_BUILT) YEAR_BUILT
, KLE.CREDIT_TENANT_YN CREDIT_TENANT_YN
, KLE.SECURED_DEAL_YN SECURED_DEAL_YN
, TO_CHAR(KLE.AMOUNT) AMOUNT
, KLE.PRC_CODE PRC_CODE
, KLE.DATE_APPRAISAL DATE_APPRAISAL
, TO_CHAR(KLE.APPRAISAL_VALUE) APPRAISAL_VALUE
, TO_CHAR(KLE.GROSS_SQUARE_FOOTAGE) GROSS_SQUARE_FOOTAGE
, TO_CHAR(KLE.NET_RENTABLE) NET_RENTABLE
, KLE.DATE_LETTER_ACCEPTANCE DATE_LETTER_ACCEPTANCE
, KLE.DATE_COMMITMENT_EXPIRATION DATE_COMMITMENT_EXPIRATION
FROM OKL_K_LINES KLE

Columns

Name
ID
INITIAL_DIRECT_COST
OCCUPANCY
COVERAGE
DATE_LAST_INSPECTION
DATE_NEXT_INSPECTION_DUE
WEIGHTED_AVERAGE_LIFE
BOND_EQUIVALENT_YIELD
REFINANCE_AMOUNT
YEAR_BUILT
CREDIT_TENANT_YN
SECURED_DEAL_YN
AMOUNT
PRC_CODE
DATE_APPRAISAL
APPRAISAL_VALUE
GROSS_SQUARE_FOOTAGE
NET_RENTABLE
DATE_LETTER_ACCEPTANCE
DATE_COMMITMENT_EXPIRATION