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

TABLE: OPI.OPI_EDW_JOB_DETAIL_FSTG

Object Details
Object Name: OPI_EDW_JOB_DETAIL_FSTG
Object Type: TABLE
Owner: OPI
FND Design Data: TableOPI.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


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
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 PRODTAG is either OPM or OPI depending on whether OPM or OPI extracted the row.In case of OPM, The ORG_ID is the Process Organization which may be different
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
Query Text

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;

Dependencies

[top of page]

OPI.OPI_EDW_JOB_DETAIL_FSTG does not reference any database object

OPI.OPI_EDW_JOB_DETAIL_FSTG is referenced by following:

SchemaAPPS
SynonymOPI_EDW_JOB_DETAIL_FSTG