[Home] [Help] [Dependency Information]
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 |
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.
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 |
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;
APPS.OKL_LA_REAL_ESTATE_UV is not referenced by any database object
|
|
|