DBA Data[Home] [Help] [Dependency Information]

MATERIALIZED VIEW: APPS.BIL_BI_OPLDC_GC_MV

Object Details
Object Name: BIL_BI_OPLDC_GC_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: BIL_BI_OPLDC_GC_MV
Updatable: N
Rewrite Enabled: N
Rewrite Capability: TEXTMATCH
Refresh Mode: DEMAND
Refresh Method: FAST
Build Mode: DEFERRED
Fast Refreshable: DIRLOAD_DML
MV Log Dependencies:

BIL_BI_OPLDC_G_MV
     BIL_BI_OPLDC_MV
          BIL_BI_OPDTL_MV
               BIL_BI_OPDTL_F
               ENI_OLTP_ITEM_STAR
               FII_TIME_DAY
               JTF_RS_GROUP_USAGES
          BIM_I_LD_BASE_MV
               BIM_I_LD_HEADER_MV
                    BIM_I_LEAD_FACTS
               BIM_R_CODE_DEFINITIONS
     BIM_I_SOURCE_DENORM
     FII_TIME_DAY
BIL_BI_RS_GRP_MV
     BIL_BI_GRP_CNT_MV
          JTF_RS_GROUPS_DENORM
          JTF_RS_GROUP_USAGES
     JTF_RS_GROUPS_DENORM
     JTF_RS_GROUP_USAGES

[View Source Query]

Columns
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() etc Are used for fast refreshability
ENT_QTR_ID NUMBER

Columns like ent_yr_id,grouping_id() etc Are used for fast refreshability
ENT_PERIOD_ID NUMBER

Columns like ent_yr_id,grouping_id() etc Are used for fast refreshability
WEEK_ID NUMBER

Columns like ent_yr_id,grouping_id() etc Are used for fast refreshability
REPORT_DATE_JULIAN NUMBER

Columns like ent_yr_id,grouping_id() etc Are used for fast refreshability
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
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 curency) opportunities created
CNV_OPTY_AMT NUMBER

Sales credit amount (in primary curency) If the opportunity has been Linked to / converted from a lead
WON_OPTY_AMT NUMBER

Sales credit amount (in primary curency) If the opportunity is a WON
LOST_OPTY_AMT NUMBER

Sales credit amount (in primary curency) If the opportunity is a LOST
NO_OPTY_AMT NUMBER

Sales credit amount (in primary curency) If the opportunity is a NO OPPORTUNITY
NEW_OPTY_AMT_S NUMBER

Sales credit amount (in secondary curency) opportunities created
CNV_OPTY_AMT_S NUMBER

Sales credit amount (in secondary curency) If the opportunity has been Linked to / converted from a lead
WON_OPTY_AMT_S NUMBER

Sales credit amount (in secondary curency) If the opportunity is a WON
LOST_OPTY_AMT_S NUMBER

Sales credit amount (in secondary curency) If the opportunity is a LOST
NO_OPTY_AMT_S NUMBER

Sales credit amount (in secondary curency) 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() etc Are used for fast refreshability
Query Text

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
,      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_OPLDC_GC_MV;

Dependencies

[top of page]

APPS.BIL_BI_OPLDC_GC_MV references the following:

SchemaAPPS
TableBIL_BI_OPLDC_GC_MV
Materialized ViewBIL_BI_OPLDC_G_MV
TableBIL_BI_OPLDC_G_MV
TableBIL_BI_RS_GRP_MV
Materialized ViewBIL_BI_RS_GRP_MV

APPS.BIL_BI_OPLDC_GC_MV is not referenced by any database object