[Home] [Help] [Dependency Information]
Object Name: | PN_LEASE_CHANGES_ALL |
---|---|
Object Type: | TABLE |
Owner: | PN |
FND Design Data: | PN.PN_LEASE_CHANGES_ALL |
Subobject Name: | |
Status: | VALID |
PN_LEASE_CHANGES_ALL stores a link to the lease, and stores the changes made to the lease by amendments and edits. During lease abstraction, a row is created with lease_change_number as null to link it with the row in table PN_LEASES_ALL.
This table stores three types of rows:
1. Lease Abstracted (Link)
2. Lease Amended (lease_change_number is populated)
3. Lease Edited
Technically there is no difference between an amendement row and an edit row. The rows can be distinguished by looking at the value of CHANGE_TYPE_LOOKUP_CODE data element.
The values are :
(a) ABSTRACT
(b) AMEND
(c) EDIT
This table is partitioned by org.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PN_LEASE_CHANGES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | LEASE_CHANGE_ID |
PN_LEASE_CHANGES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LEASE_ID |
PN_LEASE_CHANGES_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LEASE_TRANSACTION_ID |
PN_LEASE_CHANGES_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LEASE_CHANGE_NAME |
PN_LEASE_CHANGES_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ABSTRACTED_BY_USER |
PN_LEASE_CHANGES_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | RESPONSIBLE_USER |
PN_LEASE_CHANGES_N6 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CHANGE_COMMENCEMENT_DATE |
PN_LEASE_CHANGES_N7 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CHANGE_TERMINATION_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEASE_CHANGE_ID | NUMBER | Yes | Uniquely identifies a lease row, amendment row or edit row. The value is populated using sequence PN_LEASE_CHANGES_S. | |
LEASE_ID | NUMBER | Yes | Associates the row in PN_LEASES_ALL with the the row in this table | |
LEASE_TRANSACTION_ID | NUMBER | Yes | Associates the row in PN_TRANSACTIONS_ALL with the row in this table | |
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_CHANGE_NAME | VARCHAR2 | (50) | Amendment Name. The data element is null for a lease row and edit row. | |
LEASE_CHANGE_NUMBER | NUMBER | Amendment number. This is the system-generated number without the database sequence. e.g. Select max (lease_change_number) + 1 from dual for a lease. The data element is null for a lease row and an edit row. | ||
ABSTRACTED_BY_USER | NUMBER | User id of the user who created an amendment. The data element is null for a lease row and an edit row. | ||
RESPONSIBLE_USER | NUMBER | User id of the user who is responsible for maintaining the lease. The data element is null for a lease and edit rows. | ||
CHANGE_COMMENCEMENT_DATE | DATE | Commencement date of the amendment. The data element is null for lease and edit rows. | ||
CHANGE_TERMINATION_DATE | DATE | Termination date of the amendment. The data element is null for lease and edit rows. | ||
CHANGE_TYPE_LOOKUP_CODE | VARCHAR2 | (30) | Type of lease row. Valid values: ABSTRACT, AMEND or EDIT. The value is derived from the lookup_code in FND_LOOKUPS table where lookup_type = 'PN_LEASE_CHANGE_TYPE' | |
CHANGE_EXECUTION_DATE | DATE | Execution date of the amendment. The data element is null for lease and edit row. | ||
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 | |
CUTOFF_DATE | DATE | Date entered by user when expanding or contracting a lease.Terms whose normalization end dates are greater than this date are renormalized. |
Cut, paste (and edit) the following text to query this object:
SELECT LEASE_CHANGE_ID
, LEASE_ID
, LEASE_TRANSACTION_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, LEASE_CHANGE_NAME
, LEASE_CHANGE_NUMBER
, ABSTRACTED_BY_USER
, RESPONSIBLE_USER
, CHANGE_COMMENCEMENT_DATE
, CHANGE_TERMINATION_DATE
, CHANGE_TYPE_LOOKUP_CODE
, CHANGE_EXECUTION_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ORG_ID
, CUTOFF_DATE
FROM PN.PN_LEASE_CHANGES_ALL;
PN.PN_LEASE_CHANGES_ALL does not reference any database object
PN.PN_LEASE_CHANGES_ALL is referenced by following:
|
|
|