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

TABLE: IBY.IBY_PMT_SYS_TRANSMISSIONS

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


IBY_BEP_TRANSMISSIONS links payment systems to the transmission protocols they support. When a user creates a payment process profile, this table gives him or her the correct choice of protocols to use with a given payment system.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IBY_PMT_SYS_TRANSMISSIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBEPID
ColumnTRANSMIT_PROTOCOL_CODE
ColumnZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
TRANSMIT_PROTOCOL_CODE VARCHAR2 (240) Yes Transmission protocol identifier
BEPID NUMBER (15) Yes Payment system identifier
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
Query Text

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


SELECT TRANSMIT_PROTOCOL_CODE
,      BEPID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      ZD_EDITION_NAME
FROM IBY.IBY_PMT_SYS_TRANSMISSIONS;

Dependencies

[top of page]

IBY.IBY_PMT_SYS_TRANSMISSIONS does not reference any database object

IBY.IBY_PMT_SYS_TRANSMISSIONS is referenced by following:

SchemaIBY
ViewIBY_PMT_SYS_TRANSMISSIONS#