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_INDEX_LEASES_ALL

Object Details

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

PN_INDEX_LEASES_ALL stores all the rent increases associated with an existing lease. It also stores the relevant information that determines how rent increases should be calculated.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_INDEX_LEASES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	INDEX_LEASE_NUMBER
PN_INDEX_LEASES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	INDEX_LEASE_ID
PN_INDEX_LEASES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LEASE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
INDEX_LEASE_ID	NUMBER		Yes	Uniquely identifies the Rent Increase row. The value is populated using the sequence PN_INDEX_LEASES_S.
LEASE_ID	NUMBER		Yes	Associates the row in PN_LEASES_ALL with the row in this table.
INDEX_ID	NUMBER		Yes	Associates the row in PN_INDEX_HISTORY_HEADERS with the row in this table.
COMMENCEMENT_DATE	DATE		Yes	Rent Increase Commencement date.
TERMINATION_DATE	DATE		Yes	Rent Increase Termination date.
INDEX_LEASE_NUMBER	VARCHAR2	(100)	Yes	Rent Increase Number. Unique identifier of an Index Lease row. User defined except when the profile option PN: Automatic Index Number Generation is to Yes, then PN_INDEX_LEASES_S is used to populate this data element.
LOCATION_ID	NUMBER			Associates the row in PN_LOCATIONS_ALL with the row in this table.
TERM_TEMPLATE_ID	NUMBER			Associates the row in PN_TERM_TEMPLATES_ALL with the row in this table. Default term template used for payment/billing purposes.
ABSTRACTED_BY	NUMBER			User id of the user who created the Rent Increase row.
ASSESSMENT_DATE	DATE			Date Rent Increase is assessed on.
ASSESSMENT_INTERVAL	NUMBER			Determines how frequently the rent increase is assessed. Has to be a postive whole integer.
SPREAD_FREQUENCY	VARCHAR2	(30)		Determines how the annual invoiced amount is spread over the year.
RELATIONSHIP_DEFAULT	VARCHAR2	(30)		Determines whether the percentage used in the rent increase calculation is user defined basis percentage,Basis Only; index percentage Index Only; the Greater of or Lesser Of the index percentage or the 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.
BASIS_PERCENT_DEFAULT	NUMBER			Default basis percentage.
INITIAL_BASIS	NUMBER			Basis amount used in the first Rent Increase period. Can be user defined also.
BASE_INDEX	NUMBER			Given the Index Type and the Base Year defaults the Base Index from the table PN_INDEX_HISTORY_LINES.
BASE_INDEX_LINE_ID	NUMBER			Associates the INDEX_LINE_ID in PN_INDEX_HISTORY_LINES corresponding to the Index date defined in the Base Year.
INDEX_FINDER_METHOD	VARCHAR2	(30)		Determines the options if the index value is unavailable. Valid values: FINDER_DATE, MOST_RECENT,BACKBILL. The value is derived from the lookup code in FND_LOOKUPS table,where lookup_type= PN_INDEX_FINDER_METHOD.
INDEX_FINDER_MONTHS	NUMBER			Denotes the whole number subtracted from the Date Assessed to determine the Index Finder Date.
NEGATIVE_RENT_TYPE	VARCHAR2	(30)		Determines the options when negative index rent is encountered.Valid values: IGNORE,THIS_PERIOD, NEXT_PERIOD.The value is derived from the lookup code in FND_LOOKUPS table,where lookup_type= PN_INDEX_NEGATIVE_RENT.
INCREASE_ON	VARCHAR2	(30)		Indicates the type of payment/billing term the increase is to be assessed on. The value is derived from the lookup code in FND_LOOKUPS table, where lookup_type= PN_PAYMENT_TERM_TYPE
BASIS_TYPE	VARCHAR2	(30)		Determines how the basis amount is calculated. Valid values:FIXED,ROLLING,COMPOUND. The value is derived from the lookup code in FND_LOOKUPS table,where lookup_type= PN_INDEX_BASIS_TYPE.
REFERENCE_PERIOD	VARCHAR2	(30)		Required to calculate the index percentage. Valid values: BASE_YEAR,PREV_YEAR_ASSMT_DATE_DUR, PREV_YEAR_PERV_CURRENT_CPI.The value is derived from the lookup code in FND_LOOKUPS table, where lookup_type= PN_INDEX_REF_PERIOD.
BASE_YEAR	DATE			Index date used to derive the Base Index value.
LEASED_AREA	NUMBER			Leased Area. Not used
ROUNDING_FLAG	VARCHAR2	(1)		Provides the option to round the payment term amounts.
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
AGREEMENT_CATEGORY	VARCHAR2	(30)		Agreement Descriptive Flexfield structure defining column.
AGREEMENT_ATTRIBUTE1	VARCHAR2	(150)		Agreement Descriptive Flexfield segment column.
AGREEMENT_ATTRIBUTE2	VARCHAR2	(150)		Agreement Descriptive Flexfield segment column.
AGREEMENT_ATTRIBUTE3	VARCHAR2	(150)		Agreement Descriptive Flexfield segment column.
AGREEMENT_ATTRIBUTE4	VARCHAR2	(150)		Agreement Descriptive Flexfield segment column.
AGREEMENT_ATTRIBUTE5	VARCHAR2	(150)		Agreement Descriptive Flexfield segment column.
AGREEMENT_ATTRIBUTE6	VARCHAR2	(150)		Agreement Descriptive Flexfield segment column.
AGREEMENT_ATTRIBUTE7	VARCHAR2	(150)		Agreement Descriptive Flexfield segment column.
AGREEMENT_ATTRIBUTE8	VARCHAR2	(150)		Agreement Descriptive Flexfield segment column.
AGREEMENT_ATTRIBUTE9	VARCHAR2	(150)		Agreement Descriptive Flexfield segment column.
AGREEMENT_ATTRIBUTE10	VARCHAR2	(150)		Agreement Descriptive Flexfield segment column.
AGREEMENT_ATTRIBUTE11	VARCHAR2	(150)		Agreement Descriptive Flexfield segment column.
AGREEMENT_ATTRIBUTE12	VARCHAR2	(150)		Agreement Descriptive Flexfield segment column.
AGREEMENT_ATTRIBUTE13	VARCHAR2	(150)		Agreement Descriptive Flexfield segment column.
AGREEMENT_ATTRIBUTE14	VARCHAR2	(150)		Agreement Descriptive Flexfield segment column.
AGREEMENT_ATTRIBUTE15	VARCHAR2	(150)		Agreement Descriptive Flexfield segment column.
ORG_ID	NUMBER	(15)		Organization identifier
AGGREGATION_FLAG	VARCHAR2	(1)		Determines whether Aggregation is to be used for creating payment terms.
GROSS_FLAG	VARCHAR2	(1)		Determines whether the rent increase is based on all the payment terms rather than on a specific payment term type like base rent.
CURRENCY_CODE	VARCHAR2	(15)		Currency code associated with the index rent agreement
CARRY_FORWARD_FLAG	VARCHAR2	(1)		Identifies if the carry forward functionality is to be enabled for the index rent agreement.
RETAIN_INITIAL_BASIS_FLAG	VARCHAR2	(1)		Determines whether the initial basis should be retained during index rent calculations.
INDEX_MULTIPLIER	NUMBER			Default index multiplier
CONSTRAINT_PRORATION	VARCHAR2	(30)		Not used
VR_NBP_FLAG	VARCHAR2	(1)		Flag indicating whether rent increase is included in natural breakpoint basis.
PRORATION_RULE	VARCHAR2	(30)		Specifies the calculation method for partial periods.
PRORATION_PERIOD_START_DATE	DATE			Proration period start date.

Query Text

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


SELECT INDEX_LEASE_ID
,      LEASE_ID
,      INDEX_ID
,      COMMENCEMENT_DATE
,      TERMINATION_DATE
,      INDEX_LEASE_NUMBER
,      LOCATION_ID
,      TERM_TEMPLATE_ID
,      ABSTRACTED_BY
,      ASSESSMENT_DATE
,      ASSESSMENT_INTERVAL
,      SPREAD_FREQUENCY
,      RELATIONSHIP_DEFAULT
,      BASIS_PERCENT_DEFAULT
,      INITIAL_BASIS
,      BASE_INDEX
,      BASE_INDEX_LINE_ID
,      INDEX_FINDER_METHOD
,      INDEX_FINDER_MONTHS
,      NEGATIVE_RENT_TYPE
,      INCREASE_ON
,      BASIS_TYPE
,      REFERENCE_PERIOD
,      BASE_YEAR
,      LEASED_AREA
,      ROUNDING_FLAG
,      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
,      AGREEMENT_CATEGORY
,      AGREEMENT_ATTRIBUTE1
,      AGREEMENT_ATTRIBUTE2
,      AGREEMENT_ATTRIBUTE3
,      AGREEMENT_ATTRIBUTE4
,      AGREEMENT_ATTRIBUTE5
,      AGREEMENT_ATTRIBUTE6
,      AGREEMENT_ATTRIBUTE7
,      AGREEMENT_ATTRIBUTE8
,      AGREEMENT_ATTRIBUTE9
,      AGREEMENT_ATTRIBUTE10
,      AGREEMENT_ATTRIBUTE11
,      AGREEMENT_ATTRIBUTE12
,      AGREEMENT_ATTRIBUTE13
,      AGREEMENT_ATTRIBUTE14
,      AGREEMENT_ATTRIBUTE15
,      ORG_ID
,      AGGREGATION_FLAG
,      GROSS_FLAG
,      CURRENCY_CODE
,      CARRY_FORWARD_FLAG
,      RETAIN_INITIAL_BASIS_FLAG
,      INDEX_MULTIPLIER
,      CONSTRAINT_PRORATION
,      VR_NBP_FLAG
,      PRORATION_RULE
,      PRORATION_PERIOD_START_DATE
FROM PN.PN_INDEX_LEASES_ALL;

Dependencies

[top of page]

PN.PN_INDEX_LEASES_ALL does not reference any database object

PN.PN_INDEX_LEASES_ALL is referenced by following:

PN: PN_INDEX_LEASES_ALL#