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

TABLE: APPS.BIL_BI_OP11_PG_MV

Object Details
Object Name: BIL_BI_OP11_PG_MV
Object Type: TABLE
Owner: APPS
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
UMARKER CHAR (3)
Required for MVs using Union All for fast refreshability. SLSGRP, SLSREP for sales group and sales rep union all
EFFECTIVE_TIME_ID NUMBER

The creation/close/conversion/ date the opportunity and forecast date for won opportunity
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 to which the item in this sales credit line belongs to
ITEM_ID NUMBER

NULL for valid items and -1 for rows in assigned to category union all
NEW_OPTY_AMT NUMBER

Sales credit amount in primary currency
NEW_OPTY_AMT_S NUMBER

Sales credit amount in secondary currency
LATEST_OPEN_OPTY_AMT NUMBER

The sum of sales credit amount for opportunities with forecastable and open status flags as Y (used for the competitor report) in primary currency
LATEST_OPEN_OPTY_AMT_S NUMBER

The sum of sales credit amount for opportunities with forecastable and open status flags as Y (used for the competitor report) in secondary currency
WON_OPTY_AMT NUMBER

Sales credit amount If the opportunity has been WON in primary currency.
WON_OPTY_AMT_S NUMBER

Sales credit amount If the opportunity has been WON in secondary currency.
LOST_OPTY_AMT NUMBER

Sales credit amount If the opportunity has been LOST in primary currency.
LOST_OPTY_AMT_S NUMBER

Sales credit amount If the opportunity has been LOST in secondary currency.
NO_OPTY_AMT NUMBER

Sales credit amount If the opportunity has been NO OPPORTUNITY in primary currency.
NO_OPTY_AMT_S NUMBER

Sales credit amount If the opportunity has been NO OPPORTUNITY in secondary currency.
CNV_OPTY_AMT NUMBER

Sales credit amount If the opportunity has been Linked to / converted from a lead in primary currency
CNV_OPTY_AMT_S NUMBER

Sales credit amount If the opportunity has been Linked to / converted from a lead
NFP_YR NUMBER

Sum of sales credit if the opty is created and closed in the same year in primary currency
NFP_YR_S NUMBER

Sum of sales credit if the opty is created and closed in the same year in secondary currency
NFP_QTR NUMBER

Sum of sales credit if the opty is created and closed in the same quarter in primary currency
NFP_QTR_S NUMBER

Sum of sales credit if the opty is created and closed in the same quarter in secondary currency
NFP_PER NUMBER

Sum of sales credit if the opty is created and closed in the same period in primary currency
NFP_PER_S NUMBER

Sum of sales credit if the opty is created and closed in the same period in secondary currency
NFP_WK NUMBER

Sum of sales credit if the opty is created and closed in the same week in primary currency
NFP_WK_S NUMBER

Sum of sales credit if the opty is created and closed in the same week in secondary currency
NEW_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
LATEST_OPEN_OPTY_XCNT NUMBER

Dummy count column required to create fast refresh MV
LATEST_OPEN_OPTY_XCNT_S NUMBER

Dummy count column required to create fast refresh MV
WON_OPTY_XCNT 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 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 NUMBER

Dummy count column required to create fast refresh MV
NO_OPTY_XCNT_S NUMBER

Dummy count column required to create fast refresh MV
CNV_OPTY_XCNT NUMBER

Dummy count column required to create fast refresh MV
CNV_OPTY_XCNT_S NUMBER

Dummy count column required to create fast refresh MV
NFP_YR_XCNT NUMBER

Dummy count column required to create fast refresh MV
NFP_YR_XCNT_S NUMBER

Dummy count column required to create fast refresh MV
NFP_QTR_XCNT NUMBER

Dummy count column required to create fast refresh MV
NFP_QTR_XCNT_S NUMBER

Dummy count column required to create fast refresh MV
NFP_PER_XCNT NUMBER

Dummy count column required to create fast refresh MV
NFP_PER_XCNT_S NUMBER

Dummy count column required to create fast refresh MV
NFP_WK_XCNT NUMBER

Dummy count column required to create fast refresh MV
NFP_WK_XCNT_S NUMBER

Dummy count column required to create fast refresh MV
XCNT NUMBER

Dummy count column required to create fast refresh MV
Query Text

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


SELECT UMARKER
,      EFFECTIVE_TIME_ID
,      SALES_GROUP_ID
,      SALESREP_ID
,      PRODUCT_CATEGORY_ID
,      ITEM_ID
,      NEW_OPTY_AMT
,      NEW_OPTY_AMT_S
,      LATEST_OPEN_OPTY_AMT
,      LATEST_OPEN_OPTY_AMT_S
,      WON_OPTY_AMT
,      WON_OPTY_AMT_S
,      LOST_OPTY_AMT
,      LOST_OPTY_AMT_S
,      NO_OPTY_AMT
,      NO_OPTY_AMT_S
,      CNV_OPTY_AMT
,      CNV_OPTY_AMT_S
,      NFP_YR
,      NFP_YR_S
,      NFP_QTR
,      NFP_QTR_S
,      NFP_PER
,      NFP_PER_S
,      NFP_WK
,      NFP_WK_S
,      NEW_OPTY_XCNT
,      NEW_OPTY_XCNT_S
,      LATEST_OPEN_OPTY_XCNT
,      LATEST_OPEN_OPTY_XCNT_S
,      WON_OPTY_XCNT
,      WON_OPTY_XCNT_S
,      LOST_OPTY_XCNT
,      LOST_OPTY_XCNT_S
,      NO_OPTY_XCNT
,      NO_OPTY_XCNT_S
,      CNV_OPTY_XCNT
,      CNV_OPTY_XCNT_S
,      NFP_YR_XCNT
,      NFP_YR_XCNT_S
,      NFP_QTR_XCNT
,      NFP_QTR_XCNT_S
,      NFP_PER_XCNT
,      NFP_PER_XCNT_S
,      NFP_WK_XCNT
,      NFP_WK_XCNT_S
,      XCNT
FROM APPS.BIL_BI_OP11_PG_MV;

Dependencies

[top of page]

APPS.BIL_BI_OP11_PG_MV does not reference any database object

APPS.BIL_BI_OP11_PG_MV is referenced by following:

SchemaAPPS
Materialized ViewBIL_BI_OP11_PG_MV
Materialized ViewBIL_BI_OP12_PG_MV