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_EDW_JOB_RSRC_F

Object Details

Object Name:	OPI_EDW_JOB_RSRC_F
Object Type:	TABLE
Owner:	OPI
FND Design Data:	OPI.OPI_EDW_JOB_RSRC_F
Subobject Name:
Status:	VALID

This is the Job Resource Fact. It contains detailed information regarding resources used in Jobs/Batches. It will contain usage, value and count information for resources. It will also contain quantities produced by resources and the associated timing information. The Fact will record both actual and planned values for the measures. In addition, it will also contain attributes like Department code and Job number.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OPI_EDW_JOB_RSRC_F_U2	NORMAL	UNIQUE	APPS_TS_SUMMARY	JOB_RSRC_PK JOB_RSRC_PK_KEY
OPI_EDW_JOB_RSRC_F_UKEY	NORMAL	UNIQUE	APPS_TS_SUMMARY	JOB_RSRC_PK_KEY
OPI_EDW_JOB_RSRC_F_N1	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	SOB_CURRENCY_FK_KEY
OPI_EDW_JOB_RSRC_F_N10	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	TRX_DATE_FK_KEY
OPI_EDW_JOB_RSRC_F_N2	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	USAGE_UOM_FK_KEY
OPI_EDW_JOB_RSRC_F_N3	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	QTY_UOM_FK_KEY
OPI_EDW_JOB_RSRC_F_N4	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	INSTANCE_FK_KEY
OPI_EDW_JOB_RSRC_F_N5	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	ITEM_FK_KEY
OPI_EDW_JOB_RSRC_F_N6	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	LOCATOR_FK_KEY
OPI_EDW_JOB_RSRC_F_N7	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	OPRN_FK_KEY
OPI_EDW_JOB_RSRC_F_N8	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	RSRC_FK_KEY
OPI_EDW_JOB_RSRC_F_N9	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	ACTIVITY_FK_KEY

Columns

Name	Datatype	Length	Mandatory	Comments
ACTIVITY_FK_KEY	NUMBER			Surrogate Key generated by the Load program to Activity Dimension.
ACT_CMPL_DATE	DATE			Actual completion date of the Job step (Operation).
ACT_RSRC_COUNT	NUMBER			Actual resource count used in the Batch step. Currently 0 for Discrete Manufacturing sources.
ACT_RSRC_QTY	NUMBER			Actual quantity processed by the resource
ACT_RSRC_USAGE	NUMBER			Actual resource usage.
ACT_RSRC_USAGE_VAL_B	NUMBER			Actual resource usage value in Set Of Books currency.
ACT_RSRC_USAGE_VAL_G	NUMBER			Actual resource usage value in Warehouse currency.
ACT_RSRC_VAL_B	NUMBER			Actual value of the item processed by the resource, in Set Of Books currency, calculated by (Processed quantity * Cost). Currently 0 for Discrete manufacturing sources.
ACT_RSRC_VAL_G	NUMBER			Actual value of the item processed by the resource, in Warehouse currency, calculated by (Processed quantity * Cost). Currently 0 for Discrete manufacturing sources.
ACT_STRT_DATE	DATE			Actual start date of the Job step (Operation).
AVL_RSRC	NUMBER			Available resource.
CREATION_DATE	DATE			Standard who column.
DEPARTMENT	VARCHAR2	(80)		Department code.
EXTD_RSRC_COST	NUMBER			Extended Resource Cost. Currently 0 for Discrete Manufacturing sources.
INSTANCE_FK_KEY	NUMBER			Surrogate Key generated by the Load program to Instance Dimension.
ITEM_FK_KEY	NUMBER			Surrogate Key generated by the Load program to Item Dimension -Item Organization Level (This is the product produced by the resource)
JOB_NO	VARCHAR2	(80)		Job/Batch Number.
JOB_RSRC_PK_KEY	NUMBER		Yes	Surrogate Key determined by the Load program
LOCATOR_FK_KEY	NUMBER			Surrogate Key generated by the Load program to Inventory Location Dimension - Inventory Org group level for Process Mfg sources and Inventory Org Level for Discrete Mfg sources. Based on the Organization where the Job/Batch is executed.
OPERATION_SEQ_NO	VARCHAR2	(80)		Operations step in the job.
OPRN_FK_KEY	NUMBER			Surrogate Key generated by the Load program to Operation Dimension - Operation level.
PLN_CMPL_DATE	DATE			Planned completion date of the Job step (Operation).
PLN_RSRC_COUNT	NUMBER			Planned resource count.Currently 0 for Discrete Manufacturing sources.
PLN_RSRC_QTY	NUMBER			Planned resource quantity processed by the resource
PLN_RSRC_USAGE	NUMBER			Planned resource usage.
PLN_RSRC_USAGE_VAL_B	NUMBER			Planned resource usage value in Set Of Books currency.
PLN_RSRC_USAGE_VAL_G	NUMBER			Planned resource usage value in Warehouse currency.
PLN_RSRC_VAL_B	NUMBER			Planned value of the item processed by the resource, in Set Of Books currency , calculated by (Planned Process Qty * Cost). Currently 0 for Discrete Manufacturing sources.
PLN_RSRC_VAL_G	NUMBER			Planned value of the item processed by the resource, in Warehouse currency , calculated by (Planned Process Qty * Cost). Currently 0 for Discrete Manufacturing sources.
PLN_STRT_DATE	DATE			Planned start date of the Job step (Operation).
RSRC_FK_KEY	NUMBER			Surrogate Key generated by the Load program to Resource Dimension - Resource level.
SOB_CURRENCY_FK_KEY	NUMBER			Surrogate Key generated by the Load program to Currency Dimension for SOB Currency
TRX_DATE_FK_KEY	NUMBER			Surrogate Key generated by the Load program to Time Dimension - Calendar Day level.Based on Actual completion date of the Job step (operation).
USAGE_UOM_FK_KEY	NUMBER			Surrogate Key generated by the Load program to Unit Of Measure Dimension .Based on Resource Usage UOM.
USER_ATTRIBUTE1	VARCHAR2	(240)		User defined attribute1
USER_ATTRIBUTE10	VARCHAR2	(240)		User defined attribute10
USER_ATTRIBUTE11	VARCHAR2	(240)		User defined attribute11
USER_ATTRIBUTE12	VARCHAR2	(240)		User defined attribute12
USER_ATTRIBUTE13	VARCHAR2	(240)		User defined attribute13
USER_ATTRIBUTE14	VARCHAR2	(240)		User defined attribute14
USER_ATTRIBUTE15	VARCHAR2	(240)		User defined attribute15
USER_ATTRIBUTE2	VARCHAR2	(240)		User defined attribute2
USER_ATTRIBUTE3	VARCHAR2	(240)		User defined attribute3
USER_ATTRIBUTE4	VARCHAR2	(240)		User defined attribute4
USER_ATTRIBUTE5	VARCHAR2	(240)		User defined attribute5
USER_ATTRIBUTE6	VARCHAR2	(240)		User defined attribute6
USER_ATTRIBUTE7	VARCHAR2	(240)		User defined attribute7
USER_ATTRIBUTE8	VARCHAR2	(240)		User defined attribute8
USER_ATTRIBUTE9	VARCHAR2	(240)		User defined attribute9
USER_FK1_KEY	NUMBER			Surrogate Key determined by the Load program for a user defined Dimension.
USER_FK2_KEY	NUMBER			Surrogate Key determined by the Load program for a user defined Dimension.
USER_FK3_KEY	NUMBER			Surrogate Key determined by the Load program for a user defined Dimension.
USER_FK4_KEY	NUMBER			Surrogate Key determined by the Load program for a user defined Dimension.
USER_FK5_KEY	NUMBER			Surrogate Key determined by the Load program for a user defined Dimension.
USER_MEASURE1	NUMBER			User defined measure1
USER_MEASURE2	NUMBER			User defined measure2
USER_MEASURE3	NUMBER			User defined measure3
USER_MEASURE4	NUMBER			User defined measure4
USER_MEASURE5	NUMBER			User defined measure5
JOB_RSRC_PK	VARCHAR2	(240)		User defined Primary Key. This will have the structure of PRODTAG is either OPM or OPI depending on whether OPM or OPI extracted the row.
QTY_UOM_FK_KEY	NUMBER			Surrogate Key generated by the Load program to Unit Of Measure Dimension for measuring quantity.
LAST_UPDATE_DATE	DATE			Standard who column.
STND_RSRC_USAGE	NUMBER			Standard resource usage, calculated as (Planned resource usage/Planned quantity produced) *Actual quantity produced.

Query Text

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


SELECT ACTIVITY_FK_KEY
,      ACT_CMPL_DATE
,      ACT_RSRC_COUNT
,      ACT_RSRC_QTY
,      ACT_RSRC_USAGE
,      ACT_RSRC_USAGE_VAL_B
,      ACT_RSRC_USAGE_VAL_G
,      ACT_RSRC_VAL_B
,      ACT_RSRC_VAL_G
,      ACT_STRT_DATE
,      AVL_RSRC
,      CREATION_DATE
,      DEPARTMENT
,      EXTD_RSRC_COST
,      INSTANCE_FK_KEY
,      ITEM_FK_KEY
,      JOB_NO
,      JOB_RSRC_PK_KEY
,      LOCATOR_FK_KEY
,      OPERATION_SEQ_NO
,      OPRN_FK_KEY
,      PLN_CMPL_DATE
,      PLN_RSRC_COUNT
,      PLN_RSRC_QTY
,      PLN_RSRC_USAGE
,      PLN_RSRC_USAGE_VAL_B
,      PLN_RSRC_USAGE_VAL_G
,      PLN_RSRC_VAL_B
,      PLN_RSRC_VAL_G
,      PLN_STRT_DATE
,      RSRC_FK_KEY
,      SOB_CURRENCY_FK_KEY
,      TRX_DATE_FK_KEY
,      USAGE_UOM_FK_KEY
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE10
,      USER_ATTRIBUTE11
,      USER_ATTRIBUTE12
,      USER_ATTRIBUTE13
,      USER_ATTRIBUTE14
,      USER_ATTRIBUTE15
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      USER_ATTRIBUTE6
,      USER_ATTRIBUTE7
,      USER_ATTRIBUTE8
,      USER_ATTRIBUTE9
,      USER_FK1_KEY
,      USER_FK2_KEY
,      USER_FK3_KEY
,      USER_FK4_KEY
,      USER_FK5_KEY
,      USER_MEASURE1
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
,      JOB_RSRC_PK
,      QTY_UOM_FK_KEY
,      LAST_UPDATE_DATE
,      STND_RSRC_USAGE
FROM OPI.OPI_EDW_JOB_RSRC_F;

Dependencies

[top of page]

OPI.OPI_EDW_JOB_RSRC_F does not reference any database object

OPI.OPI_EDW_JOB_RSRC_F is referenced by following:

APPS: OPI_EDW_JOB_RSRC_F