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]

VIEW: APPS.OPI_EDW_OPM_JOB_RSRC_FCV

Object Details

Object Name:	OPI_EDW_OPM_JOB_RSRC_FCV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OPI.OPI_EDW_OPM_JOB_RSRC_FCV
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This is the source view for extracting job-resource data from the Process Manufacturing source tables.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
JOB_RSRC_PK	VARCHAR2	(232)		Primary key for job resource record.
ACTIVITY_FK	VARCHAR2	(51)		Foreign key on the activity dimension.
LOCATOR_FK	VARCHAR2	(44)		Foreign key on the inventory location dimension - inventory organization group level for process manufacturing sources based on the organization where the job/batch is executed.
ITEM_FK	VARCHAR2	(4000)		Foreign key on the item dimension - item organization level (This is the product produced by the resource).
RSRC_FK	VARCHAR2	(51)		Foreign key on the resource dimension - resource level.
TRX_DATE_FK	VARCHAR2	(120)		Foreign key on the time dimension - calendar day level. Based on actual completion date of the job step (operation).
QTY_UOM_FK	CHAR	(6)		Foreign key on the unit of measure dimension for measuring quantity.
SOB_CURRENCY_FK	VARCHAR2	(4)	Yes	Foreign key on the currency dimension for set of books currency.
USAGE_UOM_FK	VARCHAR2	(4000)		Foreign key on the unit of measure dimension. Based on resource usage UOM.
INSTANCE_FK	VARCHAR2	(30)		Foreign key on the instance dimension.
OPRN_FK	VARCHAR2	(75)		Foreign key on the operation dimension - operation level.
USER_FK1	CHAR	(6)		User defined dimension foreign key.
USER_FK2	CHAR	(6)		User defined dimension foreign key.
USER_FK3	CHAR	(6)		User defined dimension foreign key.
USER_FK4	CHAR	(6)		User defined dimension foreign key.
USER_FK5	CHAR	(6)		User defined dimension foreign key.
ACT_CMPL_DATE	DATE			Actual completed date.
ACT_RSRC_COUNT	NUMBER			Actual resource count used in the batch step.
ACT_RSRC_QTY	NUMBER			Actual resource quantity.
ACT_RSRC_USAGE	NUMBER			Actual resource Usage.
ACT_RSRC_USAGE_VAL_B	NUMBER			Actual resource usage value in set of books.
ACT_RSRC_USAGE_VAL_G	NUMBER			Actual resource usage value in warehouse currency.
ACT_RSRC_VAL_B	NUMBER			Actual resource usage value in set of books.
ACT_RSRC_VAL_G	NUMBER			Actual resource Usage value in warehouse currency.
AVL_RSRC	NUMBER			Available resources.
ACT_STRT_DATE	DATE			Actual start date.
DEPARTMENT	VARCHAR2	(0)		Department name.
EXTD_RSRC_COST	NUMBER			Extended resource cost.
OPERATION_SEQ_NO	NUMBER	(5)	Yes	Sequence of operations in job resources.
PLN_CMPL_DATE	DATE		Yes	Planned completed date.
PLN_RSRC_COUNT	NUMBER		Yes	Planned resource count.
PLN_RSRC_QTY	NUMBER			Planned resource quantity.
PLN_RSRC_USAGE	NUMBER			Planned resource usage.
PLN_RSRC_USAGE_VAL_B	NUMBER			Planned resource usage value in set of books.
PLN_RSRC_USAGE_VAL_G	NUMBER			Planned resource usage value in warehouse currency.
PLN_RSRC_VAL_B	NUMBER			Planned resource usage value in set of books.
PLN_RSRC_VAL_G	NUMBER			Planned resource usage value in warehouse currency.
PLN_STRT_DATE	DATE		Yes	Planned start date.
USER_MEASURE1	NUMBER			User defined measure.
USER_MEASURE2	NUMBER			User defined measure.
USER_MEASURE3	NUMBER			User defined measure.
USER_MEASURE4	NUMBER			User defined measure.
USER_MEASURE5	NUMBER			User defined measure.
JOB_NO	VARCHAR2	(32)	Yes	Code for the job.
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column.
USER_ATTRIBUTE1	VARCHAR2	(0)		User Defined Attribute1.
USER_ATTRIBUTE2	VARCHAR2	(0)		User Defined Attribute2.
USER_ATTRIBUTE3	VARCHAR2	(0)		User Defined Attribute3.
USER_ATTRIBUTE4	VARCHAR2	(0)		User Defined Attribute4.
USER_ATTRIBUTE5	VARCHAR2	(0)		User Defined Attribute5.
USER_ATTRIBUTE6	VARCHAR2	(0)		User Defined Attribute6.
USER_ATTRIBUTE7	VARCHAR2	(0)		User Defined Attribute7.
USER_ATTRIBUTE8	VARCHAR2	(0)		User Defined Attribute8.
USER_ATTRIBUTE9	VARCHAR2	(0)		User Defined Attribute9.
USER_ATTRIBUTE10	VARCHAR2	(0)		User Defined Attribute10.
USER_ATTRIBUTE11	VARCHAR2	(0)		User Defined Attribute11.
USER_ATTRIBUTE12	VARCHAR2	(0)		User Defined Attribute12.
USER_ATTRIBUTE13	VARCHAR2	(0)		User Defined Attribute13.
USER_ATTRIBUTE14	VARCHAR2	(0)		User Defined Attribute14.
USER_ATTRIBUTE15	VARCHAR2	(0)		User Defined Attribute15.
SEQ_ID	NUMBER			Surrogate key for the sequence.
VIEW_ID	NUMBER			View Identifier.
STND_RSRC_USAGE	NUMBER			Primary key on the job resources.

Query Text

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


SELECT JOB_RSRC_PK
,      ACTIVITY_FK
,      LOCATOR_FK
,      ITEM_FK
,      RSRC_FK
,      TRX_DATE_FK
,      QTY_UOM_FK
,      SOB_CURRENCY_FK
,      USAGE_UOM_FK
,      INSTANCE_FK
,      OPRN_FK
,      USER_FK1
,      USER_FK2
,      USER_FK3
,      USER_FK4
,      USER_FK5
,      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
,      AVL_RSRC
,      ACT_STRT_DATE
,      DEPARTMENT
,      EXTD_RSRC_COST
,      OPERATION_SEQ_NO
,      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
,      USER_MEASURE1
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
,      JOB_NO
,      LAST_UPDATE_DATE
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      USER_ATTRIBUTE6
,      USER_ATTRIBUTE7
,      USER_ATTRIBUTE8
,      USER_ATTRIBUTE9
,      USER_ATTRIBUTE10
,      USER_ATTRIBUTE11
,      USER_ATTRIBUTE12
,      USER_ATTRIBUTE13
,      USER_ATTRIBUTE14
,      USER_ATTRIBUTE15
,      SEQ_ID
,      VIEW_ID
,      STND_RSRC_USAGE
FROM APPS.OPI_EDW_OPM_JOB_RSRC_FCV;

Dependencies

[top of page]

APPS.OPI_EDW_OPM_JOB_RSRC_FCV references the following:

APPS: CR_RSRC_DTL; EDW_CURRENCY - show dependent code; EDW_ITEMS_PKG - show dependent code; EDW_LOCAL_INSTANCE; EDW_TIME_PKG - show dependent code; EDW_UTIL - show dependent code; FM_OPRN_DTL; FM_OPRN_MST; GL_PLCY_MST; GL_SETS_OF_BOOKS; IC_ITEM_MST; IC_WHSE_MST; MTL_SYSTEM_ITEMS; OPI_EDW_OPM_JOB_RSRC_INC; OPI_OPM_COMMON_PKG - show dependent code; OPI_PMI_UOMS_MST; PM_BTCH_HDR; PM_MATL_DTL; PM_OPRN_DTL; SY_ORGN_MST

APPS.OPI_EDW_OPM_JOB_RSRC_FCV is referenced by following:

APPS: OPI_EDW_OPM_JOB_RSRC_F_C - show dependent code