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

TABLE: APPS.ASO_BI_TOP_QOTB_MV

Object Details
Object Name: ASO_BI_TOP_QOTB_MV
Object Type: TABLE
Owner: APPS
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
QUOTE_NAME VARCHAR2 (240)
Quote Name
QUOTE_NUMBER NUMBER

Quote Number
PARTY_ID NUMBER

Party Id
QUOTE_CREATION_DATE DATE

Quote Creation date
QUOTE_EXPIRATION_DATE DATE

Quote Expiration date
ORDER_CREATION_DATE DATE

Order Creation date
QUOTE_AGE NUMBER

Quote Age in terms of days
RESOURCE_GRP_ID NUMBER

Resource Group id
RESOURCE_ID NUMBER

Resource id
NUM_APPROVERS NUMBER

Number Of Approvers
QUOTE_AMNT NUMBER

Last Version Quote Amount in terms of Primary Currency
QUOTE_AMOUNT_FIRST NUMBER

First Version Quote Amount in terms of Primary Currency
STATUS VARCHAR2 (4)
Status
EFFECTIVE_DATE DATE

Effective Date
CONVERSION_RATE NUMBER

Primary Conversion Rate
SEC_CONVERSION_RATE NUMBER

Secondary Conversion Rate
YEAR NUMBER

Period Type Year
QUARTER NUMBER

Period Type Quarter
PERIOD NUMBER

Period Type Month
WEEK NUMBER

Period Type Week
Query Text

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


SELECT QUOTE_NAME
,      QUOTE_NUMBER
,      PARTY_ID
,      QUOTE_CREATION_DATE
,      QUOTE_EXPIRATION_DATE
,      ORDER_CREATION_DATE
,      QUOTE_AGE
,      RESOURCE_GRP_ID
,      RESOURCE_ID
,      NUM_APPROVERS
,      QUOTE_AMNT
,      QUOTE_AMOUNT_FIRST
,      STATUS
,      EFFECTIVE_DATE
,      CONVERSION_RATE
,      SEC_CONVERSION_RATE
,      YEAR
,      QUARTER
,      PERIOD
,      WEEK
FROM APPS.ASO_BI_TOP_QOTB_MV;

Dependencies

[top of page]

APPS.ASO_BI_TOP_QOTB_MV does not reference any database object

APPS.ASO_BI_TOP_QOTB_MV is referenced by following:

SchemaAPPS
Materialized ViewASO_BI_TOP_QOTB_MV
Materialized ViewASO_BI_TOP_QOT_MV