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

MATERIALIZED VIEW: APPS.ASO_BI_QLIN_PC_MV

Object Details
Object Name: ASO_BI_QLIN_PC_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: ASO_BI_QLIN_PC_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:

ASO_BI_QLIN_L2_MV
     ASO_BI_QLIN_L1_MV
          ASO_BI_QUOTE_LINES_ALL
          ENI_OLTP_ITEM_STAR
     FII_TIME_DAY
ENI_DENORM_HIERARCHIES
JTF_RS_GROUPS_DENORM
JTF_RS_GROUP_USAGES
MTL_DEFAULT_CATEGORY_SETS

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
UMARKER CHAR (2)
Marker for fast refreshability purpose
TOP_NODE_FLAG VARCHAR2 (1)
Used to indicate whether the category is a top level category
CATEGORY_FLAG CHAR (1)
Used to indicate category roll up
RESOURCE_GRP_ID NUMBER

Resource group id
RESOURCE_ID NUMBER

Resource id
RESOURCE_GRP_FLAG VARCHAR2 (1)
Used to indicate group roll up
CATEGORY_ID NUMBER

Product category id
MASTER_ID VARCHAR2 (25)
Inventory item id
NEWQOT_AMNT NUMBER

New quote amount in Primary Currency
SEC_NEWQOT_AMNT NUMBER

New quote amount in Secondary Currency
NEWQOT_NUMBER NUMBER

New quote count
OPENQOT_AMNT NUMBER

Open quote amount in Primary Currency
SEC_OPENQOT_AMNT NUMBER

Open quote amount in Secondary Currency
OPENQOT_NUMBER NUMBER

Open quote count
CONVQOT_AMNT NUMBER

Converted quote amount in Primary Currency
SEC_CONVQOT_AMNT NUMBER

Converted quote amount in Secondary Currency
CONVQOT_NUMBER NUMBER

Converted quote number
NEWQOT_AMNT_CNT NUMBER

For fast refreshability purpose
SEC_NEWQOT_AMNT_CNT NUMBER

For fast refreshability purpose
NEWQOT_NUMBER_CNT NUMBER

For fast refreshability purpose
OPENQOT_AMNT_CNT NUMBER

For fast refreshability purpose
SEC_OPENQOT_AMNT_CNT NUMBER

For fast refreshability purpose
OPENQOT_NUMBER_CNT NUMBER

For fast refreshability purpose
CONVQOT_AMNT_CNT NUMBER

For fast refreshability purpose
SEC_CONVQOT_AMNT_CNT NUMBER

For fast refreshability purpose
CONVQOT_NUMBER_CNT NUMBER

For fast refreshability purpose
ALL_CNT NUMBER

For fast refreshability purpose
ENT_YEAR_ID NUMBER

Year id
ENT_QTR_ID NUMBER

Quarter id
ENT_PERIOD_ID NUMBER

Period id
WEEK_ID NUMBER

Week id
DAY_ID NUMBER

Day id
PERIOD_TYPE_ID NUMBER

Period type id
TIME_ID NUMBER

Time id
GRP_ID NUMBER

For fast refreshability purpose
Query Text

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


SELECT UMARKER
,      TOP_NODE_FLAG
,      CATEGORY_FLAG
,      RESOURCE_GRP_ID
,      RESOURCE_ID
,      RESOURCE_GRP_FLAG
,      CATEGORY_ID
,      MASTER_ID
,      NEWQOT_AMNT
,      SEC_NEWQOT_AMNT
,      NEWQOT_NUMBER
,      OPENQOT_AMNT
,      SEC_OPENQOT_AMNT
,      OPENQOT_NUMBER
,      CONVQOT_AMNT
,      SEC_CONVQOT_AMNT
,      CONVQOT_NUMBER
,      NEWQOT_AMNT_CNT
,      SEC_NEWQOT_AMNT_CNT
,      NEWQOT_NUMBER_CNT
,      OPENQOT_AMNT_CNT
,      SEC_OPENQOT_AMNT_CNT
,      OPENQOT_NUMBER_CNT
,      CONVQOT_AMNT_CNT
,      SEC_CONVQOT_AMNT_CNT
,      CONVQOT_NUMBER_CNT
,      ALL_CNT
,      ENT_YEAR_ID
,      ENT_QTR_ID
,      ENT_PERIOD_ID
,      WEEK_ID
,      DAY_ID
,      PERIOD_TYPE_ID
,      TIME_ID
,      GRP_ID
FROM APPS.ASO_BI_QLIN_PC_MV;

Dependencies

[top of page]

APPS.ASO_BI_QLIN_PC_MV references the following:

SchemaAPPS
Materialized ViewASO_BI_QLIN_L2_MV
TableASO_BI_QLIN_L2_MV
TableASO_BI_QLIN_PC_MV
SchemaENI
TableENI_DENORM_HIERARCHIES
SchemaINV
TableMTL_DEFAULT_CATEGORY_SETS
SchemaJTF
TableJTF_RS_GROUPS_DENORM
TableJTF_RS_GROUP_USAGES

APPS.ASO_BI_QLIN_PC_MV is not referenced by any database object