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]

VIEW: AP.AP_TRANSMISSIONS_SETUP#

Object Details

Object Name:	AP_TRANSMISSIONS_SETUP#
Object Type:	VIEW
Owner:	AP
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
TRANSMISSION_ID	NUMBER	(15)	Yes
TRANSMISSION_CODE	VARCHAR2	(100)	Yes
BANK_BRANCH_ID	NUMBER	(15)	Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
TRANSMISSION_PROGRAM	VARCHAR2	(100)
USERNAME	VARCHAR2	(30)
PASSWORD	VARCHAR2	(100)
PROTOCOL	VARCHAR2	(30)
PROTOCOL_ADDRESS	VARCHAR2	(240)
EXTERNAL_IDENTIFIER	VARCHAR2	(100)
TRANSMISSION_EMAIL	VARCHAR2	(240)
CONFIRMATION_EMAIL	VARCHAR2	(240)
STATEMENT_EMAIL	VARCHAR2	(240)
EXCEPTION_EMAIL	VARCHAR2	(240)
LOCAL_PAY_DIRECTORY	VARCHAR2	(240)
LOCAL_CONF_DIRECTORY	VARCHAR2	(240)
LOCAL_STMT_DIRECTORY	VARCHAR2	(240)
LOCAL_EXCEPTION_DIRECTORY	VARCHAR2	(240)
BANK_PAY_DIRECTORY	VARCHAR2	(240)
BANK_CONF_DIRECTORY	VARCHAR2	(240)
BANK_STMT_DIRECTORY	VARCHAR2	(240)
BANK_EXCEPTION_DIRECTORY	VARCHAR2	(240)
PAY_FILE_EXT	VARCHAR2	(30)
PAY_FILE_PREFIX	VARCHAR2	(30)
PAY_FILE_SUFFIX	VARCHAR2	(30)
CONF_FILE_EXT	VARCHAR2	(30)
CONF_FILE_PREFIX	VARCHAR2	(30)
CONF_FILE_SUFFIX	VARCHAR2	(30)
STMT_FILE_EXT	VARCHAR2	(30)
STMT_FILE_PREFIX	VARCHAR2	(30)
STMT_FILE_SUFFIX	VARCHAR2	(30)
EXCEPTION_FILE_EXT	VARCHAR2	(30)
EXCEPTION_FILE_PREFIX	VARCHAR2	(30)
EXCEPTION_FILE_SUFFIX	VARCHAR2	(30)
INTRA_STATEMENT_EMAIL	VARCHAR2	(240)
LOCAL_INTRA_DIRECTORY	VARCHAR2	(240)
BANK_INTRA_DIRECTORY	VARCHAR2	(240)
INTRA_FILE_EXT	VARCHAR2	(30)
INTRA_FILE_PREFIX	VARCHAR2	(30)
INTRA_FILE_SUFFIX	VARCHAR2	(30)
XTR_TRANSMISSION_EMAIL	VARCHAR2	(240)
XTR_CONFIRMATION_EMAIL	VARCHAR2	(240)
XTR_LOCAL_PAY_DIR	VARCHAR2	(240)
XTR_LOCAL_CONF_DIR	VARCHAR2	(240)
XTR_BANK_PAY_DIR	VARCHAR2	(240)
XTR_BANK_CONF_DIR	VARCHAR2	(240)
XTR_PAY_FILE_EXT	VARCHAR2	(30)
XTR_PAY_FILE_PREFIX	VARCHAR2	(30)
XTR_PAY_FILE_SUFFIX	VARCHAR2	(30)
XTR_CONF_FILE_EXT	VARCHAR2	(30)
XTR_CONF_FILE_PREFIX	VARCHAR2	(30)
XTR_CONF_FILE_SUFFIX	VARCHAR2	(30)

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# references the following:

AP: AP_TRANSMISSIONS_SETUP

AP.AP_TRANSMISSIONS_SETUP# is referenced by following:

APPS: AP_TRANSMISSIONS_SETUP