[Home] [Help] [Dependency Information]
Object Name: | BIL_BI_SLS_PERF1_MV |
---|---|
Object Type: | TABLE |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BIL_BI_SLS_PERF1_MV_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
SALES_GROUP_ID
SALESREP_ID |
Name | Datatype | Length | Mandatory | 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. |
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;
APPS.BIL_BI_SLS_PERF1_MV does not reference any database object
APPS.BIL_BI_SLS_PERF1_MV is referenced by following:
|
|
|