DBA Data[Home] [Help] [Dependency Information]

TABLE: IBY.IBY_TRXN_TYPES_B

Object Details
Object Name: IBY_TRXN_TYPES_B
Object Type: TABLE
Owner: IBY
FND Design Data: TableIBY.IBY_TRXN_TYPES_B
Subobject Name:
Status: VALID


IBY_TRXN_TYPES stores the payment processing transaction types required by the dependent products for submitting payment transactions to Oracle Payments. This is used for both funds disbursement and funds capture transactions.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IBY_TRXN_TYPES_B_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnAPPLICATION_ID
ColumnPAY_PROC_TRXN_TYPE_CODE
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Yes Application Identifier of the calling product
PAY_PROC_TRXN_TYPE_CODE VARCHAR2 (30) Yes System code for the transaction type. Must be unique per calling application
SEEDED_FLAG VARCHAR2 (1) Yes Y or N flag for whether the payment processing transaction type is seeded
PAYMENT_FLOW VARCHAR2 (30) Yes Category of this transaction type. Values are defined in the IBY_PAYMENT_FLOW lookup and include DISBURSEMENTS and FUND CAPTURE.
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
Yes Object version number
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT APPLICATION_ID
,      PAY_PROC_TRXN_TYPE_CODE
,      SEEDED_FLAG
,      PAYMENT_FLOW
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
FROM IBY.IBY_TRXN_TYPES_B;

Dependencies

[top of page]

IBY.IBY_TRXN_TYPES_B does not reference any database object

IBY.IBY_TRXN_TYPES_B is referenced by following:

SchemaAPPS
SynonymIBY_TRXN_TYPES_B