[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_V is not referenced by any database object
|
|
|