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: OPI.OPI_DBI_MFG_CST_VAR_F

Object Details

Object Name:	OPI_DBI_MFG_CST_VAR_F
Object Type:	TABLE
Owner:	OPI
Subobject Name:
Status:	VALID

Base Table for extracting Material Usage by Assembly and Component.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OPI_DBI_MFG_CST_VAR_F_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	ORGANIZATION_ID JOB_ID JOB_TYPE ASSEMBLY_ITEM_ID CLOSED_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
ORGANIZATION_ID	NUMBER			Organization ID in which the job is created.
JOB_ID	NUMBER		Yes	Discrete and Flow: WIP_Entity_Id. Repetitive Schedule: Repetitive_Schedule_Id (i.e. WIP Job Identifier).
JOB_TYPE	NUMBER		Yes	Discrete, Repetitive Schedule, Flow Schedule, Process.
ASSEMBLY_ITEM_ID	NUMBER			Assembly Inventory Item Id.
CLOSED_DATE	DATE		Yes	Date the job was closed.
STANDARD_VALUE_B	NUMBER			Standard Cost of all quantity produced from all closed jobs in functional currency.
ACTUAL_VALUE_B	NUMBER			Total Cost charged to all closed jobs.
ACTUAL_QTY_COMPLETED	NUMBER			Actual Quantity Completed.
UOM_CODE	VARCHAR2	(3)		Primary Unit of Measure of the assembly.
CONVERSION_RATE	NUMBER			Conversion rate from functional to global currency.
SOURCE	NUMBER		Yes	Source: 1 if OPI or 2 if OPM.
CREATION_DATE	DATE		Yes	Creation Date.
LAST_UPDATE_DATE	DATE		Yes	Last Update Date.
CREATED_BY	NUMBER		Yes	Standard WHO column.
LAST_UPDATED_BY	NUMBER		Yes	Standard WHO column.
LAST_UPDATE_LOGIN	NUMBER			Standard WHO column.
SEC_CONVERSION_RATE	NUMBER			Conversion rate of secondary curency
STANDARD_VALUE_G	NUMBER			Standard Value in Global Currency
ACTUAL_VALUE_G	NUMBER			Actual Value in Global Currency
STANDARD_VALUE_SG	NUMBER			Standard Value in Secondary Global Currency
ACTUAL_VALUE_SG	NUMBER			Actual Value in Secondary Global Currency
PROGRAM_ID	NUMBER			Who Column.
PROGRAM_LOGIN_ID	NUMBER			Who Column.
PROGRAM_APPLICATION_ID	NUMBER			Who Column.
REQUEST_ID	NUMBER			Who Column.

Query Text

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


SELECT ORGANIZATION_ID
,      JOB_ID
,      JOB_TYPE
,      ASSEMBLY_ITEM_ID
,      CLOSED_DATE
,      STANDARD_VALUE_B
,      ACTUAL_VALUE_B
,      ACTUAL_QTY_COMPLETED
,      UOM_CODE
,      CONVERSION_RATE
,      SOURCE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      SEC_CONVERSION_RATE
,      STANDARD_VALUE_G
,      ACTUAL_VALUE_G
,      STANDARD_VALUE_SG
,      ACTUAL_VALUE_SG
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
FROM OPI.OPI_DBI_MFG_CST_VAR_F;

Dependencies

[top of page]

OPI.OPI_DBI_MFG_CST_VAR_F does not reference any database object

OPI.OPI_DBI_MFG_CST_VAR_F is referenced by following:

APPS: OPI_DBI_MFG_CST_VAR_F; OPI_MFG_VAR_SUM_MV