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_VAR_RENTS_ALL

Object Details

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

Stores variable rent agreement information such as lease associated,variable rent number, critical date information, location.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_VAR_RENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	VAR_RENT_ID
PN_VAR_RENTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LEASE_ID
PN_VAR_RENTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COMMENCEMENT_DATE
PN_VAR_RENTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TERMINATION_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
VAR_RENT_ID	NUMBER		Yes	Uniquely identifies the Variable Rent row.
RENT_NUM	VARCHAR2	(30)		Unique number of a variable rent row. User defined, except when profile option PN: Automatic Variable Rent Number Generation is set to Yes , then PN_VAR_RENTS_S sequence is used to populate this data element.
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).
LEASE_ID	NUMBER		Yes	Associates the lease row in PN_LEASES_ALL with the variable rent row.
LOCATION_ID	NUMBER			Associates the locations row in PN_LOCATIONS_ALL with the variable rent row.
PRORATION_DAYS	NUMBER			Indicates the proration rule chosen for the lease.
PURPOSE_CODE	VARCHAR2	(30)	Yes	Identifies the purpose of the variable rent. The value is derived from lookup_code in FND_LOOKUPS where lookup_type = PN_PAYMENT_PURPOSE_TYPE.
TYPE_CODE	VARCHAR2	(30)	Yes	Identifies the type of the variable rent. The value is derived from lookup_code in FND_LOOKUPS where lookup_type = PN_PAYMENT_TERM_TYPE.
COMMENCEMENT_DATE	DATE		Yes	Start date of the variable rent period.
TERMINATION_DATE	DATE		Yes	End date of the variable rent period.
ABSTRACTED_BY_USER	NUMBER		Yes	User Id of the user who created the variable rent row.
CUMULATIVE_VOL	VARCHAR2	(1)		When checked indicates that volumes are considered cumulative for calculation of variable rent else non-cumulative.
ACCRUAL	VARCHAR2	(1)		When checked indicates that accrued variable rent is calculated in the cumulative volume case.
UOM_CODE	VARCHAR2	(30)	Yes	Unit of Measure.
ROUNDING	VARCHAR2	(30)		Indicates negotitated method of rounding of the calculated variable rent.
INVOICE_ON	VARCHAR2	(30)	Yes	Indicates whether a variable rent amount should be invoiced on forecasted or actual volume histories.
NEGATIVE_RENT	VARCHAR2	(30)	Yes	Indicates whether a calculated variable rent if negative should be ignored,carried forward or applied.
TERM_TEMPLATE_ID	NUMBER			Id of the term template used.
ABATEMENT_AMOUNT	NUMBER			Abatement amount available.
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
CURRENCY_CODE	VARCHAR2	(15)		Currency Code associated with the variable rent agreement.
PRORATION_RULE	VARCHAR2	(30)		Calculation method to be used for partial year.
AGREEMENT_TEMPLATE_ID	NUMBER			Identifier of the agreement template.
CHG_CAL_VAR_RENT_ID	NUMBER			Not used
ORDER_OF_APPL_CODE	VARCHAR2	(30)		Code specifying whether allowances or abatements are to be applied first: (AB=abatement first, AL=allowance first)
EXCESS_ABAT_CODE	VARCHAR2	(30)		Code specifying treatment of excess abatement:(I=ignore, NR=treat as negative rent)

Query Text

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


SELECT VAR_RENT_ID
,      RENT_NUM
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LEASE_ID
,      LOCATION_ID
,      PRORATION_DAYS
,      PURPOSE_CODE
,      TYPE_CODE
,      COMMENCEMENT_DATE
,      TERMINATION_DATE
,      ABSTRACTED_BY_USER
,      CUMULATIVE_VOL
,      ACCRUAL
,      UOM_CODE
,      ROUNDING
,      INVOICE_ON
,      NEGATIVE_RENT
,      TERM_TEMPLATE_ID
,      ABATEMENT_AMOUNT
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ORG_ID
,      CURRENCY_CODE
,      PRORATION_RULE
,      AGREEMENT_TEMPLATE_ID
,      CHG_CAL_VAR_RENT_ID
,      ORDER_OF_APPL_CODE
,      EXCESS_ABAT_CODE
FROM PN.PN_VAR_RENTS_ALL;

Dependencies

[top of page]

PN.PN_VAR_RENTS_ALL does not reference any database object

PN.PN_VAR_RENTS_ALL is referenced by following:

APPS: PN_VAR_RENTS; PN_VAR_RENTS_ALL