[Home] [Help] [Dependency Information]
Object Name: | IBY_SETUP_TASKS_B |
---|---|
Object Type: | TABLE |
Owner: | IBY |
FND Design Data: | IBY.IBY_SETUP_TASKS_B |
Subobject Name: | |
Status: | VALID |
IBY_SETUP_TASKS stores the status of all Oracle Payments' setup tasks.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IBY_SETUP_TASKS_B_CODE_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
TASK_CODE
ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TASK_CODE | VARCHAR2 | (30) | Yes | Primary key for setup tasks |
STATUS | VARCHAR2 | (30) | Lookup Type: IBY_TASK_STATUS | |
LEAF_NODE_FLAG | VARCHAR2 | (1) | Yes | Leaf node flag |
PARENT_TASK_CODE | VARCHAR2 | (30) | Parent task code | |
DEST_FUNCTION_NAME | VARCHAR2 | (100) | FND form function of the task setup page | |
SETUP_FLOW_CODE | VARCHAR2 | (30) | Disbursements / Funds capture | |
DISPLAY_ORDER | NUMBER | (15) | Display order | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
OBJECT_VERSION_NUMBER | NUMBER | (15) | Yes | Used for locking purposes that subsequently allows for checking if there is 'dirty' or old data on the screen compared to what is in the database. The situation occurs when the HTML application is an 'stateless' application. |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT TASK_CODE
, STATUS
, LEAF_NODE_FLAG
, PARENT_TASK_CODE
, DEST_FUNCTION_NAME
, SETUP_FLOW_CODE
, DISPLAY_ORDER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, ZD_EDITION_NAME
FROM IBY.IBY_SETUP_TASKS_B;
IBY.IBY_SETUP_TASKS_B does not reference any database object
IBY.IBY_SETUP_TASKS_B is referenced by following:
|
|
|