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]

MATERIALIZED VIEW: APPS.OPI_COMP_SCR_MV

Object Details

Object Name:	OPI_COMP_SCR_MV
Object Type:	MATERIALIZED VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

M-View Details

Container:	OPI_COMP_SCR_MV
Updatable:	N
Rewrite Enabled:	N
Rewrite Capability:	TEXTMATCH
Refresh Mode:	DEMAND
Refresh Method:	FAST
Build Mode:	DEFERRED
Fast Refreshable:	DIRLOAD_DML

MV Log Dependencies:


OKI_DBI_MULTIPLEXER_B
OPI_DBI_WIP_COMP_F
OPI_DBI_WIP_SCRAP_F

[View Source Query]

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 references the following:

APPS: OPI_COMP_SCR_MV
OKI: OKI_DBI_MULTIPLEXER_B
OPI: OPI_DBI_WIP_COMP_F; OPI_DBI_WIP_SCRAP_F

APPS.OPI_COMP_SCR_MV is referenced by following:

APPS: OPI_PROD_SCR_MV