[Home] [Help] [Dependency Information]
Object Name: | IES_AUX_SCRIPT_RELATIONSHIPS |
---|---|
Object Type: | TABLE |
Owner: | IES |
FND Design Data: | IES.IES_AUX_SCRIPT_RELATIONSHIPS |
Subobject Name: | |
Status: | VALID |
The Auxiliary Schema tables of Oracle Scripting are composed of those schema tables which are included as part of the base schema, but whose records are not inserted, updated, deleted, or modified in any way by either the Script Author or by the runtime Engine. These tables are provided as a convenience for applications which wish to extend Scripting data with their own data and in order to have a single schema definition for tables which may be shared by more than one application that needs to extend the data provided by Scripting.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IES_AUX_SCRIPT_REL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SCRIPT_A_ID |
IES_AUX_SCRIPT_REL_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SCRIPT_B_ID |
IES_AUX_SCRIPT_REL_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SCRIPT_RELATIONSHIP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SCRIPT_RELATIONSHIP_ID | NUMBER | Yes | Unique Identifier for IES_AUX_SCRIPT_RELATIONSHIPS | |
SCRIPT_A_ID | NUMBER | Yes | Script ID | |
SCRIPT_B_ID | NUMBER | Yes | Script ID | |
RELATIONSHIP | VARCHAR2 | (512) | Relationship between scripts A and B | |
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 | ||
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 SCRIPT_RELATIONSHIP_ID
, SCRIPT_A_ID
, SCRIPT_B_ID
, RELATIONSHIP
, CREATED_BY
, LAST_UPDATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, 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_AUX_SCRIPT_RELATIONSHIPS;
IES.IES_AUX_SCRIPT_RELATIONSHIPS does not reference any database object
IES.IES_AUX_SCRIPT_RELATIONSHIPS is referenced by following:
|
|
|