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

TABLE: APPS.IBE_BI_TOP_CUST_MV

Object Details
Object Name: IBE_BI_TOP_CUST_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
I_SNAP$_IBE_BI_TOP_CUST_MV FUNCTION-BASED NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnSYS_OP_MAP_NONNULL("CUSTOMER_ID")
ColumnSYS_OP_MAP_NONNULL("MINISITE_ID")
ColumnSYS_OP_MAP_NONNULL("CURRENCY_CD_F")
ColumnSYS_OP_MAP_NONNULL("ENT_YEAR_ID")
ColumnSYS_OP_MAP_NONNULL("ENT_QTR_ID")
ColumnSYS_OP_MAP_NONNULL("ENT_PERIOD_ID")
ColumnSYS_OP_MAP_NONNULL("WEEK_ID")
ColumnSYS_OP_MAP_NONNULL("REPORT_DATE_JULIAN")
ColumnSYS_OP_MAP_NONNULL("D_GID")
IBE_BI_TOP_CUST_MV_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTIME_ID
ColumnPERIOD_TYPE_ID
ColumnMINISITE_ID
Columns
Name Datatype Length Mandatory Comments
CUSTOMER_ID NUMBER

Party identifier
MINISITE_ID NUMBER

Mini Site Identifier for iStore
CURRENCY_CD_F VARCHAR2 (30)
Currency code
TIME_ID NUMBER

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

Period Type Identifier
AMOUNT_G NUMBER

Booked Order Amount based on primary global currency code
AMOUNT_G1 NUMBER

Booked Order Amount based on secondary global currency code
AMOUNT_F NUMBER

Booked Order Amount based on functional currency code
ASSISTED_AMT_G NUMBER

Assisted order amount based on primary global currency code
ASSISTED_AMT_G1 NUMBER

Assisted order amount based on secondary global currency code
ASSISTED_AMT_F NUMBER

Assisted order amount based on functional currency code
LIST_AMOUNT_G NUMBER

List Price based on primary global currency code
LIST_AMOUNT_G1 NUMBER

List Price based on secondary global currency code
LIST_AMOUNT_F NUMBER

List Price based on functional currency code
DISC_AMOUNT_G NUMBER

Discount amount based on primary global currency code
DISC_AMOUNT_G1 NUMBER

Discount amount based on secondary global currency code
DISC_AMOUNT_F NUMBER

Discount amount based on functional currency code
ORDERS_CNT NUMBER

Number of Booked Orders for this customer
D_AMOUNT_G_CNT NUMBER

Count column for materialized view refresh functionality (Not Used Otherwise)
D_AMOUNT_G1_CNT NUMBER

Count column for materialized view refresh functionality (Not Used Otherwise)
D_AMOUNT_F_CNT NUMBER

Count column for materialized view refresh functionality (Not Used Otherwise)
D_ASSISTED_AMT_G_CNT NUMBER

Count column for materialized view refresh functionality (Not Used Otherwise)
D_ASSISTED_AMT_G1_CNT NUMBER

Count column for materialized view refresh functionality (Not Used Otherwise)
D_ASSISTED_AMT_F_CNT NUMBER

Count column for materialized view refresh functionality (Not Used Otherwise)
LIST_AMOUNT_G_CNT NUMBER

Count column for materialized view refresh functionality (Not Used Otherwise)
LIST_AMOUNT_G1_CNT NUMBER

Count column for materialized view refresh functionality (Not Used Otherwise)
LIST_AMOUNT_F_CNT NUMBER

Count column for materialized view refresh functionality (Not Used Otherwise)
DISC_AMOUNT_G_CNT NUMBER

Count column for materialized view refresh functionality (Not Used Otherwise)
DISC_AMOUNT_G1_CNT NUMBER

Count column for materialized view refresh functionality (Not Used Otherwise)
DISC_AMOUNT_F_CNT NUMBER

Count column for materialized view refresh functionality (Not Used Otherwise)
ENT_YEAR_ID NUMBER

Foreign Key for Enterprise Year
ENT_QTR_ID NUMBER

Foreign Key for Enterprise Quarter
ENT_PERIOD_ID NUMBER

Foreign Key for Enterprise Period
WEEK_ID NUMBER

Foreign Key for Week
REPORT_DATE_JULIAN NUMBER

Report as-of-date (Julian Day)
D_GID NUMBER

Grouping Id for rollups (Internally Used Column)
D_TOTAL_CNT NUMBER

Count for materialized view refresh functionality (Not Used Otherwise)
Query Text

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


SELECT CUSTOMER_ID
,      MINISITE_ID
,      CURRENCY_CD_F
,      TIME_ID
,      PERIOD_TYPE_ID
,      AMOUNT_G
,      AMOUNT_G1
,      AMOUNT_F
,      ASSISTED_AMT_G
,      ASSISTED_AMT_G1
,      ASSISTED_AMT_F
,      LIST_AMOUNT_G
,      LIST_AMOUNT_G1
,      LIST_AMOUNT_F
,      DISC_AMOUNT_G
,      DISC_AMOUNT_G1
,      DISC_AMOUNT_F
,      ORDERS_CNT
,      D_AMOUNT_G_CNT
,      D_AMOUNT_G1_CNT
,      D_AMOUNT_F_CNT
,      D_ASSISTED_AMT_G_CNT
,      D_ASSISTED_AMT_G1_CNT
,      D_ASSISTED_AMT_F_CNT
,      LIST_AMOUNT_G_CNT
,      LIST_AMOUNT_G1_CNT
,      LIST_AMOUNT_F_CNT
,      DISC_AMOUNT_G_CNT
,      DISC_AMOUNT_G1_CNT
,      DISC_AMOUNT_F_CNT
,      ENT_YEAR_ID
,      ENT_QTR_ID
,      ENT_PERIOD_ID
,      WEEK_ID
,      REPORT_DATE_JULIAN
,      D_GID
,      D_TOTAL_CNT
FROM APPS.IBE_BI_TOP_CUST_MV;

Dependencies

[top of page]

APPS.IBE_BI_TOP_CUST_MV does not reference any database object

APPS.IBE_BI_TOP_CUST_MV is referenced by following:

SchemaAPPS
Materialized ViewIBE_BI_TOP_CUST_MV