[Home] [Help] [Dependency Information]
Object Name: | IBY_BEP_ACCT_OPT_VALS |
---|---|
Object Type: | TABLE |
Owner: | IBY |
FND Design Data: | IBY.IBY_BEP_ACCT_OPT_VALS |
Subobject Name: | |
Status: | VALID |
IBY_BEP_ACCT_OPT_VALS stores values for the parameters defined in IBY_BEP_ACCT_OPT_NAME for a given payee's payment system account. For example, this table is used to provide a payee's Doing Business As, or DBA, name. This table is shared by both the disbursements and funds capture modules of Payments.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IBY_BEP_ACCT_OPT_VALS_AIAC_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
BEP_ACCOUNT_ID
ACCOUNT_OPTION_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BEP_ACCOUNT_ID | NUMBER | (15) | Yes | Associated payment system account |
BEPID | NUMBER | (15) | Yes | Payment system to which the account option belongs |
ACCOUNT_OPTION_CODE | VARCHAR2 | (30) | Yes | Code of the account option |
ACCOUNT_OPTION_VALUE | VARCHAR2 | (255) | Yes | Value of the account option |
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. |
VAL_SEC_SEGMENT_ID | NUMBER | (15) | Reference to the security segment storing the encrypted option value. |
Cut, paste (and edit) the following text to query this object:
SELECT BEP_ACCOUNT_ID
, BEPID
, ACCOUNT_OPTION_CODE
, ACCOUNT_OPTION_VALUE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, VAL_SEC_SEGMENT_ID
FROM IBY.IBY_BEP_ACCT_OPT_VALS;
IBY.IBY_BEP_ACCT_OPT_VALS does not reference any database object
IBY.IBY_BEP_ACCT_OPT_VALS is referenced by following:
|
|
|