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

VIEW: XTR.XTR_CONFIRMATION_DETAILS#

Object Details
Object Name: XTR_CONFIRMATION_DETAILS#
Object Type: VIEW
Owner: XTR
Subobject Name:
Status: VALID

[View Source]

Columns
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

Query Text

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#;

Dependencies

[top of page]

XTR.XTR_CONFIRMATION_DETAILS# references the following:

SchemaXTR
TableXTR_CONFIRMATION_DETAILS
XTR.XTR_CONFIRMATION_DETAILS# is referenced by following:

SchemaAPPS
TriggerXTR_BU_CONFIRMATION_DETAILS_T
SynonymXTR_CONFIRMATION_DETAILS