eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: APPS.OPI_MFG_VAR_SUM_MV

Object Details

Object Name:	OPI_MFG_VAR_SUM_MV
Object Type:	TABLE
Owner:	APPS
FND Design Data:	FND.OPI_MFG_VAR_SUM_MV
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
I_SNAP$_OPI_MFG_VAR_SUM_MV	FUNCTION-BASED NORMAL	UNIQUE	APPS_TS_SUMMARY	SYS_OP_MAP_NONNULL("ORGANIZATION_ID") SYS_OP_MAP_NONNULL("SOURCE") SYS_OP_MAP_NONNULL("INV_CATEGORY_ID") SYS_OP_MAP_NONNULL("ASSEMBLY_ITEM_ID") SYS_OP_MAP_NONNULL("UOM_CODE") SYS_OP_MAP_NONNULL("QTR_ID") SYS_OP_MAP_NONNULL("MONTH_ID") SYS_OP_MAP_NONNULL("WEEK_ID") SYS_OP_MAP_NONNULL("DAY_ID") SYS_OP_MAP_NONNULL("GROUPING_ID") SYS_OP_MAP_NONNULL("ITEM_CAT_FLAG")
OPI_MFG_VAR_SUM_MV_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	TIME_ID ITEM_CAT_FLAG ORGANIZATION_ID
OPI_MFG_VAR_SUM_MV_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	TIME_ID ITEM_CAT_FLAG INV_CATEGORY_ID
OPI_MFG_VAR_SUM_MV_N3	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	TIME_ID ITEM_CAT_FLAG ITEM_ORG_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ORGANIZATION_ID	NUMBER			Manufacturing Organization Identifier
ASSEMBLY_ITEM_ID	NUMBER			Assembly Inventory Item Identifier
ITEM_ORG_ID	VARCHAR2	(81)		Item Organization Identifier
UOM_CODE	VARCHAR2	(3)		Primary unit of measure
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 ID Column for Time
QTR_ID	NUMBER			Enterprise Quarter Identifier
MONTH_ID	NUMBER			FII Month Identifier
WEEK_ID	NUMBER			FII Week Identifier
DAY_ID	NUMBER			FII Day Identifier
SOURCE	NUMBER		Yes	Data source. 1 = OPI, 2 = OPM
STD_VALUE_B	NUMBER			Standard Cost of all quantity produced in Functional Currency
STD_VALUE_B_CNT	NUMBER			Count Columns
STD_VALUE_G	NUMBER			Standard Cost of all quantity produced in Primary Global Currency
STD_VALUE_G_CNT	NUMBER			Count Columns
ACT_VALUE_B	NUMBER			Actual Cost of all quantity produced in Functional Currency
ACT_VALUE_B_CNT	NUMBER			Count Columns
ACT_VALUE_G	NUMBER			Actual Cost of all quantity produced in Primary Global Currency
ACT_VALUE_G_CNT	NUMBER			Count Columns
ACTUAL_QTY_COMPLETED	NUMBER			Actual Quantity of WIP Completions
ACT_QTY_COMPLETED_CNT	NUMBER			Count Columns
STD_VALUE_SG	NUMBER			Standard Cost of all quantity produced in Secondary Global Currency
STD_VALUE_SG_CNT	NUMBER			Count Columns
ACT_VALUE_SG	NUMBER			Actual Cost of all quantity produced in Secondary Global Currency
ACT_VALUE_SG_CNT	NUMBER			Count Columns
CNT	NUMBER			Row Count

Query Text

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


SELECT ORGANIZATION_ID
,      ASSEMBLY_ITEM_ID
,      ITEM_ORG_ID
,      UOM_CODE
,      INV_CATEGORY_ID
,      GROUPING_ID
,      ITEM_CAT_FLAG
,      TIME_ID
,      PERIOD_TYPE_ID
,      QTR_ID
,      MONTH_ID
,      WEEK_ID
,      DAY_ID
,      SOURCE
,      STD_VALUE_B
,      STD_VALUE_B_CNT
,      STD_VALUE_G
,      STD_VALUE_G_CNT
,      ACT_VALUE_B
,      ACT_VALUE_B_CNT
,      ACT_VALUE_G
,      ACT_VALUE_G_CNT
,      ACTUAL_QTY_COMPLETED
,      ACT_QTY_COMPLETED_CNT
,      STD_VALUE_SG
,      STD_VALUE_SG_CNT
,      ACT_VALUE_SG
,      ACT_VALUE_SG_CNT
,      CNT
FROM APPS.OPI_MFG_VAR_SUM_MV;

Dependencies

[top of page]

APPS.OPI_MFG_VAR_SUM_MV does not reference any database object

APPS.OPI_MFG_VAR_SUM_MV is referenced by following:

APPS: OPI_MFG_VAR_SUM_MV