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_PERF_MV

Object Details

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

M-View Details

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

MV Log Dependencies:


ISC_DBI_SCR_001_MV
     FII_TIME_DAY
     ISC_DBI_SCR_000_MV
          ENI_OLTP_ITEM_STAR
          FII_AR_REVENUE_B
          FII_AR_SALES_CREDITS
          FII_GLOBAL_START_DATES
          FII_PARTY_MKT_CLASS
          FII_TIME_DAY
          ISC_BOOK_SUM2_F
          ISC_SALES_CREDITS_F
          JTF_RS_SRP_GROUPS
     OKI_RS_GROUP_MV
          JTF_RS_GROUPS_DENORM
          JTF_RS_GROUP_USAGES
          OKI_BI_GRP_CNT_MV
               JTF_RS_GROUPS_DENORM
               JTF_RS_GROUP_USAGES

[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_QTR_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_QTR_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_QTR_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_QTR_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_QTR_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_QTR_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_BOOKED_WEEK_RANK	NUMBER		Top rank based on the week Booked amount arranged in descending order.
TOP_BOOKED_PERIOD_RANK	NUMBER		Top rank based on the Period Booked amount arranged in descending order.
TOP_BOOKED_QTR_RANK	NUMBER		Top rank based on the Quarter Booked amount arranged in descending order.
TOP_BOOKED_YEAR_RANK	NUMBER		Top rank based on the Year Booked amount arranged in descending order.
BOTTOM_BOOKED_WEEK_RANK	NUMBER		Bottom rank based on the week Booked amount arranged in descending order.
BOTTOM_BOOKED_PERIOD_RANK	NUMBER		Bottom rank based on the Period Booked amount arranged in descending order.
BOTTOM_BOOKED_QTR_RANK	NUMBER		Bottom rank based on the Quarter Booked amount arranged in descending order.
BOTTOM_BOOKED_YEAR_RANK	NUMBER		Bottom rank based on the Year Booked amount arranged in descending order.
BOOKED_YEAR_LAST_RANK	NUMBER		Total no of SalesReps during that particular week based on the week Booked amount.
BOOKED_QTR_LAST_RANK	NUMBER		Total no of SalesReps during that particular Period based on the Period Booked amount.
BOOKED_PERIOD_LAST_RANK	NUMBER		Total no of SalesReps during that particular Quarter based on the Quarter Booked amount.
BOOKED_WEEK_LAST_RANK	NUMBER		Total no of SalesReps during that particular Year based on the Year Booked amount.
WON_AMT_WEEK	NUMBER		Sum of Won Oppty amounts if the opty is closed in the same week in primary currency.
WON_AMT_PERIOD	NUMBER		Sum of Won Oppty amounts if the opty is closed in the same Period in primary currency.
WON_AMT_QTR	NUMBER		Sum of Won Oppty amounts if the opty is closed in the same quarter in primary currency.
WON_AMT_YEAR	NUMBER		Sum of Won Oppty amounts if the opty is closed in the same Year in primary currency.
WON_AMT_WEEK_S	NUMBER		Sum of Won Oppty amounts if the opty is closed in the same week in secondary currency.
WON_AMT_PERIOD_S	NUMBER		Sum of Won Oppty amounts if the opty is closed in the same Period in secondary currency.
WON_AMT_QTR_S	NUMBER		Sum of Won Oppty amounts if the opty is closed in the same quarter in secondary currency.
WON_AMT_YEAR_S	NUMBER		Sum of Won Oppty amounts if the opty is closed in the same Year in secondary currency.
PREV_YR_WEEK_WON_AMT	NUMBER		Sum of Won Oppty amounts if the opty is closed in the same week in previous year in primary currency.
PREV_PER_WEEK_WON_AMT	NUMBER		Sum of Won Oppty amounts if the opty is closed in the same week in previous period in primary currency.
PREV_YR_PERIOD_WON_AMT	NUMBER		Sum of Won Oppty amounts if the opty is closed in the same period in previous year in primary currency.
PREV_PER_PERIOD_WON_AMT	NUMBER		Sum of Won Oppty amounts if the opty is closed in the same period in previous period in primary currency.
PREV_YR_QTR_WON_AMT	NUMBER		Sum of Won Oppty amounts if the opty is closed in the same quarter in previous year in primary currency.
PREV_PER_QTR_WON_AMT	NUMBER		Sum of Won Oppty amounts if the opty is closed in the same quarter in previous period in primary currency.
PREV_YR_YEAR_WON_AMT	NUMBER		Sum of Won Oppty amounts if the opty is closed in the same year in previous year in primary currency.
PREV_PER_YEAR_WON_AMT	NUMBER		Sum of Won Oppty amounts if the opty is closed in the same year in previous period in primary currency.
PREV_YR_WEEK_WON_AMT_S	NUMBER		Sum of Won Oppty amounts if the opty is closed in the same week in previous year in secondary currency.
PREV_PER_WEEK_WON_AMT_S	NUMBER		Sum of Won Oppty amounts if the opty is closed in the same week in previous period in secondary currency.
PREV_YR_PERIOD_WON_AMT_S	NUMBER		Sum of Won Oppty amounts if the opty is closed in the same period in previous year in secondary currency.
PREV_PER_PERIOD_WON_AMT_S	NUMBER		Sum of Won Oppty amounts if the opty is closed in the same period in previous period in secondary currency.
PREV_YR_QTR_WON_AMT_S	NUMBER		Sum of Won Oppty amounts if the opty is closed in the same quarter in previous year in secondary currency.
PREV_PER_QTR_WON_AMT_S	NUMBER		Sum of Won Oppty amounts if the opty is closed in the same quarter in previous period in secondary currency.
PREV_YR_YEAR_WON_AMT_S	NUMBER		Sum of Won Oppty amounts if the opty is closed in the same year in previous year in secondary currency.
PREV_PER_YEAR_WON_AMT_S	NUMBER		Sum of Won Oppty amounts if the opty is closed in the same year in previous period in secondary currency.
BOOKED_AMT_WEEK	NUMBER		Sum of Booked amounts if the close date in the same Week in primary currency.
BOOKED_AMT_PERIOD	NUMBER		Sum of Booked amounts if the close date in the same Period in primary currency.
BOOKED_AMT_QTR	NUMBER		Sum of Booked amounts if the close date in the same quarter in primary currency.
BOOKED_AMT_YEAR	NUMBER		Sum of Booked amounts if the close date in the same Year in primary currency.
BOOKED_AMT_WEEK_S	NUMBER		Sum of Booked amounts if the close date in the same Week in secondary currency.
BOOKED_AMT_PERIOD_S	NUMBER		Sum of Booked amounts if the close date in the same Period in secondary currency.
BOOKED_AMT_QTR_S	NUMBER		Sum of Booked amounts if the close date in the same quarter in secondary currency.
BOOKED_AMT_YEAR_S	NUMBER		Sum of Booked amounts if the close date in the same Year in secondary currency.
PREV_YR_WEEK_BOOKED_AMT	NUMBER		Sum of Booked amounts if the close date in the same Week in previous year in primary currency.
PREV_PER_WEEK_BOOKED_AMT	NUMBER		Sum of Booked amounts if the close date in the same Week in previous Period in primary currency.
PREV_YR_PERIOD_BOOKED_AMT	NUMBER		Sum of Booked amounts if the close date in the same Period in previous year in primary currency.
PREV_PER_PERIOD_BOOKED_AMT	NUMBER		Sum of Booked amounts if the close date in the same Period in previous Period in primary currency.
PREV_YR_QTR_BOOKED_AMT	NUMBER		Sum of Booked amounts if the close date in the same Quarter in previous year in primary currency.
PREV_PER_QTR_BOOKED_AMT	NUMBER		Sum of Booked amounts if the close date in the same Quarter in previous Period in primary currency.
PREV_YR_YEAR_BOOKED_AMT	NUMBER		Sum of Booked amounts if the close date in the same Year in previous year in primary currency.
PREV_PER_YEAR_BOOKED_AMT	NUMBER		Sum of Booked amounts if the close date in the same Year in previous Period in primary currency.
PREV_YR_WEEK_BOOKED_AMT_S	NUMBER		Sum of Booked amounts if the close date in the same Week in previous year in secondary currency.
PREV_PER_WEEK_BOOKED_AMT_S	NUMBER		Sum of Booked amounts if the close date in the same Week in previous Period in secondary currency.
PREV_YR_PERIOD_BOOKED_AMT_S	NUMBER		Sum of Booked amounts if the close date in the same Period in previous year in secondary currency.
PREV_PER_PERIOD_BOOKED_AMT_S	NUMBER		Sum of Booked amounts if the close date in the same Period in previous Period in secondary currency.
PREV_YR_QTR_BOOKED_AMT_S	NUMBER		Sum of Booked amounts if the close date in the same Quarter in previous year in secondary currency.
PREV_PER_QTR_BOOKED_AMT_S	NUMBER		Sum of Booked amounts if the close date in the same Quarter in previous Period in secondary currency.
PREV_YR_YEAR_BOOKED_AMT_S	NUMBER		Sum of Booked amounts if the close date in the same Year in previous year in secondary currency.
PREV_PER_YEAR_BOOKED_AMT_S	NUMBER		Sum of Booked amounts if the close date in the same Year in previous Period in secondary currency.
WINLOSS_RATIO_WEEK	NUMBER		Sum of Win/Loss Ratio if the opty is closed in the same week in primary currency.
WINLOSS_RATIO_PERIOD	NUMBER		Sum of Win/Loss Ratio if the opty is closed in the same Period in primary currency.
WINLOSS_RATIO_QTR	NUMBER		Sum of Win/Loss Ratio if the opty is closed in the same Quarter in primary currency.
WINLOSS_RATIO_YEAR	NUMBER		Sum of Win/Loss Ratio if the opty is closed in the same Year in primary currency.
WINLOSS_RATIO_WEEK_S	NUMBER		Sum of Win/Loss Ratio if the opty is closed in the same week in secondary currency.
WINLOSS_RATIO_PERIOD_S	NUMBER		Sum of Win/Loss Ratio if the opty is closed in the same Period in secondary currency.
WINLOSS_RATIO_QTR_S	NUMBER		Sum of Win/Loss Ratio if the opty is closed in the same Quarter in secondary currency.
WINLOSS_RATIO_YEAR_S	NUMBER		Sum of Win/Loss Ratio if the opty is closed in the same Year in secondary currency.
PREV_YR_WEEK_WLRATIO	NUMBER		Sum of Win/Loss Ratio if the opty is closed in the same WEEK in previous Year in primary currency.
PREV_PER_WEEK_WLRATIO	NUMBER		Sum of Win/Loss Ratio if the opty is closed in the same WEEK in previous period in primary currency.
PREV_YR_PERIOD_WLRATIO	NUMBER		Sum of Win/Loss Ratio if the opty is closed in the same period in previous Year in primary currency.
PREV_PER_PERIOD_WLRATIO	NUMBER		Sum of Win/Loss Ratio if the opty is closed in the same period in previous period in primary currency.
PREV_YR_QTR_WLRATIO	NUMBER		Sum of Win/Loss Ratio if the opty is closed in the same quarter in previous Year in primary currency.
PREV_PER_QTR_WLRATIO	NUMBER		Sum of Win/Loss Ratio if the opty is closed in the same quarter in previous period in primary currency.
PREV_YR_YEAR_WLRATIO	NUMBER		Sum of Win/Loss Ratio if the opty is closed in the same year in previous Year in primary currency.
PREV_PER_YEAR_WLRATIO	NUMBER		Sum of Win/Loss Ratio if the opty is closed in the same year in previous period in primary currency.
PREV_YR_WEEK_WLRATIO_S	NUMBER		Sum of Win/Loss Ratio if the opty is closed in the same WEEK in previous Year in secondary currency.
PREV_PER_WEEK_WLRATIO_S	NUMBER		Sum of Win/Loss Ratio if the opty is closed in the same WEEK in previous period in secondary currency.
PREV_YR_PERIOD_WLRATIO_S	NUMBER		Sum of Win/Loss Ratio if the opty is closed in the same period in previous Year in secondary currency.
PREV_PER_PERIOD_WLRATIO_S	NUMBER		Sum of Win/Loss Ratio if the opty is closed in the same period in previous period in secondary currency.
PREV_YR_QTR_WLRATIO_S	NUMBER		Sum of Win/Loss Ratio if the opty is closed in the same quarter in previous Year in secondary currency.
PREV_PER_QTR_WLRATIO_S	NUMBER		Sum of Win/Loss Ratio if the opty is closed in the same quarter in previous period in secondary currency.
PREV_YR_YEAR_WLRATIO_S	NUMBER		Sum of Win/Loss Ratio if the opty is closed in the same year in previous Year in secondary currency.
PREV_PER_YEAR_WLRATIO_S	NUMBER		Sum of Win/Loss Ratio if the opty is closed in the same year in previous period in secondary currency.
FRCST_AMT_WEEK	NUMBER		Sum of week forecast amonut in primary currency.
FRCST_AMT_WEEK_S	NUMBER		Sum of week forecast amonut in secondary currency.
FRCST_AMT_PERIOD	NUMBER		Sum of period forecast amonut in primary currency.
FRCST_AMT_PERIOD_S	NUMBER		Sum of period forecast amonut in secondary currency.
FRCST_AMT_QTR	NUMBER		Sum of quarter forecast amonut in primary currency.
FRCST_AMT_QTR_S	NUMBER		Sum of quarter forecast amonut in secondary currency.
FRCST_AMT_YEAR	NUMBER		Sum of year forecast amonut in primary currency.
FRCST_AMT_YEAR_S	NUMBER		Sum of year forecast amonut in secondary currency.
PREV_YR_YEAR_FRCST_AMT	NUMBER		Sum of forecast amonut for year in previous year in primary currency.
PREV_YR_YEAR_FRCST_AMT_S	NUMBER		Sum of forecast amonut for year in previous year in secondary currency.
PREV_PER_YEAR_FRCST_AMT	NUMBER		Sum of forecast amonut for year in previous period in primary currency.
PREV_PER_YEAR_FRCST_AMT_S	NUMBER		Sum of forecast amonut for year in previous period in secondary currency.
PREV_YR_QTR_FRCST_AMT	NUMBER		Sum of forecast amonut for quarter in previous year in primary currency.
PREV_PER_QTR_FRCST_AMT	NUMBER		Sum of forecast amonut for quarter in previous period in primary currency.
PREV_YR_QTR_FRCST_AMT_S	NUMBER		Sum of forecast amonut for quarter in previous year in secondary currency.
PREV_PER_QTR_FRCST_AMT_S	NUMBER		Sum of forecast amonut for quarter in previous period in secondary currency.
PREV_YR_PERIOD_FRCST_AMT	NUMBER		Sum of forecast amonut for period in previous year in primary currency.
PREV_PER_PERIOD_FRCST_AMT	NUMBER		Sum of forecast amonut for period in previous period in primary currency.
PREV_YR_PERIOD_FRCST_AMT_S	NUMBER		Sum of forecast amonut for period in previous year in secondary currency.
PREV_PER_PERIOD_FRCST_AMT_S	NUMBER		Sum of forecast amonut for period in previous period in secondary currency.
PREV_YR_WEEK_FRCST_AMT	NUMBER		Sum of forecast amonut for week in previous year in primary currency.
PREV_PER_WEEK_FRCST_AMT	NUMBER		Sum of forecast amonut for week in previous period in primary currency.
PREV_YR_WEEK_FRCST_AMT_S	NUMBER		Sum of forecast amonut for week in previous year in secondary currency.
PREV_PER_WEEK_FRCST_AMT_S	NUMBER		Sum of forecast amonut for week in previous period in secondary currency.
PIPELINE_AMT_WEEK	NUMBER		Sum of pipeline amounts if the opty is closed in the same week in Primary currency.
PIPELINE_AMT_PERIOD	NUMBER		Sum of pipeline amounts if the opty is closed in the same period in Primary currency.
PIPELINE_AMT_QTR	NUMBER		Sum of pipeline amounts if the opty is closed in the same quarter in Primary currency.
PIPELINE_AMT_YEAR	NUMBER		Sum of pipeline amounts if the opty is closed in the same year in Primary currency.
PIPELINE_AMT_WEEK_S	NUMBER		Sum of pipeline amounts if the opty is closed in the same week in Secondary currency.
PIPELINE_AMT_PERIOD_S	NUMBER		Sum of pipeline amounts if the opty is closed in the same period in Secondary currency.
PIPELINE_AMT_QTR_S	NUMBER		Sum of pipeline amounts if the opty is closed in the same quarter in Secondary currency.
PIPELINE_AMT_YEAR_S	NUMBER		Sum of pipeline amounts if the opty is closed in the same year in Secondary currency.
PREV_YR_YEAR_PIP_AMT	NUMBER		Sum of pipeline amounts if the opty is closed in the same Year previous year in Primary currency.
PREV_YR_YEAR_PIP_AMT_S	NUMBER		Sum of pipeline amounts if the opty is closed in the same Year previous Year in Secondary currency.
PREV_PER_YEAR_PIP_AMT	NUMBER		Sum of pipeline amounts if the opty is closed in the same Year previous year in Primary currency.
PREV_PER_YEAR_PIP_AMT_S	NUMBER		Sum of pipeline amounts if the opty is closed in the same Year previous Year in Secondary currency.
PREV_YR_QTR_PIP_AMT	NUMBER		Sum of pipeline amounts if the opty is closed in the same quarter previous year in Primary currency.
PREV_PER_QTR_PIP_AMT	NUMBER		Sum of pipeline amounts if the opty is closed in the same quarter previous period in Primary currency.
PREV_YR_QTR_PIP_AMT_S	NUMBER		Sum of pipeline amounts if the opty is closed in the same quarter previous Year in Secondary currency.
PREV_PER_QTR_PIP_AMT_S	NUMBER		Sum of pipeline amounts if the opty is closed in the same quarter previous period in Secondary currency.
PREV_YR_PERIOD_PIP_AMT	NUMBER		Sum of pipeline amounts if the opty is closed in the same period previous year in Primary currency.
PREV_PER_PERIOD_PIP_AMT	NUMBER		Sum of pipeline amounts if the opty is closed in the same period previous period in Primary currency.
PREV_YR_PERIOD_PIP_AMT_S	NUMBER		Sum of pipeline amounts if the opty is closed in the same period previous Year in Secondary currency.
PREV_PER_PERIOD_PIP_AMT_S	NUMBER		Sum of pipeline amounts if the opty is closed in the same period previous period in Secondary currency.
PREV_YR_WEEK_PIP_AMT	NUMBER		Sum of pipeline amounts if the opty is closed in the same week previous year in Primary currency.
PREV_PER_WEEK_PIP_AMT	NUMBER		Sum of pipeline amounts if the opty is closed in the same week previous period in Primary currency.
PREV_YR_WEEK_PIP_AMT_S	NUMBER		Sum of pipeline amounts if the opty is closed in the same week previous Year in Secondary currency.
PREV_PER_WEEK_PIP_AMT_S	NUMBER		Sum of pipeline amounts if the opty is closed in the same week previous period 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_QTR_RANK
,      TOP_WON_YEAR_RANK
,      BOTTOM_WON_WEEK_RANK
,      BOTTOM_WON_PERIOD_RANK
,      BOTTOM_WON_QTR_RANK
,      BOTTOM_WON_YEAR_RANK
,      WON_WEEK_LAST_RANK
,      WON_PERIOD_LAST_RANK
,      WON_QTR_LAST_RANK
,      WON_YEAR_LAST_RANK
,      TOP_WINLOSS_WEEK_RANK
,      TOP_WINLOSS_PERIOD_RANK
,      TOP_WINLOSS_QTR_RANK
,      TOP_WINLOSS_YEAR_RANK
,      BOTTOM_WINLOSS_WEEK_RANK
,      BOTTOM_WINLOSS_PERIOD_RANK
,      BOTTOM_WINLOSS_QTR_RANK
,      BOTTOM_WINLOSS_YEAR_RANK
,      WINLOSS_WEEK_LAST_RANK
,      WINLOSS_PERIOD_LAST_RANK
,      WINLOSS_QTR_LAST_RANK
,      WINLOSS_YEAR_LAST_RANK
,      TOP_BOOKED_WEEK_RANK
,      TOP_BOOKED_PERIOD_RANK
,      TOP_BOOKED_QTR_RANK
,      TOP_BOOKED_YEAR_RANK
,      BOTTOM_BOOKED_WEEK_RANK
,      BOTTOM_BOOKED_PERIOD_RANK
,      BOTTOM_BOOKED_QTR_RANK
,      BOTTOM_BOOKED_YEAR_RANK
,      BOOKED_YEAR_LAST_RANK
,      BOOKED_QTR_LAST_RANK
,      BOOKED_PERIOD_LAST_RANK
,      BOOKED_WEEK_LAST_RANK
,      WON_AMT_WEEK
,      WON_AMT_PERIOD
,      WON_AMT_QTR
,      WON_AMT_YEAR
,      WON_AMT_WEEK_S
,      WON_AMT_PERIOD_S
,      WON_AMT_QTR_S
,      WON_AMT_YEAR_S
,      PREV_YR_WEEK_WON_AMT
,      PREV_PER_WEEK_WON_AMT
,      PREV_YR_PERIOD_WON_AMT
,      PREV_PER_PERIOD_WON_AMT
,      PREV_YR_QTR_WON_AMT
,      PREV_PER_QTR_WON_AMT
,      PREV_YR_YEAR_WON_AMT
,      PREV_PER_YEAR_WON_AMT
,      PREV_YR_WEEK_WON_AMT_S
,      PREV_PER_WEEK_WON_AMT_S
,      PREV_YR_PERIOD_WON_AMT_S
,      PREV_PER_PERIOD_WON_AMT_S
,      PREV_YR_QTR_WON_AMT_S
,      PREV_PER_QTR_WON_AMT_S
,      PREV_YR_YEAR_WON_AMT_S
,      PREV_PER_YEAR_WON_AMT_S
,      BOOKED_AMT_WEEK
,      BOOKED_AMT_PERIOD
,      BOOKED_AMT_QTR
,      BOOKED_AMT_YEAR
,      BOOKED_AMT_WEEK_S
,      BOOKED_AMT_PERIOD_S
,      BOOKED_AMT_QTR_S
,      BOOKED_AMT_YEAR_S
,      PREV_YR_WEEK_BOOKED_AMT
,      PREV_PER_WEEK_BOOKED_AMT
,      PREV_YR_PERIOD_BOOKED_AMT
,      PREV_PER_PERIOD_BOOKED_AMT
,      PREV_YR_QTR_BOOKED_AMT
,      PREV_PER_QTR_BOOKED_AMT
,      PREV_YR_YEAR_BOOKED_AMT
,      PREV_PER_YEAR_BOOKED_AMT
,      PREV_YR_WEEK_BOOKED_AMT_S
,      PREV_PER_WEEK_BOOKED_AMT_S
,      PREV_YR_PERIOD_BOOKED_AMT_S
,      PREV_PER_PERIOD_BOOKED_AMT_S
,      PREV_YR_QTR_BOOKED_AMT_S
,      PREV_PER_QTR_BOOKED_AMT_S
,      PREV_YR_YEAR_BOOKED_AMT_S
,      PREV_PER_YEAR_BOOKED_AMT_S
,      WINLOSS_RATIO_WEEK
,      WINLOSS_RATIO_PERIOD
,      WINLOSS_RATIO_QTR
,      WINLOSS_RATIO_YEAR
,      WINLOSS_RATIO_WEEK_S
,      WINLOSS_RATIO_PERIOD_S
,      WINLOSS_RATIO_QTR_S
,      WINLOSS_RATIO_YEAR_S
,      PREV_YR_WEEK_WLRATIO
,      PREV_PER_WEEK_WLRATIO
,      PREV_YR_PERIOD_WLRATIO
,      PREV_PER_PERIOD_WLRATIO
,      PREV_YR_QTR_WLRATIO
,      PREV_PER_QTR_WLRATIO
,      PREV_YR_YEAR_WLRATIO
,      PREV_PER_YEAR_WLRATIO
,      PREV_YR_WEEK_WLRATIO_S
,      PREV_PER_WEEK_WLRATIO_S
,      PREV_YR_PERIOD_WLRATIO_S
,      PREV_PER_PERIOD_WLRATIO_S
,      PREV_YR_QTR_WLRATIO_S
,      PREV_PER_QTR_WLRATIO_S
,      PREV_YR_YEAR_WLRATIO_S
,      PREV_PER_YEAR_WLRATIO_S
,      FRCST_AMT_WEEK
,      FRCST_AMT_WEEK_S
,      FRCST_AMT_PERIOD
,      FRCST_AMT_PERIOD_S
,      FRCST_AMT_QTR
,      FRCST_AMT_QTR_S
,      FRCST_AMT_YEAR
,      FRCST_AMT_YEAR_S
,      PREV_YR_YEAR_FRCST_AMT
,      PREV_YR_YEAR_FRCST_AMT_S
,      PREV_PER_YEAR_FRCST_AMT
,      PREV_PER_YEAR_FRCST_AMT_S
,      PREV_YR_QTR_FRCST_AMT
,      PREV_PER_QTR_FRCST_AMT
,      PREV_YR_QTR_FRCST_AMT_S
,      PREV_PER_QTR_FRCST_AMT_S
,      PREV_YR_PERIOD_FRCST_AMT
,      PREV_PER_PERIOD_FRCST_AMT
,      PREV_YR_PERIOD_FRCST_AMT_S
,      PREV_PER_PERIOD_FRCST_AMT_S
,      PREV_YR_WEEK_FRCST_AMT
,      PREV_PER_WEEK_FRCST_AMT
,      PREV_YR_WEEK_FRCST_AMT_S
,      PREV_PER_WEEK_FRCST_AMT_S
,      PIPELINE_AMT_WEEK
,      PIPELINE_AMT_PERIOD
,      PIPELINE_AMT_QTR
,      PIPELINE_AMT_YEAR
,      PIPELINE_AMT_WEEK_S
,      PIPELINE_AMT_PERIOD_S
,      PIPELINE_AMT_QTR_S
,      PIPELINE_AMT_YEAR_S
,      PREV_YR_YEAR_PIP_AMT
,      PREV_YR_YEAR_PIP_AMT_S
,      PREV_PER_YEAR_PIP_AMT
,      PREV_PER_YEAR_PIP_AMT_S
,      PREV_YR_QTR_PIP_AMT
,      PREV_PER_QTR_PIP_AMT
,      PREV_YR_QTR_PIP_AMT_S
,      PREV_PER_QTR_PIP_AMT_S
,      PREV_YR_PERIOD_PIP_AMT
,      PREV_PER_PERIOD_PIP_AMT
,      PREV_YR_PERIOD_PIP_AMT_S
,      PREV_PER_PERIOD_PIP_AMT_S
,      PREV_YR_WEEK_PIP_AMT
,      PREV_PER_WEEK_PIP_AMT
,      PREV_YR_WEEK_PIP_AMT_S
,      PREV_PER_WEEK_PIP_AMT_S
FROM APPS.BIL_BI_SLS_PERF_MV;

Dependencies

[top of page]

APPS.BIL_BI_SLS_PERF_MV references the following:

APPS: BIL_BI_CAL_MV; BIL_BI_CAL_MV; BIL_BI_FST_DTL_F; BIL_BI_OPTY_G_MV; BIL_BI_OPTY_G_MV; BIL_BI_PIPEC_G_MV; BIL_BI_PIPEC_G_MV; BIL_BI_SLS_PERF1_MV; BIL_BI_SLS_PERF1_MV; BIL_BI_SLS_PERF_MV; ISC_DBI_SCR_001_MV; ISC_DBI_SCR_001_MV
BIL: BIL_BI_FST_DTL_F

APPS.BIL_BI_SLS_PERF_MV is not referenced by any database object