[Home] [Help] [Dependency Information]
Object Name: | PN_CONTACT_ASSIGN_HISTORY |
---|---|
Object Type: | TABLE |
Owner: | PN |
FND Design Data: | PN.PN_CONTACT_ASSIGN_HISTORY |
Subobject Name: | |
Status: | VALID |
PN_CONTACT_ASSIGN_HISTORY tracks changes in contacts linked to the lease. A row is created in this table when the contact information is altered by means of an amendment or an edit to the lease.
This table is not partitioned by org.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PN_CONTACT_ASSIGN_HISTORY_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | CONTACT_ASSIGN_HISTORY_ID |
PN_CONTACT_ASSIGN_HISTORY_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CONTACT_ASSIGNMENT_ID |
PN_CONTACT_ASSIGN_HISTORY_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | COMPANY_ID |
PN_CONTACT_ASSIGN_HISTORY_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | COMPANY_SITE_ID |
PN_CONTACT_ASSIGN_HISTORY_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
LEASE_ID
LEASE_CHANGE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CONTACT_ASSIGN_HISTORY_ID | NUMBER | Yes | Uniquely identifies the history record of a contact associated with a location or a lease. | |
NEW_LEASE_CHANGE_ID | NUMBER | Yes | Associates the row in PN_LEASE_CHANGES_ALL with its corresponding contact assignment history row. When a row is modified in PN_CONTACT_ASSIGNMENTS_ALL as a result of an amendment or an edit to the lease, this field is updated with lease_change_id. The purpose is to link the new amendment or edit row with the previous contact assignment row. | |
CONTACT_ASSIGNMENT_ID | NUMBER | Yes | Associates the row in PN_CONTACT_ASSIGNMENTS_ALL with the history row. | |
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). | ||
COMPANY_ID | NUMBER | Yes | Previous association of a company row in PN_COMPANIES_ALL with the history row | |
COMPANY_SITE_ID | NUMBER | Yes | Previous association of a company site row in PN_COMPANY_SITES_ALL with the history row | |
LEASE_ID | NUMBER | Previous association of a lease row in PN_LEASES_ALL with the history row | ||
LEASE_CHANGE_ID | NUMBER | Previous association of a lease, amend or an edit row in PN_LEASE_CHANGES_ALL with the history row | ||
LOCATION_ID | NUMBER | To be used in future. | ||
STATUS | VARCHAR2 | (1) | Yes | To be used in future |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT CONTACT_ASSIGN_HISTORY_ID
, NEW_LEASE_CHANGE_ID
, CONTACT_ASSIGNMENT_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, COMPANY_ID
, COMPANY_SITE_ID
, LEASE_ID
, LEASE_CHANGE_ID
, LOCATION_ID
, STATUS
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM PN.PN_CONTACT_ASSIGN_HISTORY;
PN.PN_CONTACT_ASSIGN_HISTORY does not reference any database object
PN.PN_CONTACT_ASSIGN_HISTORY is referenced by following:
|
|
|