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_COMP_SCR_MV

Object Details

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

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
ROW_ID	ROWID	(10)	Materialized View Row Identifier
ORGANIZATION_ID	NUMBER		Inventory Organization Identifier
INVENTORY_ITEM_ID	NUMBER		Item Identifier
TRANSACTION_DATE	DATE		Transaction Date
JOB_ID	NUMBER		Job Identifier
JOB_TYPE	NUMBER		Job Type
SOURCE	NUMBER		Data source. 1 = OPI, 2 = OPM
COMPLETION_QUANTITY	NUMBER		WIP Completion Quantity in primary unit of measure
COMPLETION_VALUE_B	NUMBER		Value of WIP Completion in Functional Currency
COMPLETION_VALUE_G	NUMBER		Value of WIP Completion in Primary Global Currency
COMPLETION_VALUE_SG	NUMBER		Value of WIP Completion in Secondary Global Currency
SCRAP_QUANTITY	NUMBER		Scrap Quantity in primary unit of measure
SCRAP_QUANTITY_CNT	NUMBER		Count Column
SCRAP_VALUE_B	NUMBER		Value of Scrap in Functional Currency
SCRAP_VALUE_B_CNT	NUMBER		Count Column
SCRAP_VALUE_G	NUMBER		Value of Scrap in Primary Global Currency
SCRAP_VALUE_G_CNT	NUMBER		Count Column
SCRAP_VALUE_SG	NUMBER		Value of Scrap in Secondary Global Currency
SCRAP_VALUE_SG_CNT	NUMBER		Count Column
UOM_CODE	VARCHAR2	(3)	Primary unit of measure
MARKER	NUMBER		Materialized view marker
CNT	NUMBER		Count Column

Query Text

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


SELECT ROW_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      TRANSACTION_DATE
,      JOB_ID
,      JOB_TYPE
,      SOURCE
,      COMPLETION_QUANTITY
,      COMPLETION_VALUE_B
,      COMPLETION_VALUE_G
,      COMPLETION_VALUE_SG
,      SCRAP_QUANTITY
,      SCRAP_QUANTITY_CNT
,      SCRAP_VALUE_B
,      SCRAP_VALUE_B_CNT
,      SCRAP_VALUE_G
,      SCRAP_VALUE_G_CNT
,      SCRAP_VALUE_SG
,      SCRAP_VALUE_SG_CNT
,      UOM_CODE
,      MARKER
,      CNT
FROM APPS.OPI_COMP_SCR_MV;

Dependencies

[top of page]

APPS.OPI_COMP_SCR_MV does not reference any database object

APPS.OPI_COMP_SCR_MV is referenced by following:

APPS: OPI_COMP_SCR_MV; OPI_PROD_SCR_MV