[Home] [Help] [Dependency Information]
Object Name: | GMO_INSTR_TASK_DEFN_B |
---|---|
Object Type: | TABLE |
Owner: | GMO |
FND Design Data: | GMO.GMO_INSTR_TASK_DEFN_B |
Subobject Name: | |
Status: | VALID |
Task Definition Table to store all possible tasks to be executed using PI Framework
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GMO_INSTR_TASK_DEFN_B_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | TASK_ID |
GMO_INSTR_TASK_DEFN_B_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TASK_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TASK_ID | NUMBER | Yes | Task Id, primary key | |
ENTITY_NAME | VARCHAR2 | (500) | Yes | Entity Name for the Task |
INSTRUCTION_TYPE | VARCHAR2 | (40) | Yes | Instruction Type for the task |
TASK_NAME | VARCHAR2 | (500) | Yes | Internal Name of task |
TASK_TYPE | VARCHAR2 | (40) | Yes | Type of Task |
TARGET | VARCHAR2 | (4000) | Yes | Target URL or OA Function Name for the task |
ATTRIBUTE_SQL | VARCHAR2 | (4000) | Attribute SQL for the Task to be used at definition time | |
ATTRIBUTE_DISPLAY_COL_COUNT | NUMBER | Attribute Display Column Count | ||
ENTITY_KEY_PATTERN | VARCHAR2 | (4000) | String pattern used to for entity key | |
CREATION_DATE | DATE | Yes | Standard WHO Column | |
CREATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO Column | |
MAX_ALLOWED_TASK | NUMBER | (22) | Maximum Number of task repetition allowed in a Instruction Set |
Cut, paste (and edit) the following text to query this object:
SELECT TASK_ID
, ENTITY_NAME
, INSTRUCTION_TYPE
, TASK_NAME
, TASK_TYPE
, TARGET
, ATTRIBUTE_SQL
, ATTRIBUTE_DISPLAY_COL_COUNT
, ENTITY_KEY_PATTERN
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, MAX_ALLOWED_TASK
FROM GMO.GMO_INSTR_TASK_DEFN_B;
GMO.GMO_INSTR_TASK_DEFN_B does not reference any database object
GMO.GMO_INSTR_TASK_DEFN_B is referenced by following:
|
|
|