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

TABLE: PN.PN_LEASES_ALL

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


PN_LEASES_ALL stores lease information such as the name, number, type, class, and status of the lease, and the name of the user who abstracted the lease. After the lease is finalized, the data elements are protected against updates. The lease classes are Direct, Sublease, and Third Party.
Direct (Tenant pays rent to landlord)
Sublease (Tenant pays rent and also collects rent from subtenant)
Third Party (Landlord collects rent from tenant)
This table is partitioned by org.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PN_LEASES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLEASE_ID
PN_LEASES_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLEASE_NUM
PN_LEASES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnNAME
PN_LEASES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARENT_LEASE_ID
Columns
Name Datatype Length Mandatory Comments
LEASE_ID NUMBER
Yes Uniquely identifies the lease row. The value is populated using sequence PN_LEASES_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).
NAME VARCHAR2 (50) Yes Name of the lease
LEASE_NUM VARCHAR2 (30) Yes Lease number. Unique identifier of a lease row. User defined, except when profile option PN: Automatic Lease Number Generation is set to "Yes", then PN_LEASES_NUM_S sequence is used to populate this data element.
PARENT_LEASE_ID NUMBER

Identifies the parent or master lease for the lease. LEASE_ID is used to populate this data element.
ADDRESS_LOCATION_ID NUMBER

Obsolete. To be deleted.
LEASE_TYPE_CODE VARCHAR2 (30) Yes Identifies the type of lease, such as Net, Gross, etc. The value is derived from the lookup_code in FND_LOOKUPS table, where lookup_type = 'PN_LEASE_TYPE.
PAYMENT_TERM_PRORATION_RULE NUMBER

Defines the rule to determine the number of days per year in order to generate rent schedules. The year can be represented with 365 days or with 360 days.
ABSTRACTED_BY_USER NUMBER
Yes User id of the user who created the lease.
COMMENTS VARCHAR2 (240)
Obsolete. To be deleted
STATUS VARCHAR2 (1)
Identifies the status of the lease. Valid values: D - Draft, F- Final. After the lease is finalized, all the data elements in this table are restricted against update.
ORG_ID NUMBER (15)
Organization identifier
LEASE_CLASS_CODE VARCHAR2 (30) Yes Identifies the class of the lease. Valid values: DIRECT, SUB_LEASE, THIRD_PARTY. The value is derived from the lookup_code in FND_LOOKUPS table, where lookup_type = PN_LEASE_CLASS.
LEASE_STATUS VARCHAR2 (30) Yes Lease Status
LOCATION_ID NUMBER (15)
Primary location associated with a lease
CUSTOMER_ID NUMBER (15)
Customer associated with a lease
Query Text

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


SELECT LEASE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      NAME
,      LEASE_NUM
,      PARENT_LEASE_ID
,      ADDRESS_LOCATION_ID
,      LEASE_TYPE_CODE
,      PAYMENT_TERM_PRORATION_RULE
,      ABSTRACTED_BY_USER
,      COMMENTS
,      STATUS
,      ORG_ID
,      LEASE_CLASS_CODE
,      LEASE_STATUS
,      LOCATION_ID
,      CUSTOMER_ID
FROM PN.PN_LEASES_ALL;

Dependencies

[top of page]

PN.PN_LEASES_ALL does not reference any database object

PN.PN_LEASES_ALL is referenced by following:

SchemaAPPS
SynonymPN_LEASES
SynonymPN_LEASES_ALL