[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OPI_EDW_JOB_DETAIL_FSTG |
|---|---|
| Object Type: | TABLE |
| Owner: | OPI |
| FND Design Data: |  OPI.OPI_EDW_JOB_DETAIL_FSTG
|
| Subobject Name: | |
| Status: | VALID |
Job Detail Fact Staging Table Sourced from the Fllowing Views OPI_EDW_OPM_JOB_DETAIL_FCV and OPI_EDW_OPI_JOB_DETAILS_FCV
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| 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.As OPM follows Periodic Cost | ||
| 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. As OPM follows Periodic Costing method, we will take the cost as of batch completion date. | ||
| 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. As OPM follows Periodic Costing method, we will take the cost as of job completion date. | ||
| ACT_JOB_TIME | NUMBER | Total Time Taken for the Job to complete (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 components used in the batch. As OPM follows Periodic Costing method, we will take the cost as of batch completion date. | ||
| ACT_MTL_INP_VAL_G | NUMBER | Actual Material input value from a Job, in Warehouse currency .This is the cost of all components used in the batch. As OPM follows Periodic Costing method, we will take the cost as of batch completion date. | ||
| ACT_OUT_QTY | NUMBER | Actual Qty Produced by the job | ||
| ACT_OUT_VAL_B | NUMBER | Actual Output Value of job calculated as Unit cost * Qty Produced | ||
| ACT_OUT_VAL_G | NUMBER | Actual Output Value of job calculated as Unit cost * Qty Produced 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. As OPM follows Periodic Costing method, we will take the cost as of batch completion date. | ||
| ACT_SCR_VAL_G | NUMBER | Actual Scrap value from a Job, Warehouse currency.This is the cost of all scraps produced from the batch. As OPM follows Periodic Costing method, we will take the cost as of batch completion date. | ||
| ACT_STRT_DATE | DATE | Actual Start date of the Job | ||
| BASE_UOM_FK | VARCHAR2 | (80) | FK to Unit Of Measure Dimension | |
| BASE_UOM_FK_KEY | NUMBER | FK Key to Unit Of Measure Dimension | ||
| COLLECTION_DATE | DATE | Date populated by the Collection engine | ||
| COLLECTION_STATUS | VARCHAR2 | (30) | Status of collection of current row | |
| CREATION_DATE | DATE | Who column | ||
| ERROR_CODE | VARCHAR2 | (2000) | Concatenation of all the error messages that the current row encountered during collection | |
| FST_PASS_YLD | NUMBER | First Pass Yield Qty. Used mainly by Flow manufacturing. | ||
| INSTANCE_FK | VARCHAR2 | (80) | FK to Instance Dimension | |
| INSTANCE_FK_KEY | NUMBER | FK Key to Instance Dimension | ||
| ITEM_FK | VARCHAR2 | (240) | FK to Item Dimension - Item-Org level | |
| ITEM_FK_KEY | NUMBER | FK Key to Item Dimension - Item-Org level | ||
| JOB_DETAIL_PK | VARCHAR2 | (240) | User defined Primary Key. This will have the structure of | |
| JOB_DETAIL_PK_KEY | NUMBER | System Generater Primary Key | ||
| JOB_NO | VARCHAR2 | (80) | Job Number . Batch Number for OPM | |
| JOB_STATUS | VARCHAR2 | (40) | Status of a batch (Released, WIP, Certified, Closed, Canceled, Rescheduled ) | |
| LAST_UPDATE_DATE | DATE | Who Column | ||
| LOCATOR_FK | VARCHAR2 | (240) | FK to new Inventory Location Dimension - Inventory Org group level for OPM and Inventory Org Level for OPI | |
| 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. | ||
| OPERATION_CODE | VARCHAR2 | (30) | DELETE for the rows that are marked for deletion, blank otherwise | |
| 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 (in Days) | ||
| 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 components used in the batch. As discrete mfg. follows transaction level costing, we will take the same cost what was applied for Ac | ||
| PLN_OUT_QTY | NUMBER | Planned Output Qty | ||
| PLN_OUT_VAL_B | NUMBER | Planned Output Value in Set of Books Currency | ||
| PLN_OUT_VAL_G | NUMBER | Planned Output Value in 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 | VARCHAR2 | (240) | FK to Production Line Dimension - Production-Line level | |
| 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. | ||
| REQUEST_ID | NUMBER | Request Id of the concurrent program that is processing the rows | ||
| RESH_REASON_CODE | VARCHAR2 | (40) | Reason for reschedule | |
| RES_LOOKUP_FK | VARCHAR2 | (240) | FK to Lookup Dimension | |
| RES_LOOKUP_FK_KEY | NUMBER | FK Key to Lookup Dimension | ||
| REWORK_QTY | NUMBER | Rework Qty | ||
| ROUTING | VARCHAR2 | (240) | Routing Used by the Job | |
| ROUTING_REVISION | VARCHAR2 | (240) | Routing Revision/Version | |
| ROW_ID | VARCHAR2 | (30) | Used by the collection engine | |
| 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 | VARCHAR2 | (80) | FK to Currency Dimension for SOB Currency. | |
| 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 Job | ||
| STD_TIME | NUMBER | Standard production time defined for the Item produced by the Job | ||
| STD_VAL_B | NUMBER | Standard value of the Item produced by the Job (Standard Qty * Unit Cost) in SOB Currency | ||
| STD_VAL_G | NUMBER | Standard value of the Item produced by the Job (Standard Qty * Unit Cost) in Warehouse Currency | ||
| STS_LOOKUP_FK | VARCHAR2 | (240) | FK to Lookup Dimension | |
| STS_LOOKUP_FK_KEY | NUMBER | FK Key to Lookup Dimension | ||
| TRX_DATE_FK | VARCHAR2 | (80) | FK to Time Dimension - Calendar Day level | |
| TRX_DATE_FK_KEY | NUMBER | FK Key to Time Dimension - Calendar Day level | ||
| USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute | |
| USER_ATTRIBUTE10 | VARCHAR2 | (240) | User defined attribute | |
| USER_ATTRIBUTE11 | VARCHAR2 | (240) | User defined attribute | |
| USER_ATTRIBUTE12 | VARCHAR2 | (240) | User defined attribute | |
| USER_ATTRIBUTE13 | VARCHAR2 | (240) | User defined attribute | |
| USER_ATTRIBUTE14 | VARCHAR2 | (240) | User defined attribute | |
| USER_ATTRIBUTE15 | VARCHAR2 | (240) | User defined attribute | |
| USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute | |
| USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute | |
| USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute | |
| USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute | |
| USER_ATTRIBUTE6 | VARCHAR2 | (240) | User defined attribute | |
| USER_ATTRIBUTE7 | VARCHAR2 | (240) | User defined attribute | |
| USER_ATTRIBUTE8 | VARCHAR2 | (240) | User defined attribute | |
| USER_ATTRIBUTE9 | VARCHAR2 | (240) | User defined attribute | |
| USER_FK1 | VARCHAR2 | (240) | User defined foreign key | |
| USER_FK1_KEY | NUMBER | User defined foreign key | ||
| USER_FK2 | VARCHAR2 | (240) | User defined foreign key | |
| USER_FK2_KEY | NUMBER | User defined foreign key | ||
| USER_FK3 | VARCHAR2 | (240) | User defined foreign key | |
| USER_FK3_KEY | NUMBER | User defined foreign key | ||
| USER_FK4 | VARCHAR2 | (240) | User defined foreign key | |
| USER_FK4_KEY | NUMBER | User defined foreign key | ||
| USER_FK5 | VARCHAR2 | (240) | User defined foreign key | |
| USER_FK5_KEY | NUMBER | User defined foreign key | ||
| 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 | ||
| 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
, BASE_UOM_FK_KEY
, COLLECTION_DATE
, COLLECTION_STATUS
, CREATION_DATE
, ERROR_CODE
, FST_PASS_YLD
, INSTANCE_FK
, INSTANCE_FK_KEY
, ITEM_FK
, ITEM_FK_KEY
, JOB_DETAIL_PK
, JOB_DETAIL_PK_KEY
, JOB_NO
, JOB_STATUS
, LAST_UPDATE_DATE
, LOCATOR_FK
, LOCATOR_FK_KEY
, MFG_MODE
, MOVE_TIME
, NO_ADJ
, NO_TIME_RESH
, OPERATION_CODE
, 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
, PRD_LINE_FK_KEY
, QC_FAIL_QTY
, QC_TEST
, QUEUE_TIME
, REQUEST_ID
, RESH_REASON_CODE
, RES_LOOKUP_FK
, RES_LOOKUP_FK_KEY
, REWORK_QTY
, ROUTING
, ROUTING_REVISION
, ROW_ID
, RUN_TIME
, SETUP_TIME
, SMPL_CNT
, SOB_CURRENCY_FK
, SOB_CURRENCY_FK_KEY
, STD_QTY
, STD_TIME
, STD_VAL_B
, STD_VAL_G
, STS_LOOKUP_FK
, STS_LOOKUP_FK_KEY
, TRX_DATE_FK
, 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
, USER_FK1_KEY
, USER_FK2
, USER_FK2_KEY
, USER_FK3
, USER_FK3_KEY
, USER_FK4
, USER_FK4_KEY
, USER_FK5
, USER_FK5_KEY
, USER_MEASURE1
, USER_MEASURE2
, USER_MEASURE3
, USER_MEASURE4
, USER_MEASURE5
, STND_HRS_EARNED
FROM OPI.OPI_EDW_JOB_DETAIL_FSTG;
OPI.OPI_EDW_JOB_DETAIL_FSTG does not reference any database object
OPI.OPI_EDW_JOB_DETAIL_FSTG is referenced by following:
APPS
OPI_EDW_JOB_DETAIL_FSTG
|
|
|
|