[Home] [Help] [Dependency Information]
Object Name: | BIL_BI_OPLPC_GC_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_OPLPC_GC_MV_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
SALES_GROUP_ID
EFFECTIVE_TIME_ID EFFECTIVE_PERIOD_TYPE_ID TOP_NODE_FLAG PARENT_SOURCE_CODE_ID SALESREP_ID |
BIL_BI_OPLPC_GC_MV_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
SALES_GROUP_ID
EFFECTIVE_TIME_ID PARENT_SOURCE_CODE_ID EFFECTIVE_PERIOD_TYPE_ID SALESREP_ID PRODUCT_CATEGORY_ID |
BIL_BI_OPLPC_GC_MV_N3 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
XCNT
UMARKER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UMARKER | CHAR | (6) | Required for MVs using Union All for fast refreshability | |
EFFECTIVE_PERIOD_TYPE_ID | NUMBER | Represents the period type of the effective_time_id column. Value is one of 1/16/32/64/128 | ||
EFFECTIVE_TIME_ID | NUMBER | Represents day/week/period/qtr/yr ID depending on the grouping id produced by the time rollup | ||
ENT_YEAR_ID | NUMBER | Columns like ent_yr_id,grouping_id( | ||
ENT_QTR_ID | NUMBER | Columns like ent_yr_id,grouping_id( | ||
ENT_PERIOD_ID | NUMBER | Columns like ent_yr_id,grouping_id( | ||
WEEK_ID | NUMBER | Columns like ent_yr_id,grouping_id( | ||
REPORT_DATE_JULIAN | NUMBER | Columns like ent_yr_id,grouping_id( | ||
SALES_GROUP_ID | NUMBER | The parent sales group of the sales group in the sales_group_id column | ||
SALESREP_ID | NUMBER | Salesperson or resource identifier who gets sales credits. Will never be null | ||
PRODUCT_CATEGORY_ID | NUMBER | The product category id obtained from the latest item to product category mapping | ||
SOURCE_CODE_ID | NUMBER | (30) | The source code identifier used for campaign based analysis | |
PARENT_SOURCE_CODE_ID | NUMBER | The source code identifier of the parent source code | ||
TOP_NODE_FLAG | VARCHAR2 | (30) | Flag indicating whether a source code is a top node in source code denorm table | |
LEAF_NODE_FLAG | VARCHAR2 | (30) | Flag indicating whether a source code is a leaf node in source code denorm table | |
NEW_LEADS_CNT | NUMBER | The count of new leads created | ||
CNV_LEADS_CNT | NUMBER | The count of leads converted into opportunities | ||
DEAD_LEADS_CNT | NUMBER | The count of leads marked as dead | ||
CLOSED_LEADS_CNT | NUMBER | The count of leads closed | ||
NEW_OPTY_AMT | NUMBER | Sales credit amount (in primary currency) opportunities created | ||
CNV_OPTY_AMT | NUMBER | Sales credit amount (in primary currency) If the opportunity has been Linked to / converted from a lead | ||
WON_OPTY_AMT | NUMBER | Sales credit amount (in primary currency) If the opportunity is a WON | ||
LOST_OPTY_AMT | NUMBER | Sales credit amount (in primary currency) If the opportunity is a LOST | ||
NO_OPTY_AMT | NUMBER | Sales credit amount (in primary currency) If the opportunity is a NO OPPORTUNITY | ||
NEW_OPTY_AMT_S | NUMBER | Sales credit amount (in secondary currency) opportunities created | ||
CNV_OPTY_AMT_S | NUMBER | Sales credit amount (in secondary currency) If the opportunity has been Linked to / converted from a lead | ||
WON_OPTY_AMT_S | NUMBER | Sales credit amount (in secondary currency) If the opportunity is a WON | ||
LOST_OPTY_AMT_S | NUMBER | Sales credit amount (in secondary currency) If the opportunity is a LOST | ||
NO_OPTY_AMT_S | NUMBER | Sales credit amount (in secondary currency) If the opportunity is a NO OPPORTUNITY | ||
NEW_LEADS_XCNT | NUMBER | Dummy count column required to create fast refresh MV | ||
CNV_LEADS_XCNT | NUMBER | Dummy count column required to create fast refresh MV | ||
DEAD_LEADS_XCNT | NUMBER | Dummy count column required to create fast refresh MV | ||
CLOSED_LEADS_XCNT | NUMBER | Dummy count column required to create fast refresh MV | ||
NEW_OPTY_XCNT | NUMBER | Dummy count column required to create fast refresh MV | ||
CNV_OPTY_XCNT | NUMBER | Dummy count column required to create fast refresh MV | ||
WON_OPTY_XCNT | NUMBER | Dummy count column required to create fast refresh MV | ||
LOST_OPTY_XCNT | NUMBER | Dummy count column required to create fast refresh MV | ||
NO_OPTY_AMT_XCNT | NUMBER | Dummy count column required to create fast refresh MV | ||
NEW_OPTY_XCNT_S | NUMBER | Dummy count column required to create fast refresh MV | ||
CNV_OPTY_XCNT_S | NUMBER | Dummy count column required to create fast refresh MV | ||
WON_OPTY_XCNT_S | NUMBER | Dummy count column required to create fast refresh MV | ||
LOST_OPTY_XCNT_S | NUMBER | Dummy count column required to create fast refresh MV | ||
NO_OPTY_AMT_XCNT_S | NUMBER | Dummy count column required to create fast refresh MV | ||
XCNT | NUMBER | Dummy count column required to create fast refresh MV | ||
GROUPING_IDENT | NUMBER | Columns like ent_yr_id,grouping_id( |
Cut, paste (and edit) the following text to query this object:
SELECT UMARKER
, EFFECTIVE_PERIOD_TYPE_ID
, EFFECTIVE_TIME_ID
, ENT_YEAR_ID
, ENT_QTR_ID
, ENT_PERIOD_ID
, WEEK_ID
, REPORT_DATE_JULIAN
, SALES_GROUP_ID
, SALESREP_ID
, PRODUCT_CATEGORY_ID
, SOURCE_CODE_ID
, PARENT_SOURCE_CODE_ID
, TOP_NODE_FLAG
, LEAF_NODE_FLAG
, NEW_LEADS_CNT
, CNV_LEADS_CNT
, DEAD_LEADS_CNT
, CLOSED_LEADS_CNT
, NEW_OPTY_AMT
, CNV_OPTY_AMT
, WON_OPTY_AMT
, LOST_OPTY_AMT
, NO_OPTY_AMT
, NEW_OPTY_AMT_S
, CNV_OPTY_AMT_S
, WON_OPTY_AMT_S
, LOST_OPTY_AMT_S
, NO_OPTY_AMT_S
, NEW_LEADS_XCNT
, CNV_LEADS_XCNT
, DEAD_LEADS_XCNT
, CLOSED_LEADS_XCNT
, NEW_OPTY_XCNT
, CNV_OPTY_XCNT
, WON_OPTY_XCNT
, LOST_OPTY_XCNT
, NO_OPTY_AMT_XCNT
, NEW_OPTY_XCNT_S
, CNV_OPTY_XCNT_S
, WON_OPTY_XCNT_S
, LOST_OPTY_XCNT_S
, NO_OPTY_AMT_XCNT_S
, XCNT
, GROUPING_IDENT
FROM APPS.BIL_BI_OPLPC_GC_MV;
APPS.BIL_BI_OPLPC_GC_MV does not reference any database object
APPS.BIL_BI_OPLPC_GC_MV is referenced by following:
|
|
|