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

TABLE: XTR.XTR_SETTLEMENT_SCRIPTS

Object Details
Object Name: XTR_SETTLEMENT_SCRIPTS
Object Type: TABLE
Owner: XTR
FND Design Data: TableXTR.XTR_SETTLEMENT_SCRIPTS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
AUTHORISED VARCHAR2 (1) Yes Indicates if this record is authorised to be used. Valid values are: Y (authorised) or N (not authorised).
COMMENTS VARCHAR2 (50)
Additional note.
COMPANY_CODE VARCHAR2 (7)
Company identifier. Foreign key to XTR_PARTIES_V.
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)
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 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 does not reference any database object

XTR.XTR_SETTLEMENT_SCRIPTS is referenced by following:

SchemaXTR
ViewXTR_SETTLEMENT_SCRIPTS#