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_LEASE_DETAILS_ALL

Object Details

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

PN_LEASE_DETAILS_ALL stores lease dates and accounting information. LEASE_TERMINATION_DATE is the only field which can be changed after the lease is finalized.
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_LEASE_DETAILS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LEASE_DETAIL_ID
PN_LEASE_DETAILS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LEASE_ID LEASE_CHANGE_ID
PN_LEASE_DETAILS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESPONSIBLE_USER
PN_LEASE_DETAILS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EXPENSE_ACCOUNT_ID
PN_LEASE_DETAILS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LEASE_COMMENCEMENT_DATE
PN_LEASE_DETAILS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LEASE_TERMINATION_DATE
PN_LEASE_DETAILS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LEASE_EXECUTION_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
LEASE_DETAIL_ID	NUMBER		Yes	Uniquely identifies the row in this table. The value is populated using the sequence PN_LEASE_DETAILS_S
LEASE_CHANGE_ID	NUMBER		Yes	Associates the lease row in PN_LEASE_CHANGES_ALL where CHANGE_TYPE_LOOKUP_CODE = 'ABSTRACT' with lease details row.
LEASE_ID	NUMBER		Yes	Associates the row in PN_LEASES_ALL with the row in this table
RESPONSIBLE_USER	NUMBER			User id of the user responsible for creating the lease.
EXPENSE_ACCOUNT_ID	NUMBER			Associates the account id in the GL_CODE_COMBINATIONS table with the lease
LEASE_COMMENCEMENT_DATE	DATE			Commencement date of the lease.
LEASE_TERMINATION_DATE	DATE			Termination date of the lease
LEASE_EXECUTION_DATE	DATE			Execution date of the lease
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
ACCRUAL_ACCOUNT_ID	NUMBER	(15)		Code Combination Id for the Accrual Account to be defaulted.
RECEIVABLE_ACCOUNT_ID	NUMBER	(15)		Code Combination Id for the Receivable Account to be defaulted
SEND_ENTRIES	VARCHAR2	(1)		Pass normalized amounts to Payables or Receivables depending upon the Lease Class
TERM_TEMPLATE_ID	NUMBER	(15)		Term Template ID of Term Template, which is associated with lease.
LEASE_EXTENSION_END_DATE	DATE			Lease Status
GROUPING_RULE_ID	NUMBER	(15)		Associates the grouping rule name in PN_PAY_GROUP_RULES_ALL with the lease.

Query Text

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


SELECT LEASE_DETAIL_ID
,      LEASE_CHANGE_ID
,      LEASE_ID
,      RESPONSIBLE_USER
,      EXPENSE_ACCOUNT_ID
,      LEASE_COMMENCEMENT_DATE
,      LEASE_TERMINATION_DATE
,      LEASE_EXECUTION_DATE
,      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
,      ACCRUAL_ACCOUNT_ID
,      RECEIVABLE_ACCOUNT_ID
,      SEND_ENTRIES
,      TERM_TEMPLATE_ID
,      LEASE_EXTENSION_END_DATE
,      GROUPING_RULE_ID
FROM PN.PN_LEASE_DETAILS_ALL;

Dependencies

[top of page]

PN.PN_LEASE_DETAILS_ALL does not reference any database object

PN.PN_LEASE_DETAILS_ALL is referenced by following:

PN: PN_LEASE_DETAILS_ALL#