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

MATERIALIZED VIEW: APPS.IBE_BI_TOP_CART_MV

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

FII_TIME_DAY

[View Source Query]

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 references the following:

SchemaAPPS
PL/SQL PackageFND_PROFILE - show dependent code
TableIBE_BI_CARTS_MV
Materialized ViewIBE_BI_CARTS_MV
TableIBE_BI_TOP_CART_MV
SchemaFII
TableFII_TIME_DAY

APPS.IBE_BI_TOP_CART_MV is not referenced by any database object