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

TABLE: APPS.OPI_ONTIME_PROD_001_MV

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

Inventory Organization Identifier.
SOURCE NUMBER

Data source. 1 = OPI,2 = OPM.
INVENTORY_ITEM_ID NUMBER

Inventory Item Identifier.
UOM_CODE VARCHAR2 (3)
Primary UOM Code.
ITEM_ORG_ID VARCHAR2 (81)
Inventory Item Organization Identifier.
INV_CATEGORY_ID NUMBER

Inventory Category Identifier.
GROUPING_ID NUMBER

Grouping ID column.
ITEM_CAT_FLAG NUMBER

Item Category Flag.
TIME_ID NUMBER

Nested Grouping ID column for Time.
PERIOD_TYPE_ID NUMBER

Period type Identifier column for time.
ENT_QTR_ID NUMBER

Enterprise Quarter Identifier.
ENT_PERIOD_ID NUMBER

Enterprise Period Identifier.
WEEK_ID NUMBER

FII Week Identifier.
REPORT_DATE_JULIAN NUMBER

FII Day Identifier.
LATE_PROD_CNT NUMBER

Count column.
LATE_PROD_QTY NUMBER

Late Produced quantity
LATE_PROD_QTY_CNT NUMBER

Count column.
LATE_PROD_VAL_B NUMBER

Late Produced value in functional currency
LATE_PROD_VAL_B_CNT NUMBER

Count column.
LATE_PROD_VAL_G NUMBER

Late Produced value in primary global currency
LATE_PROD_VAL_G_CNT NUMBER

Count column.
LATE_PROD_VAL_SG NUMBER

Late Produced value in secondary global currency
LATE_PROD_VAL_SG_CNT NUMBER

Count column.
ONTIME_PROD_CNT NUMBER

Count column.
ONTIME_PROD_QTY NUMBER

Ontime Production quantity
ONTIME_PROD_QTY_CNT NUMBER

Count column.
ONTIME_PROD_VAL_B NUMBER

Ontime Production value in functional currency
ONTIME_PROD_VAL_B_CNT NUMBER

Count column.
ONTIME_PROD_VAL_G NUMBER

Ontime Production value in primary global currency
ONTIME_PROD_VAL_G_CNT NUMBER

Count column.
ONTIME_PROD_VAL_SG NUMBER

Ontime Production value in secondary global currency
ONTIME_PROD_VAL_SG_CNT NUMBER

Count column.
LINES_CNT NUMBER

Row count
Query Text

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


SELECT ORGANIZATION_ID
,      SOURCE
,      INVENTORY_ITEM_ID
,      UOM_CODE
,      ITEM_ORG_ID
,      INV_CATEGORY_ID
,      GROUPING_ID
,      ITEM_CAT_FLAG
,      TIME_ID
,      PERIOD_TYPE_ID
,      ENT_QTR_ID
,      ENT_PERIOD_ID
,      WEEK_ID
,      REPORT_DATE_JULIAN
,      LATE_PROD_CNT
,      LATE_PROD_QTY
,      LATE_PROD_QTY_CNT
,      LATE_PROD_VAL_B
,      LATE_PROD_VAL_B_CNT
,      LATE_PROD_VAL_G
,      LATE_PROD_VAL_G_CNT
,      LATE_PROD_VAL_SG
,      LATE_PROD_VAL_SG_CNT
,      ONTIME_PROD_CNT
,      ONTIME_PROD_QTY
,      ONTIME_PROD_QTY_CNT
,      ONTIME_PROD_VAL_B
,      ONTIME_PROD_VAL_B_CNT
,      ONTIME_PROD_VAL_G
,      ONTIME_PROD_VAL_G_CNT
,      ONTIME_PROD_VAL_SG
,      ONTIME_PROD_VAL_SG_CNT
,      LINES_CNT
FROM APPS.OPI_ONTIME_PROD_001_MV;

Dependencies

[top of page]

APPS.OPI_ONTIME_PROD_001_MV does not reference any database object

APPS.OPI_ONTIME_PROD_001_MV is referenced by following:

SchemaAPPS
Materialized ViewOPI_ONTIME_PROD_001_MV