[Home] [Help] [Dependency Information]
Object Name: | PN_INDEX_LEASE_PERIODS_ALL |
---|---|
Object Type: | TABLE |
Owner: | PN |
FND Design Data: | PN.PN_INDEX_LEASE_PERIODS_ALL |
Subobject Name: | |
Status: | VALID |
PN_INDEX_LEASE_PERIODS_ALL stores the relevant details associated with all the rent increase periods. Details such as the assessment date,the basis amount,the constrained and unconstrained rent increase amount etc are held in this table.This table is partitioned by org.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PN_INDEX_LEASE_PERIODS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | INDEX_PERIOD_ID |
PN_INDEX_LEASE_PERIODS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
INDEX_LEASE_ID
ASSESSMENT_DATE |
PN_INDEX_LEASE_PERIODS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CURRENT_INDEX_LINE_ID |
PN_INDEX_LEASE_PERIODS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PREVIOUS_INDEX_LINE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INDEX_PERIOD_ID | NUMBER | Yes | Uniquely identifies the Index Period row.The value is populated using sequence PN_INDEX_LEASE_PERIODS_S. | |
INDEX_LEASE_ID | NUMBER | Yes | Associates the row in PN_INDEX_LEASES_ALL with the row in this table. | |
LINE_NUMBER | NUMBER | Yes | Line number of the Index Lease period. | |
ASSESSMENT_DATE | DATE | Yes | Date the rent increase is assessed on. | |
BASIS_START_DATE | DATE | Period Basis start date. | ||
BASIS_END_DATE | DATE | Period Basis end date. | ||
INDEX_FINDER_DATE | DATE | Period Index Finder date. | ||
CURRENT_INDEX_LINE_ID | NUMBER | Associates the INDEX_LINE_ID in PN_INDEX_HISTORY_LINES corresponding to the current index finder date. | ||
CURRENT_INDEX_LINE_VALUE | NUMBER | Index value associated with the current index finder date. | ||
PREVIOUS_INDEX_LINE_ID | NUMBER | Associates the INDEX_LINE_ID in PN_INDEX_HISTORY_LINES corresponding to the previous index finder date. | ||
PREVIOUS_INDEX_LINE_VALUE | NUMBER | Index value of the previous index finder date. | ||
CURRENT_BASIS | NUMBER | The current basis amount is calculated as the sum of schedule items lying between the basis start date and basis end date. | ||
RELATIONSHIP | VARCHAR2 | (30) | Determines whether the percentage calculated is a basis percentage, Basis Only; index percentage Index Only; the Greater of or Lesser Of the index percentage or Basis percentage. Valid values: GREATER_OF,LESSER_OF,BASIS_ONLY, INDEX_ONLY. The value is derived from the lookup code in FND_LOOKUPS table, where lookup_type= PN_INDEX_RELATION. | |
INDEX_PERCENT_CHANGE | NUMBER | System Calculated Index Percentage. | ||
BASIS_PERCENT_CHANGE | NUMBER | Basis percentage. | ||
UNCONSTRAINT_RENT_DUE | NUMBER | Unconstrained rent increase amount. | ||
CONSTRAINT_RENT_DUE | NUMBER | Rent increase amount after constraints have been applied. | ||
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 | |
CARRY_FORWARD_AMOUNT | NUMBER | Stores the carry forward amount available to the next period. | ||
CONSTRAINT_APPLIED_AMOUNT | NUMBER | Stores the amount of the minimum or maximum constraint applied to the unconstrained rent due for the period. | ||
CARRY_FORWARD_PERCENT | NUMBER | Stores the carry forward percentage available to the next period | ||
CONSTRAINT_APPLIED_PERCENT | NUMBER | Stores the rcentage of the minimum or maximum constraint | ||
INDEX_MULTIPLIER | NUMBER | Index multiplier |
Cut, paste (and edit) the following text to query this object:
SELECT INDEX_PERIOD_ID
, INDEX_LEASE_ID
, LINE_NUMBER
, ASSESSMENT_DATE
, BASIS_START_DATE
, BASIS_END_DATE
, INDEX_FINDER_DATE
, CURRENT_INDEX_LINE_ID
, CURRENT_INDEX_LINE_VALUE
, PREVIOUS_INDEX_LINE_ID
, PREVIOUS_INDEX_LINE_VALUE
, CURRENT_BASIS
, RELATIONSHIP
, INDEX_PERCENT_CHANGE
, BASIS_PERCENT_CHANGE
, UNCONSTRAINT_RENT_DUE
, CONSTRAINT_RENT_DUE
, 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
, CARRY_FORWARD_AMOUNT
, CONSTRAINT_APPLIED_AMOUNT
, CARRY_FORWARD_PERCENT
, CONSTRAINT_APPLIED_PERCENT
, INDEX_MULTIPLIER
FROM PN.PN_INDEX_LEASE_PERIODS_ALL;
PN.PN_INDEX_LEASE_PERIODS_ALL does not reference any database object
PN.PN_INDEX_LEASE_PERIODS_ALL is referenced by following:
|
|
|