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


VIEW: APPS.XTR_CONFIRMATION_DETAILS_V

Object Details
Object Name: XTR_CONFIRMATION_DETAILS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewXTR.XTR_CONFIRMATION_DETAILS_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
CONFO_VALIDATION_BOTH VARCHAR2 (1) Yes
DEAL_NO NUMBER
Yes
ACTION_TYPE VARCHAR2 (50) Yes
CPARTY_CODE VARCHAR2 (7) Yes
DATE_ACTION_INITIATED DATE
Yes
COMPANY_CODE VARCHAR2 (7) Yes
STATUS_CODE VARCHAR2 (10) Yes
TRANSACTION_NO NUMBER

CONFO_PARTY_CODE VARCHAR2 (7)
CLIENT_CODE VARCHAR2 (7)
FILE_NAME VARCHAR2 (100)
INITIALLY_PRINTED_ON DATE

REPRINT_REQUESTED_BY VARCHAR2 (10)
REPRINTED_ON DATE

DEAL_TYPE VARCHAR2 (7) Yes
DEAL_SUBTYPE VARCHAR2 (7)
CURRENCY VARCHAR2 (15)
AMOUNT NUMBER

AMOUNT_TYPE VARCHAR2 (7)
CONFIRMATION_VALIDATED_BY VARCHAR2 (10)
CONFIRMATION_VALIDATED_ON DATE

SETTLE_DATE DATE

PARTY_CONFO_CHECKED VARCHAR2 (1)
PARTY_CONFO_FILE_NAME VARCHAR2 (50)
PARTY_CONFO_CHECKED_ON DATE

PARTY_CONFO_CHECKED_BY VARCHAR2 (10)
DEAL_UPDATED_YN VARCHAR2 (1)
Query Text

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


SELECT CONFO_VALIDATION_BOTH
,      DEAL_NO
,      ACTION_TYPE
,      CPARTY_CODE
,      DATE_ACTION_INITIATED
,      COMPANY_CODE
,      STATUS_CODE
,      TRANSACTION_NO
,      CONFO_PARTY_CODE
,      CLIENT_CODE
,      FILE_NAME
,      INITIALLY_PRINTED_ON
,      REPRINT_REQUESTED_BY
,      REPRINTED_ON
,      DEAL_TYPE
,      DEAL_SUBTYPE
,      CURRENCY
,      AMOUNT
,      AMOUNT_TYPE
,      CONFIRMATION_VALIDATED_BY
,      CONFIRMATION_VALIDATED_ON
,      SETTLE_DATE
,      PARTY_CONFO_CHECKED
,      PARTY_CONFO_FILE_NAME
,      PARTY_CONFO_CHECKED_ON
,      PARTY_CONFO_CHECKED_BY
,      DEAL_UPDATED_YN
FROM APPS.XTR_CONFIRMATION_DETAILS_V;

Dependencies

[top of page]

APPS.XTR_CONFIRMATION_DETAILS_V references the following:

SchemaAPPS
SynonymXTR_CONFIRMATION_DETAILS

APPS.XTR_CONFIRMATION_DETAILS_V is not referenced by any database object