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.

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

VIEW: APPS.OKL_LA_REAL_ESTATE_UV

Object Details

Object Name:	OKL_LA_REAL_ESTATE_UV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_LA_REAL_ESTATE_UV
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	Unique identifier for real estate
INITIAL_DIRECT_COST	VARCHAR2	(40)		Initial direct cost
OCCUPANCY	VARCHAR2	(40)		Occupancy
COVERAGE	VARCHAR2	(40)		Coverage
DATE_LAST_INSPECTION	DATE			Date on which last inspection was done
DATE_NEXT_INSPECTION_DUE	DATE			Date on which next inspection is due
WEIGHTED_AVERAGE_LIFE	VARCHAR2	(40)		Weighted average life
BOND_EQUIVALENT_YIELD	VARCHAR2	(40)		Bond equivalent yield
REFINANCE_AMOUNT	VARCHAR2	(40)		Refinance amount
YEAR_BUILT	VARCHAR2	(0)		Year built
CREDIT_TENANT_YN	VARCHAR2	(3)		Credit tenant flag
SECURED_DEAL_YN	VARCHAR2	(3)		Secured deal flag
AMOUNT	VARCHAR2	(40)		Amount
PRC_CODE	VARCHAR2	(30)		Prc Code
DATE_APPRAISAL	DATE			Date appraisal
APPRAISAL_VALUE	VARCHAR2	(40)		Appraisal value
GROSS_SQUARE_FOOTAGE	VARCHAR2	(40)		Gross square footage
NET_RENTABLE	VARCHAR2	(40)		Net rentable
DATE_LETTER_ACCEPTANCE	DATE			Date letter acceptance
DATE_COMMITMENT_EXPIRATION	DATE			Date commitment expiration
VEND_ID1	VARCHAR2	(40)		Vendor identifier 1
VEND_ID2	VARCHAR2	(200)		Vendor Identifier 2
VENDOR_NAME	VARCHAR2	(240)		Vendor name
ITEM_ID1	VARCHAR2	(0)		Inventory item identifier
ITEM_ID2	VARCHAR2	(0)		Inventory organizaton identifier
ITEM_NAME	VARCHAR2	(0)		Inventory item description
DNZ_CHR_ID	NUMBER		Yes	Contract heaer identifier
PARTY_ID	NUMBER			Lessor party identifier
LSE_ID	NUMBER		Yes	Contract line style identifier
ASSET_NUMBER	VARCHAR2	(150)		Asset number
DESCRIPTION	VARCHAR2	(1995)		Asset description
PARTY_SITE_ID	VARCHAR2	(0)		Party install site identifier
IB_ADDRESS	VARCHAR2	(0)		Install site address
CHR_PARTY_ID	VARCHAR2	(0)		Contract Party identifier
MODALID	VARCHAR2	(0)		Model sub-line identifier
FAID	VARCHAR2	(0)		Fixed asset subline identifier
IBID	VARCHAR2	(0)		Installed base sub-line identifier
KHRCURRENCYCODE	VARCHAR2	(0)		Contract currency code
ORGID	VARCHAR2	(0)		Organization identifier

Query Text

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


SELECT 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
,      VEND_ID1
,      VEND_ID2
,      VENDOR_NAME
,      ITEM_ID1
,      ITEM_ID2
,      ITEM_NAME
,      DNZ_CHR_ID
,      PARTY_ID
,      LSE_ID
,      ASSET_NUMBER
,      DESCRIPTION
,      PARTY_SITE_ID
,      IB_ADDRESS
,      CHR_PARTY_ID
,      MODALID
,      FAID
,      IBID
,      KHRCURRENCYCODE
,      ORGID
FROM APPS.OKL_LA_REAL_ESTATE_UV;

Dependencies

[top of page]

APPS.OKL_LA_REAL_ESTATE_UV references the following:

APPS: OKC_K_LINES_B; OKC_K_LINES_TL; OKC_K_PARTY_ROLES_B; OKL_K_LINES; PO_VENDORS

APPS.OKL_LA_REAL_ESTATE_UV is not referenced by any database object