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: XTR.XTR_SETTLEMENT_SCRIPTS#

Object Details

Object Name:	XTR_SETTLEMENT_SCRIPTS#
Object Type:	VIEW
Owner:	XTR
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
AUTHORISED	VARCHAR2	(1)	Yes
COMMENTS	VARCHAR2	(50)
COMPANY_CODE	VARCHAR2	(7)
CURRENCY_CODE	VARCHAR2	(15)
EFT_SCRIPT_OUTPUT_PATH	VARCHAR2	(50)
LAST_FILE_CREATED	VARCHAR2	(150)
LAST_RUN_BY	VARCHAR2	(10)
LAST_RUN_ON	DATE
ONLY_NEW_TRANSACTIONS	VARCHAR2	(1)
PACKAGE_NAME	VARCHAR2	(20)
RUN_REQUESTED_ON	DATE
SCRIPT_NAME	VARCHAR2	(8)	Yes
SCRIPT_TYPE	VARCHAR2	(10)	Yes
TRANSMISSION_CODE	VARCHAR2	(100)
IBY_TRANSMIT_CONFIGURATION_ID	NUMBER	(15)

Query Text

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


SELECT AUTHORISED
,      COMMENTS
,      COMPANY_CODE
,      CURRENCY_CODE
,      EFT_SCRIPT_OUTPUT_PATH
,      LAST_FILE_CREATED
,      LAST_RUN_BY
,      LAST_RUN_ON
,      ONLY_NEW_TRANSACTIONS
,      PACKAGE_NAME
,      RUN_REQUESTED_ON
,      SCRIPT_NAME
,      SCRIPT_TYPE
,      TRANSMISSION_CODE
,      IBY_TRANSMIT_CONFIGURATION_ID
FROM XTR.XTR_SETTLEMENT_SCRIPTS#;

Dependencies

[top of page]

XTR.XTR_SETTLEMENT_SCRIPTS# references the following:

XTR: XTR_SETTLEMENT_SCRIPTS

XTR.XTR_SETTLEMENT_SCRIPTS# is referenced by following:

APPS: XTR_SETTLEMENT_SCRIPTS