Skip to content

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

VIEW: PN.PN_LEASE_OPTIONS_ITF#

Object Details
Object Name: PN_LEASE_OPTIONS_ITF#
Object Type: VIEW
Owner: PN
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
LEASE_ID NUMBER

LEASE_NAME VARCHAR2 (50)
LEASE_NUMBER VARCHAR2 (30)
LEASE_COMMENCEMENT_DATE DATE

LEASE_TERMINATION_DATE DATE

LEASE_EXECUTION_DATE DATE

LEASE_TERM NUMBER

LEASE_CLASS VARCHAR2 (80)
LEASE_RESPONSIBLE_USER VARCHAR2 (100)
LEASE_STATUS VARCHAR2 (80)
LEASE_TYPE VARCHAR2 (80)
ESTIMATED_OCCUPANCY_DATE DATE

ACTUAL_OCCUPANCY_DATE DATE

LOCATION_ID NUMBER

LOCATION_TYPE VARCHAR2 (80)
LOCATION_NAME VARCHAR2 (30)
LOCATION_CODE VARCHAR2 (90)
SPACE_TYPE VARCHAR2 (80)
REGION VARCHAR2 (50)
PROPERTY_NAME VARCHAR2 (30)
BUILDING_OR_LAND_NAME VARCHAR2 (30)
FLOOR_OR_PARCEL_NAME VARCHAR2 (30)
OFFICE_OR_SECTION_NAME VARCHAR2 (30)
ADDRESS VARCHAR2 (1500)
COUNTY VARCHAR2 (60)
CITY VARCHAR2 (60)
STATE VARCHAR2 (60)
PROVINCE VARCHAR2 (60)
ZIP_CODE VARCHAR2 (60)
COUNTRY VARCHAR2 (60)
GROSS_AREA NUMBER

RENTABLE_AREA NUMBER

USABLE_AREA NUMBER

TENURE VARCHAR2 (80)
OPTION_ID NUMBER

OPTION_TYPE VARCHAR2 (80)
OPTION_STATUS VARCHAR2 (80)
OPTION_TERM NUMBER

REFERENCE VARCHAR2 (15)
OPTION_NOTICE_REQD VARCHAR2 (1)
OPTION_ACTION_DATE DATE

OPTION_SIZE NUMBER

OPTION_COST VARCHAR2 (15)
UOM_CODE VARCHAR2 (3)
OPTION_AREA_CHANGE NUMBER

OPTION_CURRENCY VARCHAR2 (15)
OPTION_EXER_START_DATE DATE

OPTION_EXER_END_DATE DATE

OPTION_COMM_DATE DATE

OPTION_EXP_DATE DATE

OPTION_COMMENTS VARCHAR2 (2000)
TEN_ATTRIBUTE_CATEGORY VARCHAR2 (30)
TEN_ATTRIBUTE1 VARCHAR2 (150)
TEN_ATTRIBUTE2 VARCHAR2 (150)
TEN_ATTRIBUTE3 VARCHAR2 (150)
TEN_ATTRIBUTE4 VARCHAR2 (150)
TEN_ATTRIBUTE5 VARCHAR2 (150)
TEN_ATTRIBUTE6 VARCHAR2 (150)
TEN_ATTRIBUTE7 VARCHAR2 (150)
TEN_ATTRIBUTE8 VARCHAR2 (150)
TEN_ATTRIBUTE9 VARCHAR2 (150)
TEN_ATTRIBUTE10 VARCHAR2 (150)
TEN_ATTRIBUTE11 VARCHAR2 (150)
TEN_ATTRIBUTE12 VARCHAR2 (150)
TEN_ATTRIBUTE13 VARCHAR2 (150)
TEN_ATTRIBUTE14 VARCHAR2 (150)
TEN_ATTRIBUTE15 VARCHAR2 (150)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
REQUEST_ID NUMBER
Yes
Query Text

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


SELECT LEASE_ID
,      LEASE_NAME
,      LEASE_NUMBER
,      LEASE_COMMENCEMENT_DATE
,      LEASE_TERMINATION_DATE
,      LEASE_EXECUTION_DATE
,      LEASE_TERM
,      LEASE_CLASS
,      LEASE_RESPONSIBLE_USER
,      LEASE_STATUS
,      LEASE_TYPE
,      ESTIMATED_OCCUPANCY_DATE
,      ACTUAL_OCCUPANCY_DATE
,      LOCATION_ID
,      LOCATION_TYPE
,      LOCATION_NAME
,      LOCATION_CODE
,      SPACE_TYPE
,      REGION
,      PROPERTY_NAME
,      BUILDING_OR_LAND_NAME
,      FLOOR_OR_PARCEL_NAME
,      OFFICE_OR_SECTION_NAME
,      ADDRESS
,      COUNTY
,      CITY
,      STATE
,      PROVINCE
,      ZIP_CODE
,      COUNTRY
,      GROSS_AREA
,      RENTABLE_AREA
,      USABLE_AREA
,      TENURE
,      OPTION_ID
,      OPTION_TYPE
,      OPTION_STATUS
,      OPTION_TERM
,      REFERENCE
,      OPTION_NOTICE_REQD
,      OPTION_ACTION_DATE
,      OPTION_SIZE
,      OPTION_COST
,      UOM_CODE
,      OPTION_AREA_CHANGE
,      OPTION_CURRENCY
,      OPTION_EXER_START_DATE
,      OPTION_EXER_END_DATE
,      OPTION_COMM_DATE
,      OPTION_EXP_DATE
,      OPTION_COMMENTS
,      TEN_ATTRIBUTE_CATEGORY
,      TEN_ATTRIBUTE1
,      TEN_ATTRIBUTE2
,      TEN_ATTRIBUTE3
,      TEN_ATTRIBUTE4
,      TEN_ATTRIBUTE5
,      TEN_ATTRIBUTE6
,      TEN_ATTRIBUTE7
,      TEN_ATTRIBUTE8
,      TEN_ATTRIBUTE9
,      TEN_ATTRIBUTE10
,      TEN_ATTRIBUTE11
,      TEN_ATTRIBUTE12
,      TEN_ATTRIBUTE13
,      TEN_ATTRIBUTE14
,      TEN_ATTRIBUTE15
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      REQUEST_ID
FROM PN.PN_LEASE_OPTIONS_ITF#;

Dependencies

[top of page]

PN.PN_LEASE_OPTIONS_ITF# references the following:

SchemaPN
TablePN_LEASE_OPTIONS_ITF
PN.PN_LEASE_OPTIONS_ITF# is referenced by following:

SchemaAPPS
SynonymPN_LEASE_OPTIONS_ITF