[Home] [Help] [Dependency Information]
Object Name: | IES_PANEL_DATA |
---|---|
Object Type: | TABLE |
Owner: | IES |
FND Design Data: | IES.IES_PANEL_DATA |
Subobject Name: | |
Status: | VALID |
At the end of an interaction, the Scripting Engine writes the list of panels that were accessed during the script, along with the start and end times for each panel, known as "footprinting" data, to the IES_PANEL_DATA table. Each time that a panel is either added or simply enabled will count as a separate record in the IES_PANEL_DATA table.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IES_PANEL_DATA_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TRANSACTION_ID |
IES_PANEL_DATA_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PANEL_ID |
IES_PANEL_DATA_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PANEL_DATA_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PANEL_DATA_ID | NUMBER | Yes | Unique Identifier for Panel Data | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Standard Who column | ||
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Standard Who column | ||
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
PANEL_ID | NUMBER | Yes | Foreign key from IES_PANELS | |
TRANSACTION_ID | NUMBER | Yes | Foreign key from IES_TRANSACTIONS | |
ELAPSED_TIME | NUMBER | Stores the number of milliseconds that the Panel was activated for that instance | ||
SEQUENCE_NUMBER | NUMBER | Order/Sequence of panel navigation in the script | ||
DELETED_STATUS | NUMBER | Yes | Status to indicate if a panel was deleted due to a change in the path during the execution of the script | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield | |
SECURITY_GROUP_ID | NUMBER | (15) | Used in hosted environments | |
OBJECT_VERSION_NUMBER | NUMBER | Used in hosted environments |
Cut, paste (and edit) the following text to query this object:
SELECT PANEL_DATA_ID
, CREATED_BY
, LAST_UPDATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PANEL_ID
, TRANSACTION_ID
, ELAPSED_TIME
, SEQUENCE_NUMBER
, DELETED_STATUS
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER
FROM IES.IES_PANEL_DATA;
IES.IES_PANEL_DATA does not reference any database object
IES.IES_PANEL_DATA is referenced by following:
|
|
|