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

TABLE: PN.PN_LEASE_OPTIONS_ITF

Object Details
Object Name: PN_LEASE_OPTIONS_ITF
Object Type: TABLE
Owner: PN
FND Design Data: TablePN.PN_LEASE_OPTIONS_ITF
Subobject Name:
Status: VALID


PN_LEASE_OPTIONS_ITF Interface Table used in creating the RXi Reports.


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
LEASE_ID NUMBER

Uniquely identifies the Lease row.
LEASE_NAME VARCHAR2 (50)
Lease Name.
LEASE_NUMBER VARCHAR2 (30)
Lease Number.
LEASE_COMMENCEMENT_DATE DATE

The date on which the Lease Starts.
LEASE_TERMINATION_DATE DATE

The date on which the Lease Ends.
LEASE_EXECUTION_DATE DATE

The date on which the Lease gets Executed.
LEASE_TERM NUMBER

The term of the Lease.
LEASE_CLASS VARCHAR2 (80)
Identifies the type of Lease Class
LEASE_RESPONSIBLE_USER VARCHAR2 (100)
The Responsible User.
LEASE_STATUS VARCHAR2 (80)
Lease Status.
LEASE_TYPE VARCHAR2 (80)
The type of the Lease.
ESTIMATED_OCCUPANCY_DATE DATE

Estimated Occupancy Date.
ACTUAL_OCCUPANCY_DATE DATE

Actual Occupancy Date.
LOCATION_ID NUMBER

Uniquely identifies the Location row.
LOCATION_TYPE VARCHAR2 (80)
The type of the Location.
LOCATION_NAME VARCHAR2 (30)
Location Name.
LOCATION_CODE VARCHAR2 (90)
Location Code.
SPACE_TYPE VARCHAR2 (80)
Identifies the type of space usage
REGION VARCHAR2 (50)
Region.
PROPERTY_NAME VARCHAR2 (30)
Property Name.
BUILDING_OR_LAND_NAME VARCHAR2 (30)
Building Or Land Name.
FLOOR_OR_PARCEL_NAME VARCHAR2 (30)
Floor Or Parcel Name.
OFFICE_OR_SECTION_NAME VARCHAR2 (30)
Office Or Section Name.
ADDRESS VARCHAR2 (1500)
Address.
COUNTY VARCHAR2 (60)
County.
CITY VARCHAR2 (60)
City.
STATE VARCHAR2 (60)
State.
PROVINCE VARCHAR2 (60)
Province.
ZIP_CODE VARCHAR2 (60)
Zip Code.
COUNTRY VARCHAR2 (60)
Country.
GROSS_AREA NUMBER

Gross Area.
RENTABLE_AREA NUMBER

Rentable Area.
USABLE_AREA NUMBER

Usable Area.
TENURE VARCHAR2 (80)
Tenure.
OPTION_ID NUMBER

Uniquely identifies the Option row.
OPTION_TYPE VARCHAR2 (80)
The type of the option.
OPTION_STATUS VARCHAR2 (80)
Option Status.
OPTION_TERM NUMBER

Option Term.
REFERENCE VARCHAR2 (15)
Reference.
OPTION_NOTICE_REQD VARCHAR2 (1)
Option Notice Required.
OPTION_ACTION_DATE DATE

Option Action Date.
OPTION_SIZE NUMBER

Option Size.
OPTION_COST VARCHAR2 (15)
Option Cost.
UOM_CODE VARCHAR2 (3)
Uom Code.
OPTION_AREA_CHANGE NUMBER

Option Area Change.
OPTION_CURRENCY VARCHAR2 (15)
Option Currency.
OPTION_EXER_START_DATE DATE

Option Exercise Start Date.
OPTION_EXER_END_DATE DATE

Option Exercise End Date.
OPTION_COMM_DATE DATE

Option Commencement Date
OPTION_EXP_DATE DATE

Option Exp Date.
OPTION_COMMENTS VARCHAR2 (2000)
Option Comments.
TEN_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield structue defining column.
TEN_ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment column.
TEN_ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment column.
TEN_ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment column.
TEN_ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment column.
TEN_ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment column.
TEN_ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment column.
TEN_ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment column.
TEN_ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment column.
TEN_ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment column.
TEN_ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment column.
TEN_ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment column.
TEN_ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment column.
TEN_ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment column.
TEN_ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment column.
TEN_ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment column.
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
REQUEST_ID NUMBER
Yes Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
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 does not reference any database object

PN.PN_LEASE_OPTIONS_ITF is referenced by following:

SchemaPN
ViewPN_LEASE_OPTIONS_ITF#