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

MATERIALIZED VIEW: APPS.ASO_BI_QLIN_L1_MV

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

ASO_BI_QUOTE_LINES_ALL
ENI_OLTP_ITEM_STAR

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
QROWID ROWID (10)
For fast refreshability purpose
SROWID ROWID (10)
For fast refreshability purpose
RESOURCE_ID NUMBER

Resoucre id
RESOURCE_GRP_ID NUMBER

Resource group id
LINE_AMOUNT NUMBER

Line amount after proper currency conversion in Primary Currency
SEC_LINE_AMOUNT NUMBER

Line amount after proper currency conversion in Secondary Currency
CATEGORY_ID NUMBER

Product category id
MASTER_ID VARCHAR2 (25)
Inventory item id
QUOTE_CREATION_DATE DATE

Quote creation date
ORDER_CREATION_DATE DATE

Order creation date
QUOTE_EXPIRATION_DATE DATE

Quote expiration date
ORDER_ID NUMBER

Order Id
Query Text

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


SELECT QROWID
,      SROWID
,      RESOURCE_ID
,      RESOURCE_GRP_ID
,      LINE_AMOUNT
,      SEC_LINE_AMOUNT
,      CATEGORY_ID
,      MASTER_ID
,      QUOTE_CREATION_DATE
,      ORDER_CREATION_DATE
,      QUOTE_EXPIRATION_DATE
,      ORDER_ID
FROM APPS.ASO_BI_QLIN_L1_MV;

Dependencies

[top of page]

APPS.ASO_BI_QLIN_L1_MV references the following:

SchemaAPPS
TableASO_BI_QLIN_L1_MV
SchemaASO
TableASO_BI_QUOTE_LINES_ALL
SchemaENI
TableENI_OLTP_ITEM_STAR
APPS.ASO_BI_QLIN_L1_MV is referenced by following:

SchemaAPPS
Materialized ViewASO_BI_QLIN_L2_MV