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]

TABLE: PN.PN_TENANCIES_ALL

Object Details

Object Name:	PN_TENANCIES_ALL
Object Type:	TABLE
Owner:	PN
FND Design Data:	PN.PN_TENANCIES_ALL
Subobject Name:
Status:	VALID

PN_TENANCIES_ALL stores information on leased or subleased locations. The table captures the tenancy occupancy and expiration dates along with additional lease clauses.
This table is partitioned by org.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PN_TENANCIES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TENANCY_ID
PN_TENANCIES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOCATION_ID
PN_TENANCIES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LEASE_ID LEASE_CHANGE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TENANCY_ID	NUMBER		Yes	Uniquely identifies the tenancy in a lease. The value is populated using sequence PN_TENANCIES_S
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LOCATION_ID	NUMBER		Yes	Associates the location in PN_LOCATIONS_ALL with the tenancy row
LEASE_ID	NUMBER		Yes	Associates the lease row in PN_LEASES_ALL with the tenancy row
LEASE_CHANGE_ID	NUMBER		Yes	Associates the lease, amend or edit row in PN_LEASE_CHANGES_ALL with the tenancy row
TENANCY_USAGE_LOOKUP_CODE	VARCHAR2	(30)	Yes	The type of tenancy usage, such as office space, retail space, etc. The value is derived from lookup_code in FND_LOOKUPS where lookup_type = 'PN_TENANCY_USAGE_TYPE'
PRIMARY_FLAG	VARCHAR2	(30)	Yes	Identifies whether the location occupied is primary or not. Valid values: Y - Primary, N - Not Primary
ESTIMATED_OCCUPANCY_DATE	DATE			Estimated occupancy date
OCCUPANCY_DATE	DATE			Occupancy date
EXPIRATION_DATE	DATE			Expiration date
ASSIGNABLE_FLAG	VARCHAR2	(30)		Identifies whether the location in tenancy is assignable or not. Valid values: Y - Assignable, N - Not Assignable
SUBLEASEABLE_FLAG	VARCHAR2	(30)		Identify whether the location in tenancy can be subleased or not. Valid values: Y - Subleaseable, N- Not Subleaseable
TENANTS_PROPORTIONATE_SHARE	NUMBER			Tenant's proportionate share of the location in tenancy
STATUS	VARCHAR2	(1)	Yes	Identifies whether the tenancy row is active or inactive. Valid values: A - Active, I - Inactive
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
ORG_ID	NUMBER	(15)		Organization identifier
RECOVERY_TYPE_CODE	VARCHAR2	(30)		Identifies the type of a tenant for recovery purposes
RECOVERY_SPACE_STD_CODE	VARCHAR2	(30)		Identifies the type of space for recovery purposes
FIN_OBLIG_END_DATE	DATE			Date until which the customer is financially responsible for recovery charges
CUSTOMER_ID	NUMBER	(15)		Identifies the customer occupying the location
CUSTOMER_SITE_USE_ID	NUMBER	(15)		Identifies the customer bill site for recovery purposes
LEASE_RENTABLE_AREA	NUMBER			Rentable area for the lease.
LEASE_USABLE_AREA	NUMBER			Usable area for the lease.
LEASE_ASSIGNABLE_AREA	NUMBER			Assignable area for the lease.
LEASE_LOAD_FACTOR	NUMBER			Load factor for the lease.
LOCATION_RENTABLE_AREA	NUMBER			Rentable area for the location.
LOCATION_USABLE_AREA	NUMBER			Usable area for the location.
LOCATION_ASSIGNABLE_AREA	NUMBER			Assignable area for the location.
LOCATION_LOAD_FACTOR	NUMBER			Load factor for the location.
ALLOCATED_AREA	NUMBER			Area of location occupied by the tenant
ALLOCATED_AREA_PCT	NUMBER			Percent location occupied by the tenant

Query Text

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


SELECT TENANCY_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LOCATION_ID
,      LEASE_ID
,      LEASE_CHANGE_ID
,      TENANCY_USAGE_LOOKUP_CODE
,      PRIMARY_FLAG
,      ESTIMATED_OCCUPANCY_DATE
,      OCCUPANCY_DATE
,      EXPIRATION_DATE
,      ASSIGNABLE_FLAG
,      SUBLEASEABLE_FLAG
,      TENANTS_PROPORTIONATE_SHARE
,      STATUS
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ORG_ID
,      RECOVERY_TYPE_CODE
,      RECOVERY_SPACE_STD_CODE
,      FIN_OBLIG_END_DATE
,      CUSTOMER_ID
,      CUSTOMER_SITE_USE_ID
,      LEASE_RENTABLE_AREA
,      LEASE_USABLE_AREA
,      LEASE_ASSIGNABLE_AREA
,      LEASE_LOAD_FACTOR
,      LOCATION_RENTABLE_AREA
,      LOCATION_USABLE_AREA
,      LOCATION_ASSIGNABLE_AREA
,      LOCATION_LOAD_FACTOR
,      ALLOCATED_AREA
,      ALLOCATED_AREA_PCT
FROM PN.PN_TENANCIES_ALL;

Dependencies

[top of page]

PN.PN_TENANCIES_ALL does not reference any database object

PN.PN_TENANCIES_ALL is referenced by following:

PN: PN_TENANCIES_ALL#