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

VIEW: APPS.XTR_SETTLEMENT_SCRIPTS_V

Object Details
Object Name: XTR_SETTLEMENT_SCRIPTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewXTR.XTR_SETTLEMENT_SCRIPTS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
COMPANY_CODE VARCHAR2 (7)
Company identifier. Foreign key to XTR_PARTIES_V.
SCRIPT_NAME VARCHAR2 (8) Yes
SCRIPT_TYPE VARCHAR2 (10) Yes
AUTHORISED VARCHAR2 (1) Yes Indicates if this record is authorised to be used. Valid values are: Y (authorised) or N (not authorised).
EFT_SCRIPT_OUTPUT_PATH VARCHAR2 (50)
PACKAGE_NAME VARCHAR2 (20)
CURRENCY_CODE VARCHAR2 (15)
RUN_REQUESTED_ON DATE

LAST_RUN_ON DATE

LAST_RUN_BY VARCHAR2 (10)
LAST_FILE_CREATED VARCHAR2 (150)
COMMENTS VARCHAR2 (50)
Additional note.
ONLY_NEW_TRANSACTIONS VARCHAR2 (1)
TRANSMISSION_CODE VARCHAR2 (100)
No longer used in R12
IBY_TRANSMIT_CONFIGURATION_ID NUMBER (15)
Transmit Configuration Id
Query Text

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


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

Dependencies

[top of page]

APPS.XTR_SETTLEMENT_SCRIPTS_V references the following:

SchemaAPPS
SynonymXTR_SETTLEMENT_SCRIPTS
APPS.XTR_SETTLEMENT_SCRIPTS_V is referenced by following:

SchemaAPPS
Package BodyXTR_XTRLTDAP_XMLP_PKG - show dependent code