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_OPI_JOB_RSRC_FCV

Object Details

Object Name:	OPI_EDW_OPI_JOB_RSRC_FCV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OPI.OPI_EDW_OPI_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 information from OPI sources.

[View Source]

Columns

Name	Datatype	Length	Comments
VIEW_ID	NUMBER		View Identifier.
SEQ_ID	NUMBER		Surrogate key for the sequence.
JOB_RSRC_PK	VARCHAR2	(239)	Primary key for job resource record.
ACT_RSRC_COUNT	NUMBER		Actual resource count used in the batch step.
PLN_RSRC_COUNT	NUMBER		Planned resource count.
ACT_RSRC_QTY	NUMBER		Actual resource quantity.
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.
PLN_RSRC_QTY	NUMBER		Planned resource quantity.
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.
ACT_RSRC_USAGE	NUMBER		Planned resource usage value in warehouse currency.
PLN_RSRC_USAGE	NUMBER		Planned resource usage.
STND_RSRC_USAGE	NUMBER		Standard resource usage is (planned resource usage / planned quantity produced) * actual quantity produced.
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.
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.
EXTD_RSRC_COST	NUMBER		Extended resource cost.
JOB_NO	VARCHAR2	(240)	Code for the job.
OPERATION_SEQ_NO	NUMBER		Sequence identifier for the operations.
DEPARTMENT	VARCHAR2	(10)	Department name.
ACT_STRT_DATE	DATE		Actual start date.
ACT_CMPL_DATE	DATE		Actual completed date.
PLN_STRT_DATE	DATE		Planned start date.
PLN_CMPL_DATE	DATE		Planned completed date.
SOB_CURRENCY_FK	VARCHAR2	(4000)	Foreign key on the currency dimension for the set of books currency.
QTY_UOM_FK	VARCHAR2	(4000)	Foreign key on the unit of measure dimension for measuring quantity.
INSTANCE_FK	VARCHAR2	(30)	Foreign key on the instance dimension.
LOCATOR_FK	VARCHAR2	(4000)	Foreign key on the inventory location dimension - based on the organization where the job / batch is executed.
ACTIVITY_FK	VARCHAR2	(75)	Foreign key on the activity dimension.
TRX_DATE_FK	VARCHAR2	(4000)	Foreign key on the time dimension - calendar day level. Based on actual completion date of the job step (operation).
OPRN_FK	VARCHAR2	(116)	Foreign key on the operation dimension - operation level.
RSRC_FK	VARCHAR2	(4000)	Foreign key on the resource dimension - resource level.
ITEM_FK	VARCHAR2	(4000)	Foreign key on the item dimension - item organization level (This is the product produced by the resource).
USAGE_UOM_FK	VARCHAR2	(4000)	Foreign key on the unit of measure dimension. Based on resource usage UOM.
GLOBAL_CURRENCY_RATE	NUMBER		Global currency rate.

Query Text

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


SELECT VIEW_ID
,      SEQ_ID
,      JOB_RSRC_PK
,      ACT_RSRC_COUNT
,      PLN_RSRC_COUNT
,      ACT_RSRC_QTY
,      ACT_RSRC_VAL_B
,      ACT_RSRC_VAL_G
,      PLN_RSRC_QTY
,      PLN_RSRC_VAL_B
,      PLN_RSRC_VAL_G
,      ACT_RSRC_USAGE
,      PLN_RSRC_USAGE
,      STND_RSRC_USAGE
,      ACT_RSRC_USAGE_VAL_B
,      ACT_RSRC_USAGE_VAL_G
,      PLN_RSRC_USAGE_VAL_B
,      PLN_RSRC_USAGE_VAL_G
,      EXTD_RSRC_COST
,      JOB_NO
,      OPERATION_SEQ_NO
,      DEPARTMENT
,      ACT_STRT_DATE
,      ACT_CMPL_DATE
,      PLN_STRT_DATE
,      PLN_CMPL_DATE
,      SOB_CURRENCY_FK
,      QTY_UOM_FK
,      INSTANCE_FK
,      LOCATOR_FK
,      ACTIVITY_FK
,      TRX_DATE_FK
,      OPRN_FK
,      RSRC_FK
,      ITEM_FK
,      USAGE_UOM_FK
,      GLOBAL_CURRENCY_RATE
FROM APPS.OPI_EDW_OPI_JOB_RSRC_FCV;

Dependencies

[top of page]

APPS.OPI_EDW_OPI_JOB_RSRC_FCV references the following:

APPS: BOM_DEPARTMENTS; BOM_OPERATIONAL_ROUTINGS; BOM_OPERATION_SEQUENCES; EDW_BOM_RES_PKG - show dependent code; EDW_CURRENCY - show dependent code; EDW_ITEMS_PKG - show dependent code; EDW_LOCAL_INSTANCE; EDW_MTL_INVENTORY_LOC_PKG - show dependent code; EDW_TIME_PKG - show dependent code; EDW_UTIL - show dependent code; GL_SETS_OF_BOOKS; HR_ORGANIZATION_INFORMATION; MTL_SYSTEM_ITEMS; OPI_EDW_JOB_RSRC_PVT - show dependent code; OPI_EDW_OPI_JOB_RSRC_INC; WIP_DISCRETE_JOBS; WIP_ENTITIES; WIP_FLOW_SCHEDULES; WIP_OPERATIONS; WIP_OPERATION_RESOURCES; WIP_REPETITIVE_SCHEDULES; WIP_TRANSACTIONS; WIP_TRANSACTION_ACCOUNTS

APPS.OPI_EDW_OPI_JOB_RSRC_FCV is referenced by following:

APPS: OPI_EDW_OPI_JOB_RSRC_F_C - show dependent code