[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: |
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. |
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
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:
|
|
|