[Home] [Help] [Dependency Information]
Object Name: | IEU_UWQM_WS_ASSCT_PROPS |
---|---|
Object Type: | TABLE |
Owner: | IEU |
FND Design Data: | IEU.IEU_UWQM_WS_ASSCT_PROPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IEU_UWQM_WS_ASSCT_PROPS_U1 | NORMAL | UNIQUE | APPS_TS_SEED | WS_ASSOCIATION_PROP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WS_ASSOCIATION_PROP_ID | NUMBER | (15) | Yes | PK for the table. |
OBJECT_VERSION_NUMBER | NUMBER | Yes | Standard column used by HTML utilities. | |
CREATED_BY | NUMBER | (15) | Yes | Standard WHO columns. |
CREATION_DATE | DATE | Yes | Standard WHO columns. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO columns. |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO columns. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO columns. | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
WS_ID | NUMBER | (15) | Yes | Work Source Association ID |
PARENT_WS_ID | NUMBER | (15) | Parent Work Source ID for this Work-Source Association | |
CHILD_WS_ID | NUMBER | (15) | Child Work Source ID for the Association | |
DIST_ST_BASED_ON_PARENT_FLAG | VARCHAR2 | (5) | Indicates whether the distribution of the dependent (child) work-item will be based on that of parent, viz. the child work-item will not be distributed until the parent work-item is distributed. | |
TASKS_RULES_FUNCTION | VARCHAR2 | (256) | Rules Function for Tasks with source doc like SR etc. |
Cut, paste (and edit) the following text to query this object:
SELECT WS_ASSOCIATION_PROP_ID
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
, WS_ID
, PARENT_WS_ID
, CHILD_WS_ID
, DIST_ST_BASED_ON_PARENT_FLAG
, TASKS_RULES_FUNCTION
FROM IEU.IEU_UWQM_WS_ASSCT_PROPS;
IEU.IEU_UWQM_WS_ASSCT_PROPS does not reference any database object
IEU.IEU_UWQM_WS_ASSCT_PROPS is referenced by following:
|
|
|