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

TABLE: APPS.ASO_BI_QOT_CUST_MV

Object Details
Object Name: ASO_BI_QOT_CUST_MV
Object Type: TABLE
Owner: APPS
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ASO_BI_QOT_CUST_MV_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnRESOURCE_GRP_ID
ColumnRESOURCE_ID
ColumnPARTY_ID
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 does not reference any database object

APPS.ASO_BI_QOT_CUST_MV is referenced by following:

SchemaAPPS
Materialized ViewASO_BI_QOT_CUST_MV