[Home] [Help] [Dependency Information]
Object Name: | BIL_OBI_PIPE_G_MV |
---|---|
Object Type: | MATERIALIZED VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Container: | BIL_OBI_PIPE_G_MV |
---|---|
Updatable: | N |
Rewrite Enabled: | N |
Rewrite Capability: | TEXTMATCH |
Refresh Mode: | DEMAND |
Refresh Method: | FAST |
Build Mode: | DEFERRED |
Fast Refreshable: | DIRLOAD_DML |
BIL_BI_PIPE_MV
BIL_BI_PIPELINE_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
BIS_BUCKET
BIS_BUCKET_CUSTOMIZATIONS
ENI_OLTP_ITEM_STAR
FII_TIME_DAY
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UMARKER | VARCHAR2 | (7) | Required for MVs using Union All for fast refreshability. | |
PARENT_SALES_GROUP_ID | NUMBER | Parent group identifier for the sales group. | ||
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. | ||
EFFECTIVE_TIME_ID | NUMBER | Effective date rolled up over day, week, period, quarter, year to display pipeline data for period end | ||
PRODUCT_CATEGORY_ID | NUMBER | The product category to which the item in this sales credit line belongs to. | ||
ITEM_ID | NUMBER | The concatenated value of item and the master org id. If the opportunity line is assigned to category then -1. | ||
ROLLUP_FLAG | VARCHAR2 | (1) | Flag to distinguish between rollup and non-rolled up amount | |
PIPELINE_AMT | NUMBER | Sum of pipeline amounts if the opty is closed in the same period in primary currency. | ||
WTD_PIPELINE_AMT | NUMBER | Sum of total weighted pipeline amounts if the opty is closed in the same period in primary currency. | ||
OPEN_AMT | NUMBER | Sum of open amounts if the opty is closed in the same period in primary currency. | ||
PERIOD_OPEN_AMT | NUMBER | Sum of open amounts at the start date of the period for those opty having close date in the same period in primary currency. | ||
PIPELINE_AMT_S | NUMBER | Sum of pipeline amounts if the opty is closed in the same period in secondary currency. | ||
WTD_PIPELINE_AMT_S | NUMBER | Sum of total weighted pipeline amounts if the opty is closed in the same period in secondary currency. | ||
OPEN_AMT_S | NUMBER | Sum of open amounts if the opty is closed in the same period in secondary currency. | ||
PERIOD_OPEN_AMT_S | NUMBER | Sum of open amounts at the start date of the period for those opty having close date in the same period in secondary currency. | ||
PIPELINE_AMT_XCNT | NUMBER | Dummy count column required to create fast refresh MV | ||
WTD_PIPELINE_AMT_XCNT | NUMBER | Dummy count column required to create fast refresh MV | ||
OPEN_AMT_XCNT | NUMBER | Dummy count column required to create fast refresh MV | ||
PERIOD_OPEN_AMT_XCNT | NUMBER | Dummy count column required to create fast refresh MV | ||
PIPELINE_AMT_XCNT_S | NUMBER | Dummy count column required to create fast refresh MV | ||
WTD_PIPELINE_AMT_XCNT_S | NUMBER | Dummy count column required to create fast refresh MV | ||
OPEN_AMT_XCNT_S | NUMBER | Dummy count column required to create fast refresh MV | ||
PERIOD_OPEN_AMT_XCNT_S | 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
, PARENT_SALES_GROUP_ID
, SALES_GROUP_ID
, SALESREP_ID
, EFFECTIVE_TIME_ID
, PRODUCT_CATEGORY_ID
, ITEM_ID
, ROLLUP_FLAG
, PIPELINE_AMT
, WTD_PIPELINE_AMT
, OPEN_AMT
, PERIOD_OPEN_AMT
, PIPELINE_AMT_S
, WTD_PIPELINE_AMT_S
, OPEN_AMT_S
, PERIOD_OPEN_AMT_S
, PIPELINE_AMT_XCNT
, WTD_PIPELINE_AMT_XCNT
, OPEN_AMT_XCNT
, PERIOD_OPEN_AMT_XCNT
, PIPELINE_AMT_XCNT_S
, WTD_PIPELINE_AMT_XCNT_S
, OPEN_AMT_XCNT_S
, PERIOD_OPEN_AMT_XCNT_S
, XCNT
FROM APPS.BIL_OBI_PIPE_G_MV;
APPS.BIL_OBI_PIPE_G_MV is not referenced by any database object
|
|
|