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

TABLE: APPS.IBE_BI_TOP_CART_MV

Object Details
Object Name: IBE_BI_TOP_CART_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
IBE_BI_TOP_CART_MV_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTIME_ID
ColumnPERIOD_TYPE_ID
ColumnMINISITE_ID
Columns
Name Datatype Length Mandatory Comments
CARTNUMBER NUMBER

Quote number
CUSTOMER NUMBER

Party identifier
MINISITE_ID NUMBER

Mini Site Identifier for iStore
CURRENCY_CD_F VARCHAR2 (15)
Currency code
BOOKED_AMT_F NUMBER

Total Cart Amount based on functional currency code
BOOKED_AMT_G NUMBER

Total Cart Amount based on primary global currency code
BOOKED_AMT_G1 NUMBER

Total Cart Amount based on secondary global currency code
LINES NUMBER

Number of lines in this cart
QUOTE_EXPIRATION_DATE DATE

Expiration date of the quote
CREATION_DATE DATE

Standard who column - date when this row was created.
RESOURCE_FLAG VARCHAR2 (1)
Flag to identify whether this is an assisted Cart, Y - Assisted, N - Unassisted
TIME_ID NUMBER

Time Identifier (Foreign key to join to the Time Dimension Views)
PERIOD_TYPE_ID NUMBER

Period Type Identifier
RANK NUMBER

Rank of this cart in terms of total cart amount
Query Text

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


SELECT CARTNUMBER
,      CUSTOMER
,      MINISITE_ID
,      CURRENCY_CD_F
,      BOOKED_AMT_F
,      BOOKED_AMT_G
,      BOOKED_AMT_G1
,      LINES
,      QUOTE_EXPIRATION_DATE
,      CREATION_DATE
,      RESOURCE_FLAG
,      TIME_ID
,      PERIOD_TYPE_ID
,      RANK
FROM APPS.IBE_BI_TOP_CART_MV;

Dependencies

[top of page]

APPS.IBE_BI_TOP_CART_MV does not reference any database object

APPS.IBE_BI_TOP_CART_MV is referenced by following:

SchemaAPPS
Materialized ViewIBE_BI_TOP_CART_MV