[Home] [Help] [Dependency Information]
Object Name: | XTR_CONFIRMATION_DETAILS# |
---|---|
Object Type: | VIEW |
Owner: | XTR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTION_TYPE | VARCHAR2 | (50) | Yes | |
AMOUNT | NUMBER | |||
AMOUNT_TYPE | VARCHAR2 | (7) | ||
CLIENT_CODE | VARCHAR2 | (7) | ||
COMPANY_CODE | VARCHAR2 | (7) | Yes | |
CONFIRMATION_VALIDATED_BY | VARCHAR2 | (10) | ||
CONFIRMATION_VALIDATED_ON | DATE | |||
CONFO_PARTY_CODE | VARCHAR2 | (7) | ||
CONFO_VALIDATION_BOTH | VARCHAR2 | (1) | Yes | |
CPARTY_CODE | VARCHAR2 | (7) | Yes | |
CURRENCY | VARCHAR2 | (15) | ||
DATE_ACTION_INITIATED | DATE | Yes | ||
DEAL_NO | NUMBER | Yes | ||
DEAL_SUBTYPE | VARCHAR2 | (7) | ||
DEAL_TYPE | VARCHAR2 | (7) | Yes | |
DEAL_UPDATED_YN | VARCHAR2 | (1) | ||
FILE_NAME | VARCHAR2 | (100) | ||
INITIALLY_PRINTED_ON | DATE | |||
PARTY_CONFO_CHECKED | VARCHAR2 | (1) | ||
PARTY_CONFO_CHECKED_BY | VARCHAR2 | (10) | ||
PARTY_CONFO_CHECKED_ON | DATE | |||
PARTY_CONFO_FILE_NAME | VARCHAR2 | (50) | ||
REPRINTED_ON | DATE | |||
REPRINT_REQUESTED_BY | VARCHAR2 | (10) | ||
SETTLE_DATE | DATE | |||
STATUS_CODE | VARCHAR2 | (10) | Yes | |
TRANSACTION_NO | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ACTION_TYPE
, AMOUNT
, AMOUNT_TYPE
, CLIENT_CODE
, COMPANY_CODE
, CONFIRMATION_VALIDATED_BY
, CONFIRMATION_VALIDATED_ON
, CONFO_PARTY_CODE
, CONFO_VALIDATION_BOTH
, CPARTY_CODE
, CURRENCY
, DATE_ACTION_INITIATED
, DEAL_NO
, DEAL_SUBTYPE
, DEAL_TYPE
, DEAL_UPDATED_YN
, FILE_NAME
, INITIALLY_PRINTED_ON
, PARTY_CONFO_CHECKED
, PARTY_CONFO_CHECKED_BY
, PARTY_CONFO_CHECKED_ON
, PARTY_CONFO_FILE_NAME
, REPRINTED_ON
, REPRINT_REQUESTED_BY
, SETTLE_DATE
, STATUS_CODE
, TRANSACTION_NO
FROM XTR.XTR_CONFIRMATION_DETAILS#;
|
|
|