eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.QPR_PRICE_PLANS_VL

Object Details

Object Name:	QPR_PRICE_PLANS_VL
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

View of QPR_PRICE_PLANS_B and QPR_PRICE_PLANS_TL. Displays the transalated columns on policies in the local language

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PRICE_PLAN_ID	NUMBER		Yes	This is a unique number generated to identify a plan.
INSTANCE_ID	NUMBER		Yes	A unique number to identify each application instance.
NAME	VARCHAR2	(240)	Yes	Short name of the analytic workspace associated with the plan.
DESCRIPTION	VARCHAR2	(2000)		Long name of the analytic workspace associated with the plan.
AW_TYPE_CODE	VARCHAR2	(30)	Yes	Type of analytic workspace.
AW_CODE	VARCHAR2	(30)		It is the unique name of an Analytic Workspace given by 'QPR' concatenated with the price_plan_id
AW_STATUS_CODE	VARCHAR2	(30)		It takes the value 'PROCESS' when the data is loaded into the datamart. Only then can the datamart be used in Deals
AW_XML	CLOB	(4000)		The XML used for forming an Analytic Workspace is stored here in the form of a CLOB
AW_CREATED_FLAG	VARCHAR2	(1)		Specifies whether the Analytic Workspace is created or not. Takes values Y/N.
TEMPLATE_FLAG	VARCHAR2	(1)		Indicates if the rows belong to plan template. Takes values 'Y'/'N'.
START_DATE	DATE			The date from which the data has to be loaded into the datamart
END_DATE	DATE			The date till which the data has to be loaded into the datamart
BASE_UOM_CODE	VARCHAR2	(3)		The base unit to which all the quantities will be converted before loading data to the datamart
CURRENCY_CODE	VARCHAR2	(15)		The code of the currency in which all the prices will be converted before loading data to the datamart
USE_FOR_DEAL_FLAG	VARCHAR2	(1)		The data mart is used for deal or not (Y/N)
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column

Query Text

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


SELECT PRICE_PLAN_ID
,      INSTANCE_ID
,      NAME
,      DESCRIPTION
,      AW_TYPE_CODE
,      AW_CODE
,      AW_STATUS_CODE
,      AW_XML
,      AW_CREATED_FLAG
,      TEMPLATE_FLAG
,      START_DATE
,      END_DATE
,      BASE_UOM_CODE
,      CURRENCY_CODE
,      USE_FOR_DEAL_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM APPS.QPR_PRICE_PLANS_VL;

Dependencies

[top of page]

APPS.QPR_PRICE_PLANS_VL references the following:

APPS: QPR_PRICE_PLANS_B; QPR_PRICE_PLANS_TL

APPS.QPR_PRICE_PLANS_VL is referenced by following:

APPS: QPR_DEAL_PVT - show dependent code; QPR_REGRESSION_ANALYSIS - show dependent code; QPR_TIME_ALLHIER_L_V; QPR_TIME_ALLHIER_V