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]

MATERIALIZED VIEW: APPS.BIL_BI_SLS_PERF1_MV

Object Details

Object Name:	BIL_BI_SLS_PERF1_MV
Object Type:	MATERIALIZED VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

M-View Details

Container:	BIL_BI_SLS_PERF1_MV
Updatable:	N
Rewrite Enabled:	N
Rewrite Capability:	NONE
Refresh Mode:	DEMAND
Refresh Method:	COMPLETE
Build Mode:	DEFERRED
Fast Refreshable:	NO

MV Log Dependencies:


FII_TIME_STRUCTURES

[View Source Query]

Columns

Name	Datatype	Length	Comments
UMARKER	VARCHAR2	(11)	Dummy column to differentiate different parts of UNION ALL
PARENT_SALES_GROUP_ID	NUMBER		Parent group identifier for the sales group.
SALES_GROUP_ID	NUMBER		Sales group identifier.
SALESREP_ID	NUMBER		Salesperson or resource identifier who gets sales credits. Will never be null.
TOP_WON_WEEK_RANK	NUMBER		Top rank based on the week Won amount arranged in descending order.
TOP_WON_PERIOD_RANK	NUMBER		Top rank based on the Period(Month) Won amount arranged in descending order.
TOP_WON_QUARTER_RANK	NUMBER		Top rank based on the Quarter Won amount arranged in descending order.
TOP_WON_YEAR_RANK	NUMBER		Top rank based on the Year Won amount arranged in descending order.
BOTTOM_WON_WEEK_RANK	NUMBER		Bottom rank based on the week Won amount arranged in descending order.
BOTTOM_WON_PERIOD_RANK	NUMBER		Bottom rank based on the Period(Month) Won amount arranged in descending order.
BOTTOM_WON_QUARTER_RANK	NUMBER		Bottom rank based on the Quarter Won amount arranged in descending order.
BOTTOM_WON_YEAR_RANK	NUMBER		Bottom rank based on the Year Won amount arranged in descending order.
WON_WEEK_LAST_RANK	NUMBER		Total no of SalesReps during that particular week based on the week Won amount.
WON_PERIOD_LAST_RANK	NUMBER		Total no of SalesReps during that particular Period based on the Period Won amount.
WON_QUARTER_LAST_RANK	NUMBER		Total no of SalesReps during that particular Quarter based on the Quarter Won amount.
WON_YEAR_LAST_RANK	NUMBER		Total no of SalesReps during that particular Year based on the Yaer Won amount.
TOP_WINLOSS_WEEK_RANK	NUMBER		Top rank based on the week Win/Loss ratio arranged in descending order.
TOP_WINLOSS_PERIOD_RANK	NUMBER		Top rank based on the Period(Month) Win/Loss ratio arranged in descending order.
TOP_WINLOSS_QUARTER_RANK	NUMBER		Top rank based on the Quarter Win/Loss ratio arranged in descending order.
TOP_WINLOSS_YEAR_RANK	NUMBER		Top rank based on the Year Win/Loss ratio arranged in descending order.
BOTTOM_WINLOSS_WEEK_RANK	NUMBER		Bottom rank based on the week Win/Loss ratio arranged in descending order.
BOTTOM_WINLOSS_PERIOD_RANK	NUMBER		Bottom rank based on the Period(Month) Win/Loss ratio arranged in descending order.
BOTTOM_WINLOSS_QUARTER_RANK	NUMBER		Bottom rank based on the Quarter Win/Loss ratio arranged in descending order.
BOTTOM_WINLOSS_YEAR_RANK	NUMBER		Bottom rank based on the Year Win/Loss ratio arranged in descending order.
WINLOSS_WEEK_LAST_RANK	NUMBER		Total no of SalesReps during that particular week based on the week Win/Loss ratio.
WINLOSS_PERIOD_LAST_RANK	NUMBER		Total no of SalesReps during that particular Period based on the Period Win/Loss ratio.
WINLOSS_QUARTER_LAST_RANK	NUMBER		Total no of SalesReps during that particular Quarter based on the Quarter Win/Loss ratio.
WINLOSS_YEAR_LAST_RANK	NUMBER		Total no of SalesReps during that particular Year based on the Year Win/Loss ratio.
TOP_WEEK_RANK	NUMBER		Top rank based on the week Booked amount arranged in descending order.
TOP_PERIOD_RANK	NUMBER		Top rank based on the Period Booked amount arranged in descending order.
TOP_QUARTER_RANK	NUMBER		Top rank based on the Quarter Booked amount arranged in descending order.
TOP_YEAR_RANK	NUMBER		Top rank based on the Year Booked amount arranged in descending order.
BOTTOM_WEEK_RANK	NUMBER		Bottom rank based on the week Booked amount arranged in descending order.
BOTTOM_PERIOD_RANK	NUMBER		Bottom rank based on the Period Booked amount arranged in descending order.
BOTTOM_QUARTER_RANK	NUMBER		Bottom rank based on the Quarter Booked amount arranged in descending order.
BOTTOM_YEAR_RANK	NUMBER		Bottom rank based on the Year Booked amount arranged in descending order.
YEAR_LAST_RANK	NUMBER		Total no of SalesReps during that particular week based on the week Booked amount.
QUARTER_LAST_RANK	NUMBER		Total no of SalesReps during that particular Period based on the Period Booked amount.
PERIOD_LAST_RANK	NUMBER		Total no of SalesReps during that particular Quarter based on the Quarter Booked amount.
WEEK_LAST_RANK	NUMBER		Total no of SalesReps during that particular Year based on the Year Booked amount.
WEEK_WON_AMT	NUMBER		Sum of Won Oppty amounts if the opty is closed in the same week in primary currency.
PERIOD_WON_AMT	NUMBER		Sum of Won Oppty amounts if the opty is closed in the same Period in primary currency.
QTR_WON_AMT	NUMBER		Sum of Won Oppty amounts if the opty is closed in the same quarter in primary currency.
YEAR_WON_AMT	NUMBER		Sum of Won Oppty amounts if the opty is closed in the same Year in primary currency.
WEEK_WON_AMT_S	NUMBER		Sum of Won Oppty amounts if the opty is closed in the same week in secondary currency.
PERIOD_WON_AMT_S	NUMBER		Sum of Won Oppty amounts if the opty is closed in the same Period in secondary currency.
QTR_WON_AMT_S	NUMBER		Sum of Won Oppty amounts if the opty is closed in the same quarter in secondary currency.
YEAR_WON_AMT_S	NUMBER		Sum of Won Oppty amounts if the opty is closed in the same Year in secondary currency.
WEEK_BOOKED_AMT	NUMBER		Sum of Booked amounts if the close date in the same Week in primary currency.
PERIOD_BOOKED_AMT	NUMBER		Sum of Booked amounts if the close date in the same Period in primary currency.
QTR_BOOKED_AMT	NUMBER		Sum of Booked amounts if the close date in the same quarter in primary currency.
YEAR_BOOKED_AMT	NUMBER		Sum of Booked amounts if the close date in the same Year in primary currency.
WEEK_BOOKED_AMT_S	NUMBER		Sum of Booked amounts if the close date in the same Week in secondary currency.
PERIOD_BOOKED_AMT_S	NUMBER		Sum of Booked amounts if the close date in the same Period in secondary currency.
QTR_BOOKED_AMT_S	NUMBER		Sum of Booked amounts if the close date in the same quarter in secondary currency.
YEAR_BOOKED_AMT_S	NUMBER		Sum of Booked amounts if the close date in the same Year in secondary currency.
WEEK_WINLOSS_RATIO	NUMBER		Sum of Win/Loss Ratio if the opty is closed in the same week in primary currency.
PERIOD_WINLOSS_RATIO	NUMBER		Sum of Win/Loss Ratio if the opty is closed in the same Period in primary currency.
QTR_WINLOSS_RATIO	NUMBER		Sum of Win/Loss Ratio if the opty is closed in the same Quarter in primary currency.
YEAR_WINLOSS_RATIO	NUMBER		Sum of Win/Loss Ratio if the opty is closed in the same Year in primary currency.
WEEK_WINLOSS_RATIO_S	NUMBER		Sum of Win/Loss Ratio if the opty is closed in the same week in secondary currency.
PERIOD_WINLOSS_RATIO_S	NUMBER		Sum of Win/Loss Ratio if the opty is closed in the same Period in secondary currency.
QTR_WINLOSS_RATIO_S	NUMBER		Sum of Win/Loss Ratio if the opty is closed in the same Quarter in secondary currency.
YEAR_WINLOSS_RATIO_S	NUMBER		Sum of Win/Loss Ratio if the opty is closed in the same Year in secondary currency.

Query Text

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


SELECT UMARKER
,      PARENT_SALES_GROUP_ID
,      SALES_GROUP_ID
,      SALESREP_ID
,      TOP_WON_WEEK_RANK
,      TOP_WON_PERIOD_RANK
,      TOP_WON_QUARTER_RANK
,      TOP_WON_YEAR_RANK
,      BOTTOM_WON_WEEK_RANK
,      BOTTOM_WON_PERIOD_RANK
,      BOTTOM_WON_QUARTER_RANK
,      BOTTOM_WON_YEAR_RANK
,      WON_WEEK_LAST_RANK
,      WON_PERIOD_LAST_RANK
,      WON_QUARTER_LAST_RANK
,      WON_YEAR_LAST_RANK
,      TOP_WINLOSS_WEEK_RANK
,      TOP_WINLOSS_PERIOD_RANK
,      TOP_WINLOSS_QUARTER_RANK
,      TOP_WINLOSS_YEAR_RANK
,      BOTTOM_WINLOSS_WEEK_RANK
,      BOTTOM_WINLOSS_PERIOD_RANK
,      BOTTOM_WINLOSS_QUARTER_RANK
,      BOTTOM_WINLOSS_YEAR_RANK
,      WINLOSS_WEEK_LAST_RANK
,      WINLOSS_PERIOD_LAST_RANK
,      WINLOSS_QUARTER_LAST_RANK
,      WINLOSS_YEAR_LAST_RANK
,      TOP_WEEK_RANK
,      TOP_PERIOD_RANK
,      TOP_QUARTER_RANK
,      TOP_YEAR_RANK
,      BOTTOM_WEEK_RANK
,      BOTTOM_PERIOD_RANK
,      BOTTOM_QUARTER_RANK
,      BOTTOM_YEAR_RANK
,      YEAR_LAST_RANK
,      QUARTER_LAST_RANK
,      PERIOD_LAST_RANK
,      WEEK_LAST_RANK
,      WEEK_WON_AMT
,      PERIOD_WON_AMT
,      QTR_WON_AMT
,      YEAR_WON_AMT
,      WEEK_WON_AMT_S
,      PERIOD_WON_AMT_S
,      QTR_WON_AMT_S
,      YEAR_WON_AMT_S
,      WEEK_BOOKED_AMT
,      PERIOD_BOOKED_AMT
,      QTR_BOOKED_AMT
,      YEAR_BOOKED_AMT
,      WEEK_BOOKED_AMT_S
,      PERIOD_BOOKED_AMT_S
,      QTR_BOOKED_AMT_S
,      YEAR_BOOKED_AMT_S
,      WEEK_WINLOSS_RATIO
,      PERIOD_WINLOSS_RATIO
,      QTR_WINLOSS_RATIO
,      YEAR_WINLOSS_RATIO
,      WEEK_WINLOSS_RATIO_S
,      PERIOD_WINLOSS_RATIO_S
,      QTR_WINLOSS_RATIO_S
,      YEAR_WINLOSS_RATIO_S
FROM APPS.BIL_BI_SLS_PERF1_MV;

Dependencies

[top of page]

APPS.BIL_BI_SLS_PERF1_MV references the following:

APPS: BIL_BI_OPTY_G_MV; BIL_BI_OPTY_G_MV; BIL_BI_SLS_PERF1_MV; FII_TIME_STRUCTURES; ISC_DBI_SCR_001_MV; ISC_DBI_SCR_001_MV; JTF_RS_GROUPS_DENORM; JTF_RS_GROUP_USAGES
FII: FII_TIME_STRUCTURES
JTF: JTF_RS_GROUPS_DENORM; JTF_RS_GROUP_USAGES

APPS.BIL_BI_SLS_PERF1_MV is referenced by following:

APPS: BIL_BI_SLS_PERF_MV