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

MATERIALIZED VIEW: APPS.ASO_BI_QOT_CUST_MV

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

ASO_BI_QOT_CUSTB_MV
     ASO_BI_QOT_L1_MV
          ASO_BI_QUOTE_HDRS_ALL
          FII_TIME_DAY
     JTF_RS_GROUPS_DENORM
     JTF_RS_GROUP_USAGES

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
RANK_YR NUMBER

Rank at year level
RANK_QTR NUMBER

Rank at quarter level
RANK_PER NUMBER

Rank period level
RANK_WK NUMBER

Rank at week level
RESOURCE_GRP_ID NUMBER

Resource group id
RESOURCE_ID NUMBER

Resource id
PARTY_ID NUMBER

Party id
OPENQOT_AMNT NUMBER

Open quote amount
OPENQOT_NUMBER NUMBER

Open quote count
CONVQOT_AMNT_YEAR NUMBER

Converted quote amount YTD
CONVQOT_NUM_YEAR NUMBER

Converted quote count YTD
CONVQOT_AMNT_QTR NUMBER

Converted quote amount QTD
CONVQOT_NUM_QTR NUMBER

Converted quote count QTD
CONVQOT_AMNT_PER NUMBER

Converted quote amount PTD
CONVQOT_NUM_PER NUMBER

Converted quote count PTD
CONVQOT_AMNT_WEEK NUMBER

Converted quote amount WTD
CONVQOT_NUM_WEEK NUMBER

Converted quote count WTD
Query Text

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


SELECT RANK_YR
,      RANK_QTR
,      RANK_PER
,      RANK_WK
,      RESOURCE_GRP_ID
,      RESOURCE_ID
,      PARTY_ID
,      OPENQOT_AMNT
,      OPENQOT_NUMBER
,      CONVQOT_AMNT_YEAR
,      CONVQOT_NUM_YEAR
,      CONVQOT_AMNT_QTR
,      CONVQOT_NUM_QTR
,      CONVQOT_AMNT_PER
,      CONVQOT_NUM_PER
,      CONVQOT_AMNT_WEEK
,      CONVQOT_NUM_WEEK
FROM APPS.ASO_BI_QOT_CUST_MV;

Dependencies

[top of page]

APPS.ASO_BI_QOT_CUST_MV references the following:

SchemaAPPS
TableASO_BI_QOT_CUSTB_MV
Materialized ViewASO_BI_QOT_CUSTB_MV
TableASO_BI_QOT_CUST_MV
SynonymFII_TIME_RPT_STRUCT
ViewFII_TIME_RPT_STRUCT_V
SchemaFII
TableFII_TIME_RPT_STRUCT

APPS.ASO_BI_QOT_CUST_MV is not referenced by any database object