[Home] [Help] [Dependency Information]
Object Name: | IBE_BI_TOP_CART_MV |
---|---|
Object Type: | TABLE |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IBE_BI_TOP_CART_MV_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
TIME_ID
PERIOD_TYPE_ID MINISITE_ID |
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 |
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;
APPS.IBE_BI_TOP_CART_MV does not reference any database object
APPS.IBE_BI_TOP_CART_MV is referenced by following:
|
|
|