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

MATERIALIZED VIEW: APPS.BIL_BI_FST_PG_MV

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

BIL_BI_FST1_PG_MV
     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
ENI_DENORM_HIERARCHIES
MTL_DEFAULT_CATEGORY_SETS

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
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.
PRODUCT_CATEGORY_ID NUMBER

Identifier of Product Category.
ASSIGN_TO_CAT NUMBER

IF 1 then the forecast was for this product category.
CREDIT_TYPE_ID NUMBER

Identifier of Forecast Credit Type.
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.
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_SUB_XCNT NUMBER

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

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

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

Opportunity forecast amount in primary currency.
OPP_FORECAST_AMT_S NUMBER

Opportunity forecast amount in secondary currency.
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_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_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 TXN_TIME_ID
,      TXN_PERIOD_TYPE_ID
,      EFFECTIVE_TIME_ID
,      EFFECTIVE_PERIOD_TYPE_ID
,      PARENT_SALES_GROUP_ID
,      SALES_GROUP_ID
,      SALESREP_ID
,      PRODUCT_CATEGORY_ID
,      ASSIGN_TO_CAT
,      CREDIT_TYPE_ID
,      FORECAST_AMT
,      FORECAST_AMT_S
,      FORECAST_AMT_SUB
,      FORECAST_AMT_SUB_S
,      FORECAST_AMT_XCNT
,      FORECAST_AMT_XCNT_S
,      FORECAST_AMT_SUB_XCNT
,      FORECAST_AMT_SUB_XCNT_S
,      ALL_XCNT
,      OPP_FORECAST_AMT
,      OPP_FORECAST_AMT_S
,      OPP_FORECAST_AMT_SUB
,      OPP_FORECAST_AMT_SUB_S
,      OPP_FORECAST_AMT_XCNT
,      OPP_FORECAST_AMT_S_XCNT
,      OPP_FORECAST_AMT_SUB_XCNT
,      OPP_FORECAST_AMT_SUB_S_XCNT
FROM APPS.BIL_BI_FST_PG_MV;

Dependencies

[top of page]

APPS.BIL_BI_FST_PG_MV references the following:

SchemaAPPS
TableBIL_BI_FST1_PG_MV
Materialized ViewBIL_BI_FST1_PG_MV
TableBIL_BI_FST_PG_MV
SchemaENI
TableENI_DENORM_HIERARCHIES
SchemaINV
TableMTL_DEFAULT_CATEGORY_SETS

APPS.BIL_BI_FST_PG_MV is not referenced by any database object