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

MATERIALIZED VIEW: APPS.IBE_BI_TOP_ORD_MV

Object Details
Object Name: IBE_BI_TOP_ORD_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: IBE_BI_TOP_ORD_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
TIME_ID NUMBER

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

Period Type Identifier
ORDERNUMBER NUMBER

User-visible number of the order
CUSTOMERID NUMBER

Party identifier
SOURCE VARCHAR2 (1)
Quote Publish flag, Y - Published Quote, N - Unpublised Quote
CURRENCY_CD_F VARCHAR2 (30)
Currency code
BOOKED_AMT_G NUMBER

Booked Order amount based on primary global currency code
BOOKED_AMT_G1 NUMBER

Booked Order amount based on secondary global currency code
BOOKED_AMT_F NUMBER

Booked Order amount based on functional currency code
DISCOUNT_G NUMBER

Discount amount based on primary global currency code
DISCOUNT_G1 NUMBER

Discount amount based on secondary global currency code
DISCOUNT_F NUMBER

Discount amount based on functional currency code
LINES NUMBER

Number of lines
ASSISTED VARCHAR2 (1)
Flag to identify whether this is an assisted Order, Y - Assisted, N - Unassisted
MINISITE_ID NUMBER

Mini Site Identifier for iStore
RANK NUMBER

Rank of this Order in terms of total Booked Order amount
Query Text

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


SELECT TIME_ID
,      PERIOD_TYPE_ID
,      ORDERNUMBER
,      CUSTOMERID
,      SOURCE
,      CURRENCY_CD_F
,      BOOKED_AMT_G
,      BOOKED_AMT_G1
,      BOOKED_AMT_F
,      DISCOUNT_G
,      DISCOUNT_G1
,      DISCOUNT_F
,      LINES
,      ASSISTED
,      MINISITE_ID
,      RANK
FROM APPS.IBE_BI_TOP_ORD_MV;

Dependencies

[top of page]

APPS.IBE_BI_TOP_ORD_MV references the following:

SchemaAPPS
PL/SQL PackageFND_PROFILE - show dependent code
TableIBE_BI_ORDERS_MV
Materialized ViewIBE_BI_ORDERS_MV
TableIBE_BI_TOP_ORD_MV
SchemaFII
TableFII_TIME_DAY

APPS.IBE_BI_TOP_ORD_MV is not referenced by any database object