[Home] [Help] [Dependency Information]
Object Name: | PN_INDEX_LEASE_CONSTRAINTS_ALL |
---|---|
Object Type: | TABLE |
Owner: | PN |
FND Design Data: | PN.PN_INDEX_LEASE_CONSTRAINTS_ALL |
Subobject Name: | |
Status: | VALID |
PN_INDEX_LEASE_CONSTRAINTS_ALL stores the constraints that apply to the rent increase. Maximum or minimum constraints can be specified on the rent increase from period to period or on the rent due. This table is partitioned by org.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PN_INDEX_LEASE_CONSTRAINTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | INDEX_CONSTRAINT_ID |
PN_INDEX_LEASE_CONSTRAINTS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | INDEX_LEASE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INDEX_CONSTRAINT_ID | NUMBER | Yes | Uniquely identifies the Index Lease constraint row.The value is populated using sequence PN_INDEX_LEASE_CONSTRAINTS_S. | |
INDEX_LEASE_ID | NUMBER | Yes | Associates the row in PN_INDEX_LEASES_ALL with the row in this table. | |
SCOPE | VARCHAR2 | (30) | Yes | Determines if the constraints are applied on the rent increase from period to period or on the rent due.Valid values: PERIOD_TO_PERIOD,RENT_DUE.The value is derived from the lookup code in FND_LOOKUPS table, where lookup_type= PN_INDEX_CONSTRAINT. |
MINIMUM_AMOUNT | NUMBER | Minimum amount constraint. Mutually exclusive with Minimum percentage constraint. | ||
MAXIMUM_AMOUNT | NUMBER | Maximum amount constraint.Mutually exclusive with Maximum percentage constraint. | ||
MINIMUM_PERCENT | NUMBER | Minimum percentage increase constraint. Mutually exclusive with Minimum amount constraint. | ||
MAXIMUM_PERCENT | NUMBER | Maximum percentage increase constraint. Mutually exclusive with Maximum amount constraint. | ||
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). | ||
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 |
Cut, paste (and edit) the following text to query this object:
SELECT INDEX_CONSTRAINT_ID
, INDEX_LEASE_ID
, SCOPE
, MINIMUM_AMOUNT
, MAXIMUM_AMOUNT
, MINIMUM_PERCENT
, MAXIMUM_PERCENT
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ORG_ID
FROM PN.PN_INDEX_LEASE_CONSTRAINTS_ALL;
PN.PN_INDEX_LEASE_CONSTRAINTS_ALL does not reference any database object
PN.PN_INDEX_LEASE_CONSTRAINTS_ALL is referenced by following:
|
|
|