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_JOBS_F

Object Details

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

Fact Table for Jobs Master ETL.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OPI_DBI_JOBS_F_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	JOB_ID JOB_TYPE ASSEMBLY_ITEM_ID LINE_TYPE
OPI_DBI_JOBS_F_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	STD_REQ_FLAG
OPI_DBI_JOBS_F_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	JOB_TYPE
OPI_DBI_JOBS_F_N3	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	INCLUDE_JOB
OPI_DBI_JOBS_F_N4	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	SOURCE
OPI_DBI_JOBS_F_N5	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	STD_RES_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
ORGANIZATION_ID	NUMBER			Manufacturing Organization Id.
JOB_ID	NUMBER		Yes	Discrete and Flow: WIP_Entity_Id. Repetitive Schedule: Repetitive_Schedule_Id (i.e. WIP Job Identifier).
JOB_TYPE	NUMBER		Yes	1:Discrete, 2:Repetitive Schedule, 3:Flow Schedule, 4:Process.
STATUS	VARCHAR2	(40)	Yes	Job Status: Cancelled, Complete - No Charges, Closed.
COMPLETION_DATE	DATE			Job Completion/Close date.
ASSEMBLY_ITEM_ID	NUMBER			Assembly Inventory Item Id.
START_QUANTITY	NUMBER			Job Start Quantity.
ACTUAL_QTY_COMPLETED	NUMBER			Actual Quantity of the assembly completed by the job.
UOM_CODE	VARCHAR2	(3)		Primary Unit of Measure of the assembly.
CONVERSION_RATE	NUMBER			Conversion Rate from Functional Currency to Global Currency for the Completion date.
INCLUDE_JOB	NUMBER		Yes	1: Include this job in the Base MV. 2: Do not include this job in the Base MV.
STD_REQ_FLAG	NUMBER		Yes	Flag to indicate the re-extraction of WIP Requirement Operations. 1 = Yes. 0 = No.
STD_RES_FLAG	NUMBER		Yes	Flag to indicate the re-extraction of WIP Standard Resource Usage. 1 = Yes. 0 = No.
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 currency
JOB_NAME	VARCHAR2	(240)		Job Name
LINE_TYPE	NUMBER			Line Type, -1 ingredient, 1 Co-Product, 2 By-Product
SCHEDULED_COMPLETION_DATE	DATE			Scheduled Completion Date of the job
JOB_STATUS_CODE	NUMBER			id column from Job Status Dimension View
JOB_START_VALUE	NUMBER			Job Start Value
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
,      STATUS
,      COMPLETION_DATE
,      ASSEMBLY_ITEM_ID
,      START_QUANTITY
,      ACTUAL_QTY_COMPLETED
,      UOM_CODE
,      CONVERSION_RATE
,      INCLUDE_JOB
,      STD_REQ_FLAG
,      STD_RES_FLAG
,      SOURCE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      SEC_CONVERSION_RATE
,      JOB_NAME
,      LINE_TYPE
,      SCHEDULED_COMPLETION_DATE
,      JOB_STATUS_CODE
,      JOB_START_VALUE
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
FROM OPI.OPI_DBI_JOBS_F;

Dependencies

[top of page]

OPI.OPI_DBI_JOBS_F does not reference any database object

OPI.OPI_DBI_JOBS_F is referenced by following:

APPS: OPI_CURR_PROD_DEL_001_MV; OPI_DBI_JOBS_F; OPI_DBI_RES_VAR_MV; OPI_MFG_VAR_SUM_MV; OPI_MTL_VAR_MV_F; OPI_ONTIME_PROD_001_MV