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

MATERIALIZED VIEW: APPS.BIL_BI_TOPOP_G_MV

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

FII_TIME_DAY

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
UMARKER CHAR (6)
If a sales group is chosen in the sales group drop down in the parameter portlet, then use SLSGRP. If a sales rep is chosen, then use SLSREP
YEAR_RANK NUMBER

The rank of opportunity obtained among all opportunities having decision date in this year
QUARTER_RANK NUMBER

The rank of opportunity obtained among all opportunities having decision date in this quarter
PERIOD_RANK NUMBER

The rank of opportunity obtained among all opportunities having decision date in this period
WEEK_RANK NUMBER

The rank of opportunity obtained among all opportunities having decision date in this week
PARENT_SALES_GROUP_ID NUMBER

Parent sales group or Sales group identifier who owns the opportunity. For rows with UMARKER=SLSREP both the sales group id and parent sales group id columns are same and represent the owner sales group id for the opportunity in the AS_LEADS_ALL table
SALES_GROUP_ID NUMBER

Sales group identifier who owns the opportunity
SALESREP_ID NUMBER

Salesperson or resource identifier who owns the opportunity
OPTY_ID NUMBER

Opportunity identifier. Internal reference
OPTY_NUMBER VARCHAR2 (30)
The lead number shown in the OSO UI, which is to be shown in report.
CUSTOMER_ID NUMBER

Customer for whom this opportunity was created
SALES_STAGE_ID NUMBER

The sales stage identifier
WIN_PROBABILITY NUMBER

Win probability
OPTY_CLOSE_DATE DATE

Decision date of opportunity
OPTY_STATUS VARCHAR2 (14)
One of the following statuses (WON, LOST, NO_OPPORTUNITY, OPEN)
OPTY_STATUS_CODE VARCHAR2 (30)
The status code of the opportunity as in AS_STATUSES_B
YR NUMBER

1 if the opportunity falls within this year 0 otherwise
QUARTER NUMBER

1 if the opportunity falls within this quarter 0 otherwise
PERIOD NUMBER

1 if the opportunity falls within this period 0 otherwise
WEEK NUMBER

1 if the opportunity falls within this week 0 otherwise
OPTY_AMT NUMBER

Total amount of opportunity used for ranking the opportunity in primary currency
OPTY_AMT_S NUMBER

Total amount of opportunity used for ranking the opportunity in primary currency
Query Text

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


SELECT UMARKER
,      YEAR_RANK
,      QUARTER_RANK
,      PERIOD_RANK
,      WEEK_RANK
,      PARENT_SALES_GROUP_ID
,      SALES_GROUP_ID
,      SALESREP_ID
,      OPTY_ID
,      OPTY_NUMBER
,      CUSTOMER_ID
,      SALES_STAGE_ID
,      WIN_PROBABILITY
,      OPTY_CLOSE_DATE
,      OPTY_STATUS
,      OPTY_STATUS_CODE
,      YR
,      QUARTER
,      PERIOD
,      WEEK
,      OPTY_AMT
,      OPTY_AMT_S
FROM APPS.BIL_BI_TOPOP_G_MV;

Dependencies

[top of page]

APPS.BIL_BI_TOPOP_G_MV references the following:

SchemaAPPS
Materialized ViewBIL_BI_OPDTL_MV
TableBIL_BI_OPDTL_MV
TableBIL_BI_TOPOP_G_MV
SchemaFII
TableFII_TIME_DAY
SchemaJTF
TableJTF_RS_GROUPS_DENORM
TableJTF_RS_GROUP_USAGES

APPS.BIL_BI_TOPOP_G_MV is not referenced by any database object