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

VIEW: APPS.XTR_DEAL_OVERWRITE_TYPES_V

Object Details
Object Name: XTR_DEAL_OVERWRITE_TYPES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewXTR.XTR_DEAL_OVERWRITE_TYPES_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
DEAL_OVERWRITE_TYPE_ID NUMBER (15) Yes Unique identifier for each row of deal overwrite type.
CREATED_BY NUMBER (15) Yes Standard Who Column.
CREATION_DATE DATE
Yes Standard Who Column.
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column.
LAST_UPDATE_DATE DATE
Yes Standard Who Column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column.
DEAL_TYPE VARCHAR2 (7) Yes Denotes the deal type associated with this overwrite type.
CODE VARCHAR2 (30)
Code that represents the deal overwrite type. If the value is null, then there is no overwrite type associated with this deal type.
AUTHORIZED VARCHAR2 (1) Yes Specifies if the overwrite type is authorized for use by deals with the associated deal types. An unauthorized overwrite type cannot be assigned to new deals but will remains as a reference to existing deals.
CODE_MNG VARCHAR2 (80) Yes
Query Text

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


SELECT DEAL_OVERWRITE_TYPE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      DEAL_TYPE
,      CODE
,      AUTHORIZED
,      CODE_MNG
FROM APPS.XTR_DEAL_OVERWRITE_TYPES_V;

Dependencies

[top of page]

APPS.XTR_DEAL_OVERWRITE_TYPES_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
SynonymXTR_DEAL_OVERWRITE_TYPES

APPS.XTR_DEAL_OVERWRITE_TYPES_V is not referenced by any database object