[Home] [Help]
[Dependency Information]
| Object Name: | XTR_CONFIRMATION_DETAILS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | XTR.XTR_CONFIRMATION_DETAILS_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 |
|---|---|---|---|---|
| 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) |
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;
APPS
XTR_CONFIRMATION_DETAILS
APPS.XTR_CONFIRMATION_DETAILS_V is not referenced by any database object
|
|
|
|