DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.OPI_EDW_OPI_RES_UTIL_FCV

Object Details
Object Name: OPI_EDW_OPI_RES_UTIL_FCV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOPI.OPI_EDW_OPI_RES_UTIL_FCV
Subobject Name:
Status: VALID

View Type

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


This view contains the extraction logic for data to the Resource Utilization fact from discrete manufacturing side.


[View Source]

Columns
Name Datatype Length Mandatory Comments
RES_UTIL_PK VARCHAR2 (275)
Prinmary key on the resource utilisation record.
LOCATOR_FK VARCHAR2 (66)
Foreign key on the new inventory location dimension at the inventory organization level for OPI. Organization where resource is charged.
RES_FK VARCHAR2 (123)
Foreign key on the resource dimension, resource level.
TRX_DATE_FK VARCHAR2 (4000)
Foreign key on the time dimension at the calendar day level.
UOM_FK VARCHAR2 (30)
Foreign key on the UOM dimension.
INSTANCE_FK VARCHAR2 (30)
Foreign key on the instance dimension.
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_RES_USAGE NUMBER

Actual resource charged to job/schedules for a department.
AVAIL_RES NUMBER

Resource capacity available for a department.
DEPARTMENT VARCHAR2 (30)
Department name.
TRX_DATE DATE

Transaction date.
USER_MEASURE1 VARCHAR2 (0)
User defined measure.
USER_MEASURE2 VARCHAR2 (0)
User defined measure.
USER_MEASURE3 VARCHAR2 (0)
User defined measure.
USER_MEASURE4 VARCHAR2 (0)
User defined measure.
USER_MEASURE5 VARCHAR2 (0)
User defined measure.
LAST_UPDATE_DATE VARCHAR2 (0)
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.
Query Text

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


SELECT RES_UTIL_PK
,      LOCATOR_FK
,      RES_FK
,      TRX_DATE_FK
,      UOM_FK
,      INSTANCE_FK
,      USER_FK1
,      USER_FK2
,      USER_FK3
,      USER_FK4
,      USER_FK5
,      ACT_RES_USAGE
,      AVAIL_RES
,      DEPARTMENT
,      TRX_DATE
,      USER_MEASURE1
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
,      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
FROM APPS.OPI_EDW_OPI_RES_UTIL_FCV;

Dependencies

[top of page]

APPS.OPI_EDW_OPI_RES_UTIL_FCV references the following:

SchemaAPPS
SynonymEDW_LOCAL_INSTANCE
PL/SQL PackageEDW_TIME_PKG - show dependent code
SynonymOPI_EDW_RES_UTIL_PUSH_LOG
APPS.OPI_EDW_OPI_RES_UTIL_FCV is referenced by following:

SchemaAPPS
Package BodyOPI_EDW_OPI_RES_UTIL_F_C - show dependent code