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_JOB_MTL_DETAILS_F

Object Details

Object Name:	OPI_DBI_JOB_MTL_DETAILS_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_JOB_MTL_DETAILS_F_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	ORGANIZATION_ID JOB_ID JOB_TYPE ASSEMBLY_ITEM_ID COMPONENT_ITEM_ID LINE_TYPE TRANSACTION_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.
COMPONENT_ITEM_ID	NUMBER			Material Component Inventory Item Id.
STANDARD_VALUE_B	NUMBER			Standard Material Usage Value in Functional Currency (OPI: At this point, it assumes Total Completion of the Job Start Quantity).
ACTUAL_VALUE_B	NUMBER			Actual Material Usage Value in Functional Currency.
STANDARD_QUANTITY	NUMBER			WRO.Required_Quantity: Part Quantity required.
ACTUAL_QUANTITY	NUMBER			Actual quantity used from MMT.
UOM_CODE	VARCHAR2	(3)		Primary Unit of Measure of the component.
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.
LINE_TYPE	NUMBER			-1 Ingredient, 1 Co-Product, 2 By-Product
TRANSACTION_DATE	DATE			Transaction Date
ACTUAL_QUANTITY_DRAFT	NUMBER			Actual Qty in draft mode for OPM transactions, 0 for ODM transactions.
ACTUAL_VALUE_DRAFT_B	NUMBER			Actual Value in base currency for OPM transactions, 0 fro ODM.
ACTUAL_VALUE_G	NUMBER			Actual Value in global Currency.
ACTUAL_VALUE_SG	NUMBER			Actual Value in Secondary Global Currency.
ACTUAL_VALUE_DRAFT_G	NUMBER			Actual Value in global currency for OPM draft mode transactions.
ACTUAL_VALUE_DRAFT_SG	NUMBER			Actual value in secondary global currency for OPM draft mode transactions.
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
,      COMPONENT_ITEM_ID
,      STANDARD_VALUE_B
,      ACTUAL_VALUE_B
,      STANDARD_QUANTITY
,      ACTUAL_QUANTITY
,      UOM_CODE
,      SOURCE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LINE_TYPE
,      TRANSACTION_DATE
,      ACTUAL_QUANTITY_DRAFT
,      ACTUAL_VALUE_DRAFT_B
,      ACTUAL_VALUE_G
,      ACTUAL_VALUE_SG
,      ACTUAL_VALUE_DRAFT_G
,      ACTUAL_VALUE_DRAFT_SG
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
FROM OPI.OPI_DBI_JOB_MTL_DETAILS_F;

Dependencies

[top of page]

OPI.OPI_DBI_JOB_MTL_DETAILS_F does not reference any database object

OPI.OPI_DBI_JOB_MTL_DETAILS_F is referenced by following:

APPS: OPI_DBI_JOB_MTL_DETAILS_F; OPI_JOBS_001_MV; OPI_MTL_VAR_ACT_MV_F