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

TABLE: APPS.ENI_DBI_PRC_UNION_MV

Object Details
Object Name: ENI_DBI_PRC_UNION_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableENI.ENI_DBI_PRC_UNION_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
TIME_ID NUMBER

Time id
INVENTORY_ITEM_ID NUMBER

Inventory Item id
PRODUCT_CATEGORY_ID NUMBER

Product Category id
ORGANIZATION_ID NUMBER

Organization id
ITEM_ORG_ID VARCHAR2 (81)
Item-org id
REV_PRIM_ACTUAL_G NUMBER

Revenue for item-org in Primary Currency
CNT_REV_PRIM_ACTUAL_G NUMBER

Dummy column to make materialized view fast refreshable
REV_SEC_ACTUAL_G NUMBER

Revenue for item-org in Secondary Currency
CNT_REV_SEC_ACTUAL_G NUMBER

Dummy column to make materialized view fast refreshable
PRIM_ACTUAL_G NUMBER

Other Expenses for item-org in Primary Currency
CNT_PRIM_ACTUAL_G NUMBER

Dummy column to make materialized view fast refreshable
SEC_ACTUAL_G NUMBER

Other Expenses for item-org in Secondary Currency
CNT_SEC_ACTUAL_G NUMBER

Dummy column to make materialized view fast refreshable
COGS_VALUE_G NUMBER

Cost Of Goods Sold for item-org in Primary Currency
CNT_COGS_VALUE_G NUMBER

Dummy column to make materialized view fast refreshable
COGS_VALUE_SG NUMBER

Cost Of Goods Sold for item-org in Secondary Currency
CNT_COGS_VALUE_SG NUMBER

Dummy column to make materialized view fast refreshable
INV_TOTAL_VALUE_G NUMBER

Total Inventory Value on Hand
CNT_TOTAL_VALUE_G NUMBER

Dummy column to make materialized view fast refreshable
COUNT(*) NUMBER

Dummy column to make materialized view fast refreshable
MARKER NUMBER

Used to distinguish between different summarizations
Query Text

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


SELECT TIME_ID
,      INVENTORY_ITEM_ID
,      PRODUCT_CATEGORY_ID
,      ORGANIZATION_ID
,      ITEM_ORG_ID
,      REV_PRIM_ACTUAL_G
,      CNT_REV_PRIM_ACTUAL_G
,      REV_SEC_ACTUAL_G
,      CNT_REV_SEC_ACTUAL_G
,      PRIM_ACTUAL_G
,      CNT_PRIM_ACTUAL_G
,      SEC_ACTUAL_G
,      CNT_SEC_ACTUAL_G
,      COGS_VALUE_G
,      CNT_COGS_VALUE_G
,      COGS_VALUE_SG
,      CNT_COGS_VALUE_SG
,      INV_TOTAL_VALUE_G
,      CNT_TOTAL_VALUE_G
,      COUNT(*)
,      MARKER
FROM APPS.ENI_DBI_PRC_UNION_MV;

Dependencies

[top of page]

APPS.ENI_DBI_PRC_UNION_MV does not reference any database object

APPS.ENI_DBI_PRC_UNION_MV is referenced by following:

SchemaAPPS
Materialized ViewENI_DBI_PRC_SUM1_MV
Materialized ViewENI_DBI_PRC_UNION_MV