[Home] [Help] [Dependency Information]
Object Name: | OPI_EDW_OPM_RES_UTIL_FCV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OPI.OPI_EDW_OPM_RES_UTIL_FCV |
Subobject Name: | |
Status: | VALID |
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 process manufacturing side.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RES_UTIL_PK | VARCHAR2 | (66) | Foreign key on the resource dimension - resource level. | |
LOCATOR_FK | VARCHAR2 | (44) | Foreign key on the new inventory locaiton dimension at the inventory organization group level for OPM. | |
RES_FK | VARCHAR2 | (51) | Foreign key on the resource dimension - resource level. | |
TRX_DATE_FK | VARCHAR2 | (4000) | Foreign key on the time dimension - calendar day level. | |
UOM_FK | VARCHAR2 | (4000) | 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 | (0) | 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 | DATE | 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. |
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_OPM_RES_UTIL_FCV;
|
|
|