eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	SQLAP.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:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AP_TRANSMISSIONS_SETUP_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRANSMISSION_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:

APPS: AP_TRANSMISSIONS_SETUP