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


TABLE: AP.AP_TRANSMISSIONS_SETUP

Object Details
Object Name: AP_TRANSMISSIONS_SETUP
Object Type: TABLE
Owner: AP
FND Design Data: TableSQLAP.AP_TRANSMISSIONS_SETUP
Subobject Name:
Status: VALID


AP_TRANSMISSIONS_SETUP stores information required to use the Automatic Bank Transmission feature. Each bank can have one or more transmission codes, which provide details about transmitting files between your system and the bank. This table has one row for each
transmission code you define.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AP_TRANSMISSIONS_SETUP_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSMISSION_ID
Columns
Name Datatype Length Mandatory Comments
TRANSMISSION_ID NUMBER (15) Yes Transmission Identifier
TRANSMISSION_CODE VARCHAR2 (100) Yes Unique name for transmission setup.
BANK_BRANCH_ID NUMBER (15) Yes Bank branch identifier
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
TRANSMISSION_PROGRAM VARCHAR2 (100)
The bank's custom transmission program.
USERNAME VARCHAR2 (30)
Assigned and used by the bank to identify the sender
PASSWORD VARCHAR2 (100)
Assigned and used by the bank to identify the sender
PROTOCOL VARCHAR2 (30)
The bank's required protocol by which the files are transferred
PROTOCOL_ADDRESS VARCHAR2 (240)
The bank's host address to which the files are transmitted.
EXTERNAL_IDENTIFIER VARCHAR2 (100)
The identifier by which the transmitter is known to the bank.
TRANSMISSION_EMAIL VARCHAR2 (240)
The workflow role to which transmission messages are sent.
CONFIRMATION_EMAIL VARCHAR2 (240)
The workflow role to which confirmation messages are sent.
STATEMENT_EMAIL VARCHAR2 (240)
The workflow role to which statement messages are sent.
EXCEPTION_EMAIL VARCHAR2 (240)
The workflow role to which exception messages are sent.
LOCAL_PAY_DIRECTORY VARCHAR2 (240)
The local directory where the modified payment file exists.
LOCAL_CONF_DIRECTORY VARCHAR2 (240)
The local directory where the confirmation note from the bank will be placed.
LOCAL_STMT_DIRECTORY VARCHAR2 (240)
The local directory where the statement note from the bank will be placed.
LOCAL_EXCEPTION_DIRECTORY VARCHAR2 (240)
The local directory where the exception note from the bank will be placed.
BANK_PAY_DIRECTORY VARCHAR2 (240)
The bank's directory where the payment file will be placed.
BANK_CONF_DIRECTORY VARCHAR2 (240)
The bank's directory from which the confirmation note will be taken.
BANK_STMT_DIRECTORY VARCHAR2 (240)
The bank's directory from which the statement note will be taken.
BANK_EXCEPTION_DIRECTORY VARCHAR2 (240)
The bank's directory from which the exception note will be taken.
PAY_FILE_EXT VARCHAR2 (30)
The extension of the payment file name
PAY_FILE_PREFIX VARCHAR2 (30)
The prefix of the payment file name
PAY_FILE_SUFFIX VARCHAR2 (30)
The suffix of the payment file.
CONF_FILE_EXT VARCHAR2 (30)
The extension of the confirmation file name
CONF_FILE_PREFIX VARCHAR2 (30)
The prefix of the confirmation file name
CONF_FILE_SUFFIX VARCHAR2 (30)
The suffix of the confirmation file name
STMT_FILE_EXT VARCHAR2 (30)
The extension of the statement file name
STMT_FILE_PREFIX VARCHAR2 (30)
The prefix of the statement file name
STMT_FILE_SUFFIX VARCHAR2 (30)
The suffix of the statement file name
EXCEPTION_FILE_EXT VARCHAR2 (30)
The extension of the exception file name
EXCEPTION_FILE_PREFIX VARCHAR2 (30)
The prefix of the exception file name
EXCEPTION_FILE_SUFFIX VARCHAR2 (30)
The suffix of the exception file name
INTRA_STATEMENT_EMAIL VARCHAR2 (240)
The workflow role to which Intra-Day statement messages are sent.
LOCAL_INTRA_DIRECTORY VARCHAR2 (240)
The local directory where the Intra-day statement note from the bank will be placed.
BANK_INTRA_DIRECTORY VARCHAR2 (240)
The banks's directory from which the Intra-Day statements note will be taken
INTRA_FILE_EXT VARCHAR2 (30)
The extension of the Intra-Day statement file name
INTRA_FILE_PREFIX VARCHAR2 (30)
The prefix of the Intra_Day statement file name
INTRA_FILE_SUFFIX VARCHAR2 (30)
The suffix of the Intra-Day statement file name.
XTR_TRANSMISSION_EMAIL VARCHAR2 (240)
The workflow role to which Oracle Treasury transmission messages are sent
XTR_CONFIRMATION_EMAIL VARCHAR2 (240)
The workflow role to which Oracle Treasury confirmation messages are sent
XTR_LOCAL_PAY_DIR VARCHAR2 (240)
The local directory where the modified Oracle Treasury payment file exists
XTR_LOCAL_CONF_DIR VARCHAR2 (240)
The local directory where the Oracle Treasury confirmation note from the bank will be placed.
XTR_BANK_PAY_DIR VARCHAR2 (240)
The bank's directory where the Oracle Treasury payment filw will be placed
XTR_BANK_CONF_DIR VARCHAR2 (240)
The bank's directory from which the Oracle Treasury confirmation note will be taken
XTR_PAY_FILE_EXT VARCHAR2 (30)
The extension of the Oracle Treasury payment file name
XTR_PAY_FILE_PREFIX VARCHAR2 (30)
The prefix of the Oracle Treasury payment file name
XTR_PAY_FILE_SUFFIX VARCHAR2 (30)
The suffix of the Oracle Treasury payment file name.
XTR_CONF_FILE_EXT VARCHAR2 (30)
The extension of the Oracle Treasury confirmation file name
XTR_CONF_FILE_PREFIX VARCHAR2 (30)
The prefix of the Oracle Treasury confirmation file name
XTR_CONF_FILE_SUFFIX VARCHAR2 (30)
The suffix of the Oracle Treasury confirmation file name
Query Text

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


SELECT TRANSMISSION_ID
,      TRANSMISSION_CODE
,      BANK_BRANCH_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      TRANSMISSION_PROGRAM
,      USERNAME
,      PASSWORD
,      PROTOCOL
,      PROTOCOL_ADDRESS
,      EXTERNAL_IDENTIFIER
,      TRANSMISSION_EMAIL
,      CONFIRMATION_EMAIL
,      STATEMENT_EMAIL
,      EXCEPTION_EMAIL
,      LOCAL_PAY_DIRECTORY
,      LOCAL_CONF_DIRECTORY
,      LOCAL_STMT_DIRECTORY
,      LOCAL_EXCEPTION_DIRECTORY
,      BANK_PAY_DIRECTORY
,      BANK_CONF_DIRECTORY
,      BANK_STMT_DIRECTORY
,      BANK_EXCEPTION_DIRECTORY
,      PAY_FILE_EXT
,      PAY_FILE_PREFIX
,      PAY_FILE_SUFFIX
,      CONF_FILE_EXT
,      CONF_FILE_PREFIX
,      CONF_FILE_SUFFIX
,      STMT_FILE_EXT
,      STMT_FILE_PREFIX
,      STMT_FILE_SUFFIX
,      EXCEPTION_FILE_EXT
,      EXCEPTION_FILE_PREFIX
,      EXCEPTION_FILE_SUFFIX
,      INTRA_STATEMENT_EMAIL
,      LOCAL_INTRA_DIRECTORY
,      BANK_INTRA_DIRECTORY
,      INTRA_FILE_EXT
,      INTRA_FILE_PREFIX
,      INTRA_FILE_SUFFIX
,      XTR_TRANSMISSION_EMAIL
,      XTR_CONFIRMATION_EMAIL
,      XTR_LOCAL_PAY_DIR
,      XTR_LOCAL_CONF_DIR
,      XTR_BANK_PAY_DIR
,      XTR_BANK_CONF_DIR
,      XTR_PAY_FILE_EXT
,      XTR_PAY_FILE_PREFIX
,      XTR_PAY_FILE_SUFFIX
,      XTR_CONF_FILE_EXT
,      XTR_CONF_FILE_PREFIX
,      XTR_CONF_FILE_SUFFIX
FROM AP.AP_TRANSMISSIONS_SETUP;

Dependencies

[top of page]

AP.AP_TRANSMISSIONS_SETUP does not reference any database object

AP.AP_TRANSMISSIONS_SETUP is referenced by following:

SchemaAPPS
SynonymAP_TRANSMISSIONS_SETUP