[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OPI_EDW_JOB_DETAIL_F |
|---|---|
| Object Type: | TABLE |
| Owner: | OPI |
| FND Design Data: |  OPI.OPI_EDW_JOB_DETAIL_F
|
| Subobject Name: | |
| Status: | VALID |
Job Detail fact will store the detail information of the Jobs/Batches. There will be one row for each jobs and each end products. For example, if a batch produces two products ( one main product and one co-product) then the fact table will have two rows.
| Tablespace: |  APPS_TS_SUMMARY |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| OPI_EDW_JOB_DETAIL_F_U2 | NORMAL | UNIQUE |
APPS_TS_SUMMARY
|
 JOB_DETAIL_PK
JOB_DETAIL_PK_KEY
|
| OPI_EDW_JOB_DETAIL_F_UKEY | NORMAL | UNIQUE |
APPS_TS_SUMMARY
|
JOB_DETAIL_PK_KEY
|
| OPI_EDW_JOB_DETAIL_F_N1 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
SOB_CURRENCY_FK_KEY
|
| OPI_EDW_JOB_DETAIL_F_N2 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
BASE_UOM_FK_KEY
|
| OPI_EDW_JOB_DETAIL_F_N3 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
INSTANCE_FK_KEY
|
| OPI_EDW_JOB_DETAIL_F_N4 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
ITEM_FK_KEY
|
| OPI_EDW_JOB_DETAIL_F_N5 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
LOCATOR_FK_KEY
|
| OPI_EDW_JOB_DETAIL_F_N6 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
PRD_LINE_FK_KEY
|
| OPI_EDW_JOB_DETAIL_F_N7 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
RES_LOOKUP_FK_KEY
|
| OPI_EDW_JOB_DETAIL_F_N8 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
STS_LOOKUP_FK_KEY
|
| OPI_EDW_JOB_DETAIL_F_N9 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
TRX_DATE_FK_KEY
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ACT_BPR_VAL_B | NUMBER | Actual By-Product value from a Job, in Set Of Books currency respectively.This is the cost of all By-products produced from the batch. By-product is vary common for OPM , Discrete may or may not have By-products. | ||
| ACT_BPR_VAL_G | NUMBER | Actual By-Product value from a Job, in Warehouse currency respectively.This is the cost of all By-products produced from the batch. By-product is vary common for OPM , Discrete may or may not have By-products | ||
| ACT_CMPL_DATE | DATE | Actual completion date of the Job | ||
| ACT_CNCL_DATE | DATE | cancellation date of the Job | ||
| ACT_INP_VAL_B | NUMBER | Actual input (Ingredient and Component) value from a Job, in Set Of Books .This is the cost of all components used in the batch. | ||
| ACT_INP_VAL_G | NUMBER | Actual input (Ingredient and Component) value from a Job, in Warehouse currency respectively.This is the cost of all components used in the batch. | ||
| ACT_JOB_TIME | NUMBER | Actual time taken by the job in days | ||
| ACT_MTL_INP_VAL_B | NUMBER | Actual Material input value from a Job, in Set Of Books .This is the cost of all material components used in the batch. | ||
| ACT_MTL_INP_VAL_G | NUMBER | Actual Material input value from a Job, in Warehouse currency .This is the cost of all material components used in the batch. | ||
| ACT_OUT_QTY | NUMBER | Qty Produced by the Batch/Job | ||
| ACT_OUT_VAL_B | NUMBER | Value Produced by the Batch/Job. Qty * Unit Cost in SOB currency | ||
| ACT_OUT_VAL_G | NUMBER | Value Produced by the Batch/Job. Qty * Unit Cost in Warehouse currency | ||
| ACT_SCR_VAL_B | NUMBER | Actual Scrap value from a Job, in Set Of Books currency .This is the cost of all scraps produced from the batch. | ||
| ACT_SCR_VAL_G | NUMBER | Actual Scrap value from a Job, Warehouse currency.This is the cost of all scraps produced from the batch. | ||
| ACT_STRT_DATE | DATE | Actual Start date of the Job | ||
| BASE_UOM_FK_KEY | NUMBER | FK Key to Unit Of Measure Dimension | ||
| CREATION_DATE | DATE | Who column | ||
| FST_PASS_YLD | NUMBER | First Pass Yield Qty. Used mainly by Flow manufacturing. | ||
| INSTANCE_FK_KEY | NUMBER | FK Key to Instance Dimension | ||
| ITEM_FK_KEY | NUMBER | FK Key to Item Dimension - Item-Org level | ||
| JOB_DETAIL_PK | VARCHAR2 | (240) | User Primary Key | |
| JOB_DETAIL_PK_KEY | NUMBER | Yes | System Generater Primary Key | |
| JOB_NO | VARCHAR2 | (80) | Job/Batch Number | |
| JOB_STATUS | VARCHAR2 | (40) | Status of a batch (Released, WIP, Certified, Closed, Canceled, Rescheduled ) | |
| LAST_UPDATE_DATE | DATE | Who column | ||
| LOCATOR_FK_KEY | NUMBER | FK Key to new Inventory Location Dimension - Inventory Org group level for OPM and Inventory Org Level for OPI | ||
| MFG_MODE | VARCHAR2 | (80) | Manufacturing Mode . The mode in which the job has been performed. ExampleProcess Mfg PROCESSMFGDiscrete Mfg DISCRETEMFG | |
| MOVE_TIME | NUMBER | Total time spent for Moving the stuffs in a Batch. | ||
| NO_ADJ | NUMBER | No of times the batch was adjusted. | ||
| NO_TIME_RESH | NUMBER | No of times the Job was rescheduled. | ||
| PLN_BPR_VAL_B | NUMBER | Plan By Product value from a Job, in Set of Books currency respectively.The cost will be calculated, as we did for Plan input value. | ||
| PLN_BPR_VAL_G | NUMBER | Plan By Product value from a Job, in Warehouse currency respectively.The cost will be calculated, as we did for Plan input value. | ||
| PLN_CMPL_DATE | DATE | Plan completion date of the Job | ||
| PLN_INP_VAL_B | NUMBER | Plan input (Ingredient and Component) value from a Job, in Set Of Books.This is the cost of all planned components used in the batch. | ||
| PLN_INP_VAL_G | NUMBER | Plan input (Ingredient and Component) value from a Job, in Warehouse currency .This is the cost of all planned components used in the batch. | ||
| PLN_JOB_TIME | NUMBER | Planned Job time | ||
| PLN_MTL_INP_VAL_B | NUMBER | Plan Material input value from a Job, in Set Of Books .This is the cost of all planned material components used in the batch. | ||
| PLN_MTL_INP_VAL_G | NUMBER | Plan Material input value from a Job, Warehouse currency .This is the cost of all planned material components used in the batch. | ||
| PLN_OUT_QTY | NUMBER | Planned Output Quantity | ||
| PLN_OUT_VAL_B | NUMBER | Planned Output value is SOB Currency | ||
| PLN_OUT_VAL_G | NUMBER | Planned Output value is Warehouse Currency | ||
| PLN_SCR_VAL_B | NUMBER | Plan Scrap value from a Job, in Set of Books currency respectively.The cost will be calculated, as we did for Plan input value. | ||
| PLN_SCR_VAL_G | NUMBER | Plan Scrap value from a Job, in Warehouse currency respectively.The cost will be calculated, as we did for Plan input value. | ||
| PLN_STRT_DATE | DATE | Plan Start date of the Job | ||
| PRD_LINE_FK_KEY | NUMBER | FK Key to Production Line Dimension - Production-Line level | ||
| QC_FAIL_QTY | NUMBER | QTY which failed in QC test. | ||
| QC_TEST | VARCHAR2 | (1) | Quality Tested (Y/N) | |
| QUEUE_TIME | NUMBER | Total time spent in the queue in a Batch. | ||
| RESH_REASON_CODE | VARCHAR2 | (240) | Reason for reschedule | |
| RES_LOOKUP_FK_KEY | NUMBER | FK Key to Lookup Dimension | ||
| REWORK_QTY | NUMBER | Rework Qty | ||
| ROUTING | VARCHAR2 | (240) | Routing Used by the Job | |
| ROUTING_VERSION | VARCHAR2 | (240) | Routing Revision/Version | |
| RUN_TIME | NUMBER | Total time spent for running the tasks in a Batch. | ||
| SETUP_TIME | NUMBER | Total time spent for setup of the tasks in a Batch. | ||
| SMPL_CNT | NUMBER | No of samples taken from the Job. | ||
| SOB_CURRENCY_FK_KEY | NUMBER | FK Key to Currency Dimension for SOB Currency. | ||
| STD_QTY | NUMBER | Standard Qty Defined for the Item produced by the Batch | ||
| STD_TIME | NUMBER | Standard Time Defined for the Item produced by the Batch | ||
| STD_VAL_B | NUMBER | Standard Value of the Item produced by the batch in SOB Currency | ||
| STD_VAL_G | NUMBER | Standard Value of the Item produced by the batch in Warehouse Currency | ||
| STS_LOOKUP_FK_KEY | NUMBER | FK Key to Lookup Dimension | ||
| TRX_DATE_FK_KEY | NUMBER | FK Key to Time Dimension - Calendar Day level | ||
| USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute1 | |
| USER_ATTRIBUTE10 | VARCHAR2 | (240) | User defined attribute10 | |
| USER_ATTRIBUTE11 | VARCHAR2 | (240) | User defined attribute11 | |
| USER_ATTRIBUTE12 | VARCHAR2 | (240) | User defined attribute12 | |
| USER_ATTRIBUTE13 | VARCHAR2 | (240) | User defined attribute13 | |
| USER_ATTRIBUTE14 | VARCHAR2 | (240) | User defined attribute14 | |
| USER_ATTRIBUTE15 | VARCHAR2 | (240) | User defined attribute15 | |
| USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute2 | |
| USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute3 | |
| USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute4 | |
| USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute5 | |
| USER_ATTRIBUTE6 | VARCHAR2 | (240) | User defined attribute6 | |
| USER_ATTRIBUTE7 | VARCHAR2 | (240) | User defined attribute7 | |
| USER_ATTRIBUTE8 | VARCHAR2 | (240) | User defined attribute8 | |
| USER_ATTRIBUTE9 | VARCHAR2 | (240) | User defined attribute9 | |
| USER_FK1_KEY | NUMBER | User defined foreign key1 | ||
| USER_FK2_KEY | NUMBER | User defined foreign key2 | ||
| USER_FK3_KEY | NUMBER | User defined foreign key3 | ||
| USER_FK4_KEY | NUMBER | User defined foreign key4 | ||
| USER_FK5_KEY | NUMBER | User defined foreign key5 | ||
| USER_MEASURE1 | NUMBER | User defined measure1 | ||
| USER_MEASURE2 | NUMBER | User defined measure2 | ||
| USER_MEASURE3 | NUMBER | User defined measure3 | ||
| USER_MEASURE4 | NUMBER | User defined measure4 | ||
| USER_MEASURE5 | NUMBER | User defined measure5 | ||
| STND_HRS_EARNED | NUMBER | Standard Hours Earned With Respect to Produced Qty |
Cut, paste (and edit) the following text to query this object:
SELECT ACT_BPR_VAL_B
, ACT_BPR_VAL_G
, ACT_CMPL_DATE
, ACT_CNCL_DATE
, ACT_INP_VAL_B
, ACT_INP_VAL_G
, ACT_JOB_TIME
, ACT_MTL_INP_VAL_B
, ACT_MTL_INP_VAL_G
, ACT_OUT_QTY
, ACT_OUT_VAL_B
, ACT_OUT_VAL_G
, ACT_SCR_VAL_B
, ACT_SCR_VAL_G
, ACT_STRT_DATE
, BASE_UOM_FK_KEY
, CREATION_DATE
, FST_PASS_YLD
, INSTANCE_FK_KEY
, ITEM_FK_KEY
, JOB_DETAIL_PK
, JOB_DETAIL_PK_KEY
, JOB_NO
, JOB_STATUS
, LAST_UPDATE_DATE
, LOCATOR_FK_KEY
, MFG_MODE
, MOVE_TIME
, NO_ADJ
, NO_TIME_RESH
, PLN_BPR_VAL_B
, PLN_BPR_VAL_G
, PLN_CMPL_DATE
, PLN_INP_VAL_B
, PLN_INP_VAL_G
, PLN_JOB_TIME
, PLN_MTL_INP_VAL_B
, PLN_MTL_INP_VAL_G
, PLN_OUT_QTY
, PLN_OUT_VAL_B
, PLN_OUT_VAL_G
, PLN_SCR_VAL_B
, PLN_SCR_VAL_G
, PLN_STRT_DATE
, PRD_LINE_FK_KEY
, QC_FAIL_QTY
, QC_TEST
, QUEUE_TIME
, RESH_REASON_CODE
, RES_LOOKUP_FK_KEY
, REWORK_QTY
, ROUTING
, ROUTING_VERSION
, RUN_TIME
, SETUP_TIME
, SMPL_CNT
, SOB_CURRENCY_FK_KEY
, STD_QTY
, STD_TIME
, STD_VAL_B
, STD_VAL_G
, STS_LOOKUP_FK_KEY
, TRX_DATE_FK_KEY
, USER_ATTRIBUTE1
, USER_ATTRIBUTE10
, USER_ATTRIBUTE11
, USER_ATTRIBUTE12
, USER_ATTRIBUTE13
, USER_ATTRIBUTE14
, USER_ATTRIBUTE15
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, USER_ATTRIBUTE6
, USER_ATTRIBUTE7
, USER_ATTRIBUTE8
, USER_ATTRIBUTE9
, USER_FK1_KEY
, USER_FK2_KEY
, USER_FK3_KEY
, USER_FK4_KEY
, USER_FK5_KEY
, USER_MEASURE1
, USER_MEASURE2
, USER_MEASURE3
, USER_MEASURE4
, USER_MEASURE5
, STND_HRS_EARNED
FROM OPI.OPI_EDW_JOB_DETAIL_F;
OPI.OPI_EDW_JOB_DETAIL_F does not reference any database object
OPI.OPI_EDW_JOB_DETAIL_F is referenced by following:
APPS
OPI_EDW_JOB_DETAIL_F
|
|
|
|