[Home] [Help] [Dependency Information]
Object Name: | BIL_BI_OPLPC_MV |
---|---|
Object Type: | MATERIALIZED VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Container: | BIL_BI_OPLPC_MV |
---|---|
Updatable: | N |
Rewrite Enabled: | N |
Rewrite Capability: | TEXTMATCH |
Refresh Mode: | DEMAND |
Refresh Method: | FAST |
Build Mode: | DEFERRED |
Fast Refreshable: | DIRLOAD_DML |
BIL_BI_OPDTL_MV
BIL_BI_OPDTL_F
ENI_OLTP_ITEM_STAR
FII_TIME_DAY
JTF_RS_GROUP_USAGES
BIM_I_LP_BASE_MV
BIM_I_LP_ITEM_MV
BIM_I_LEAD_FACTS
ENI_OLTP_ITEM_STAR
BIM_R_CODE_DEFINITIONS
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UMARKER | VARCHAR2 | (8) | Required for MVs using Union All for fast refreshability | |
EFFECTIVE_TIME_ID | NUMBER | The various dates (close/creation/conversion etc) wrt to each measure (new/converted/dead/closed etc). For Leads it is the txn creation date | ||
SALES_GROUP_ID | NUMBER | Sales group identifier who gets the sales credits | ||
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 | The source code identifier used for campaign based analysis | ||
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 secodary 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 seondary 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_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_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_XCNT_S | NUMBER | Dummy count column required to create fast refresh MV | ||
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 | ||
XCNT | NUMBER | Dummy count column required to create fast refresh MV |
Cut, paste (and edit) the following text to query this object:
SELECT UMARKER
, EFFECTIVE_TIME_ID
, SALES_GROUP_ID
, SALESREP_ID
, PRODUCT_CATEGORY_ID
, SOURCE_CODE_ID
, 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_OPTY_XCNT
, CNV_OPTY_XCNT
, WON_OPTY_XCNT
, LOST_OPTY_XCNT
, NO_OPTY_XCNT
, NEW_OPTY_XCNT_S
, CNV_OPTY_XCNT_S
, WON_OPTY_XCNT_S
, LOST_OPTY_XCNT_S
, NO_OPTY_XCNT_S
, NEW_LEADS_XCNT
, CNV_LEADS_XCNT
, DEAD_LEADS_XCNT
, CLOSED_LEADS_XCNT
, XCNT
FROM APPS.BIL_BI_OPLPC_MV;
|
|
|