[Home] [Help] [Dependency Information]
Object Name: | XTR_SETTLEMENT_SCRIPTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | XTR.XTR_SETTLEMENT_SCRIPTS_V |
Subobject Name: | |
Status: | VALID |
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.
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 |
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;
|
|
|