[Home] [Help] [Dependency Information]
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 |
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.
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. |
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;
|
|
|