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

TABLE: APPS.ENI_DBI_COGS_BASE_MV

Object Details
Object Name: ENI_DBI_COGS_BASE_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableENI.ENI_DBI_COGS_BASE_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
I_SNAP$_ENI_DBI_COGS_BASE_ FUNCTION-BASED NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnSYS_OP_MAP_NONNULL("INVENTORY_ITEM_ID")
ColumnSYS_OP_MAP_NONNULL("ORGANIZATION_ID")
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("GID")
Columns
Name Datatype Length Mandatory Comments
TIME_ID NUMBER

Time id
REPORT_DATE_JULIAN NUMBER

Report Date
ENT_QTR_ID NUMBER

Quarter id
ENT_PERIOD_ID NUMBER

Period id
WEEK_ID NUMBER

Week id
ENT_YEAR_ID NUMBER

Year id
INVENTORY_ITEM_ID NUMBER

Inventory Item id
ORGANIZATION_ID NUMBER

Organization id
COGS_VAL_G NUMBER

Cost of Goods Sold in Primary Currency
C_COGS_VAL_G NUMBER

Dummy column to make materialized view fast refreshable
COGS_VAL_SG NUMBER

Cost of Goods Sold in Secondary Currency
C_COGS_VAL_SG NUMBER

Dummy column to make materialized view fast refreshable
GID NUMBER

group id
COUNT(*) NUMBER

Query Text

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


SELECT TIME_ID
,      REPORT_DATE_JULIAN
,      ENT_QTR_ID
,      ENT_PERIOD_ID
,      WEEK_ID
,      ENT_YEAR_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      COGS_VAL_G
,      C_COGS_VAL_G
,      COGS_VAL_SG
,      C_COGS_VAL_SG
,      GID
,      COUNT(*)
FROM APPS.ENI_DBI_COGS_BASE_MV;

Dependencies

[top of page]

APPS.ENI_DBI_COGS_BASE_MV does not reference any database object

APPS.ENI_DBI_COGS_BASE_MV is referenced by following:

SchemaAPPS
Materialized ViewENI_DBI_COGS_BASE_MV
Materialized ViewENI_DBI_PRC_UNION_MV