[Home] [Help] [Dependency Information]
Object Name: | IES_DEPLOYED_SCRIPTS |
---|---|
Object Type: | TABLE |
Owner: | IES |
FND Design Data: | IES.IES_DEPLOYED_SCRIPTS |
Subobject Name: | |
Status: | VALID |
This table contains all deployed scripts in the form of a binary file stored in the database. Also specifies the table that is used for storing panel timing (footprinting) and answer data collected during the script. The language id is the the key from fnd_languages table.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_IL0000083914C00011$$ | LOB | UNIQUE | APPS_TS_TX_DATA | |
SYS_IL0000083914C00012$$ | LOB | UNIQUE | APPS_TS_TX_DATA | |
SYS_IL0000083914C00034$$ | LOB | UNIQUE | APPS_TS_TX_DATA | |
IES_DEPLOYED_SCRIPTS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | DSCRIPT_LANG_ID |
IES_DEPLOYED_SCRIPTS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PANEL_TABLE_ID |
IES_DEPLOYED_SCRIPTS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | QUESTION_TABLE_ID |
IES_DEPLOYED_SCRIPTS_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | DSCRIPT_ID |
IES_DEPLOYED_SCRIPTS_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | DSCRIPT_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DSCRIPT_ID | NUMBER | Yes | Unique Identifier for Scripts | |
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 | ||
DSCRIPT_LANG_ID | NUMBER | Yes | Foreign key from FND_LANGUAGES | |
PANEL_TABLE_ID | NUMBER | Yes | Foreign key from IES_DATA_TABLES, Gives the name of panel_data table used for a script | |
QUESTION_TABLE_ID | NUMBER | Yes | Foreign key from IES_DATA_TABLES, Gives the name of question_data table used for a script | |
DSCRIPT_NAME | VARCHAR2 | (256) | Yes | Name of the script |
DSCRIPT_FILE | BLOB | (4000) | Column to hold the Script Object | |
SCHEMA_MAPPING | BLOB | (4000) | Object that has UID relationships for a script | |
ACTIVE_STATUS | NUMBER | Yes | Active/Inactive status | |
APPLICATION_ID | NUMBER | Used by Applications | ||
FUNCTION_ID | NUMBER | Used by Applications | ||
SCRIPT_TYPE | VARCHAR2 | (30) | Type of script | |
DESCRIPTION | VARCHAR2 | (4000) | Description of 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 | |
SCRIPT_BLOB | BLOB | (4000) | Object storing work in progress script. This work in progress script is the one corresponding to the deployed script. | |
SECURITY_GROUP_ID | NUMBER | (15) | Used in hosted environments | |
OBJECT_VERSION_NUMBER | NUMBER | Used in hosted environments | ||
F_DELETEDFLAG | VARCHAR2 | (1) | column added for iSurvey | |
LOCK_STATUS | NUMBER | Yes | Status to indicate if Script is locked? | |
SCRIPT_CATEGORY | NUMBER | Identifies Script type Valid values are : 0 - Graph Script and 1 - Wizard Script | ||
SUSPENDABLE | VARCHAR2 | (1) | Flag to indicate if Script can be suspendable. |
Cut, paste (and edit) the following text to query this object:
SELECT DSCRIPT_ID
, CREATED_BY
, LAST_UPDATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, DSCRIPT_LANG_ID
, PANEL_TABLE_ID
, QUESTION_TABLE_ID
, DSCRIPT_NAME
, DSCRIPT_FILE
, SCHEMA_MAPPING
, ACTIVE_STATUS
, APPLICATION_ID
, FUNCTION_ID
, SCRIPT_TYPE
, DESCRIPTION
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SCRIPT_BLOB
, SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER
, F_DELETEDFLAG
, LOCK_STATUS
, SCRIPT_CATEGORY
, SUSPENDABLE
FROM IES.IES_DEPLOYED_SCRIPTS;
IES.IES_DEPLOYED_SCRIPTS does not reference any database object
IES.IES_DEPLOYED_SCRIPTS is referenced by following:
|
|
|