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

MATERIALIZED VIEW: APPS.BIL_BI_FST1_PG_MV

Object Details
Object Name: BIL_BI_FST1_PG_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: BIL_BI_FST1_PG_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_FST_DTL_F
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 VARCHAR2 (8)
Dummy count columns required to create fast refresh MV.
TXN_TIME_ID NUMBER

Transaction date is Last update date representing As-of-date.
TXN_PERIOD_TYPE_ID NUMBER

Period type of txn_time_id. Valid period type in BIS Enterprise calendar.
EFFECTIVE_TIME_ID NUMBER

Effective date rolled up over week, period, quarter, year.
EFFECTIVE_PERIOD_TYPE_ID NUMBER

Period type of effective_time_id. Valid period type in BIS Enterprise calendar.
PARENT_SALES_GROUP_ID NUMBER

Sales group identifier.
SALES_GROUP_ID NUMBER

Parent sales group identifier .
SALESREP_ID NUMBER

Salesperson or resource identifier.
ALL_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
FORECAST_AMT_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
FORECAST_AMT_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
FORECAST_AMT NUMBER

My Forecast Amounts in primary currency.
FORECAST_AMT_S NUMBER

My Forecast Amounts in secondary currency.
FORECAST_AMT_SUB NUMBER

Forecast Amount for my Subordinates in primary currency.
FORECAST_AMT_SUB_S NUMBER

Forecast Amount for my Subordinates in secondary currency.
PRODUCT_CATEGORY_ID NUMBER

Identifier of Product Category.
CREDIT_TYPE_ID NUMBER

Identifier of Forecast Credit Type.
OPP_FORECAST_AMT NUMBER

Opportunity forecast amount in primary currency.
OPP_FORECAST_AMT_S NUMBER

Opportunity forecast amount in secondary currency.
OPP_FORECAST_AMT_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
OPP_FORECAST_AMT_S_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
OPP_FORECAST_AMT_SUB NUMBER

Opportunity forecast amount in primary currency for subordinates.
OPP_FORECAST_AMT_SUB_S NUMBER

Opportunity forecast amount in secondary currency for subordinates.
OPP_FORECAST_AMT_SUB_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
OPP_FORECAST_AMT_SUB_S_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT UMARKER
,      TXN_TIME_ID
,      TXN_PERIOD_TYPE_ID
,      EFFECTIVE_TIME_ID
,      EFFECTIVE_PERIOD_TYPE_ID
,      PARENT_SALES_GROUP_ID
,      SALES_GROUP_ID
,      SALESREP_ID
,      ALL_XCNT
,      FORECAST_AMT_XCNT
,      FORECAST_AMT_XCNT_S
,      FORECAST_AMT
,      FORECAST_AMT_S
,      FORECAST_AMT_SUB
,      FORECAST_AMT_SUB_S
,      PRODUCT_CATEGORY_ID
,      CREDIT_TYPE_ID
,      OPP_FORECAST_AMT
,      OPP_FORECAST_AMT_S
,      OPP_FORECAST_AMT_XCNT
,      OPP_FORECAST_AMT_S_XCNT
,      OPP_FORECAST_AMT_SUB
,      OPP_FORECAST_AMT_SUB_S
,      OPP_FORECAST_AMT_SUB_XCNT
,      OPP_FORECAST_AMT_SUB_S_XCNT
FROM APPS.BIL_BI_FST1_PG_MV;

Dependencies

[top of page]

APPS.BIL_BI_FST1_PG_MV references the following:

SchemaAPPS
TableBIL_BI_FST1_PG_MV
TableBIL_BI_RS_GRP_MV
Materialized ViewBIL_BI_RS_GRP_MV
SchemaBIL
TableBIL_BI_FST_DTL_F
APPS.BIL_BI_FST1_PG_MV is referenced by following:

SchemaAPPS
Materialized ViewBIL_BI_FST_G_MV
Materialized ViewBIL_BI_FST_PG_MV
Materialized ViewBIL_OBI_FST_PG_MV