[Home] [Help] [Dependency Information]
Object Name: | IBY_BEP_ACCT_OPT_NAME_B |
---|---|
Object Type: | TABLE |
Owner: | IBY |
FND Design Data: | IBY.IBY_BEP_ACCT_OPT_NAME_B |
Subobject Name: | |
Status: | VALID |
IBY_BEP_ACCT_OPT_NAME stores payment system account configuration names.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IBY_BEP_ACCT_OPT_NAME_B_BA_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
BEPID
ACCOUNT_OPTION_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BEPID | NUMBER | (15) | Yes | Payment system defining the account option |
ACCOUNT_OPTION_CODE | VARCHAR2 | (30) | Yes | Code of the account option |
ACCOUNT_OPTION_DATATYPE | VARCHAR2 | (30) | Yes | Data type of the option. Values from the lookup IBY_PARAMETER_TYPES include VARCHAR2, NUMBER, and DATE. |
DISPLAY_ORDER | NUMBER | (15) | Yes | Display order within the set of all options for that payment system |
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) | Used for locking purposes that subsequently allows for checking if there is old data on the screen compared to what is in the database. The situation occurs when the HTML application is a stateless application. | |
SECURED_FLAG | VARCHAR2 | (1) | Indicates if the option should be secured- i.e., is sensitive | |
UNIQUE_PER_BATCH_FLAG | VARCHAR2 | (1) | Indicates if the option should unique per settlement batch file. |
Cut, paste (and edit) the following text to query this object:
SELECT BEPID
, ACCOUNT_OPTION_CODE
, ACCOUNT_OPTION_DATATYPE
, DISPLAY_ORDER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, SECURED_FLAG
, UNIQUE_PER_BATCH_FLAG
FROM IBY.IBY_BEP_ACCT_OPT_NAME_B;
IBY.IBY_BEP_ACCT_OPT_NAME_B does not reference any database object
IBY.IBY_BEP_ACCT_OPT_NAME_B is referenced by following:
|
|
|