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

VIEW: APPS.XTR_PRICE_MODELS_V

Object Details
Object Name: XTR_PRICE_MODELS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewXTR.XTR_PRICE_MODELS_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
PRICE_MODEL_ID NUMBER (15) Yes Unique identifier for each row of pricing model data.
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 pricing model.
CODE VARCHAR2 (30) Yes Code that represents the pricing model.
COMPONENT_MODEL_FLAG VARCHAR2 (1)
Specifies if this is a model for a component or for an entire fair value deal. Y=Component model. N=Deal fairvalue model.
AUTHORIZED VARCHAR2 (1) Yes Specifies if the pricing model is authorized for use by deals with the associated deal types. An unauthorized pricing model cannot be assigned to new deals but will remain as a reference to existing deals.
Query Text

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


SELECT PRICE_MODEL_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      DEAL_TYPE
,      CODE
,      COMPONENT_MODEL_FLAG
,      AUTHORIZED
FROM APPS.XTR_PRICE_MODELS_V;

Dependencies

[top of page]

APPS.XTR_PRICE_MODELS_V references the following:

SchemaAPPS
SynonymXTR_PRICE_MODELS
APPS.XTR_PRICE_MODELS_V is referenced by following:

SchemaAPPS
Package BodyXTR_REPLICATE_BANK_ACCOUNTS_P - show dependent code
Package BodyXTR_REPLICATE_BANK_BALANCES - show dependent code