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

VIEW: APPS.OPI_EDW_OPM_JOB_DETAIL_FCV

Object Details
Object Name: OPI_EDW_OPM_JOB_DETAIL_FCV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOPI.OPI_EDW_OPM_JOB_DETAIL_FCV
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Fact source view of Job Details for OPM extraction.


[View Source]

Columns
Name Datatype Length Mandatory Comments
JOB_DETAIL_PK VARCHAR2 (121)
Primary key have the structure of PRODTAG is OPI.
LOCATOR_FK VARCHAR2 (44)
Foreign key on the new inventory location dimension - inventory organization group level for OPM.
ITEM_FK VARCHAR2 (4000)
Foreign key on the item dimension - item-organization level.
PRD_LINE_FK CHAR (6)
Foreign key on the production line dimension - production-line level.
TRX_DATE_FK VARCHAR2 (120)
Foreign key on the time dimension - calendar day level.
SOB_CURRENCY_FK VARCHAR2 (4) Yes Foreign key on the currency dimension for SOB currency.
BASE_UOM_FK VARCHAR2 (4000)
Foreign key on the unit of measure 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_BPR_VAL_B NUMBER

Actual by-product value from a job in functional currency.
ACT_BPR_VAL_G NUMBER

Actual by-product value from a job in warehouse currency.
ACT_CMPL_DATE DATE

Actual completed date.
ACT_CNCL_DATE DATE

Actual cancelled date.
ACT_INP_VAL_B NUMBER

Actual input (ingredient and component) value from a job in functional currency.
ACT_INP_VAL_G NUMBER

Actual input (ingredient and component) value from a job in warehouse currency.
ACT_JOB_TIME NUMBER

Difference between start and end time of the batch . To calculate this to take the shop calendar into consideration.
ACT_MTL_INP_VAL_B NUMBER

Actual material input value from a job in functional currency.
ACT_MTL_INP_VAL_G NUMBER

Actual material input value from a job in warehouse currency.
ACT_OUT_QTY NUMBER
Yes Actual output quantity of the product from a job in primary UOM of the item.
ACT_OUT_VAL_B NUMBER

Actual output value of the product from a job in functional currency.
ACT_OUT_VAL_G NUMBER

Actual output value of the product from a job in warehouse currency.
ACT_SCR_VAL_B NUMBER

Actual scrap value from a job in functional currency.
ACT_SCR_VAL_G NUMBER

Actual scrap value from a job in warehouse currency.
ACT_STRT_DATE DATE

Actual start date.
CREATION_DATE DATE
Yes Standard WHO column.
FST_PASS_YLD NUMBER

First pass yield quantity. Used mainly by flow manufacturing.
JOB_NO VARCHAR2 (32) Yes Code for the job.
JOB_STATUS VARCHAR2 (80) Yes Status of a batch (Released, WIP, Certified, Closed, Canceled, Rescheduled ).
LAST_UPDATE_DATE DATE

Standard WHO column.
MFG_MODE CHAR (21)
Manufacturing mode . The mode in which the job has been performed.
MOVE_TIME VARCHAR2 (0)
Total time spent for moving the stuff in a batch.
NO_ADJ NUMBER

No of times the batch was adjusted.
NO_TIME_RESH VARCHAR2 (0)
No of times the job was rescheduled.
PLN_BPR_VAL_B NUMBER

Plan by-product value from a job in set of books.
PLN_BPR_VAL_G NUMBER

Plan by-product value from a job in warehouse currency.
PLN_CMPL_DATE DATE

Planned completed date.
PLN_INP_VAL_B NUMBER

Plan input (ingredient and component) value from a job in set of books.
PLN_INP_VAL_G NUMBER

Plan input (ingredient and component) value from a job in warehouse currency.
PLN_JOB_TIME NUMBER

Planned job time.
PLN_MTL_INP_VAL_B NUMBER

Plan material input value from a job in set of books.
PLN_MTL_INP_VAL_G NUMBER

Plan material input value from a job in warehouse currency.
PLN_OUT_QTY NUMBER
Yes Plan output quantity of the product from a job in primary UOM of the item.
PLN_OUT_VAL_B NUMBER

Plan output value of the product from a job in set of books.
PLN_OUT_VAL_G NUMBER

Plan output value of the product from a job in warehouse currency.
PLN_SCR_VAL_B VARCHAR2 (0)
Plan scrap value from a job in set of books.
PLN_SCR_VAL_G VARCHAR2 (0)
Plan scrap value from a job in warehouse currency.
PLN_STRT_DATE DATE

Planned start date.
QC_FAIL_QTY VARCHAR2 (0)
Quantity which failed in QC test.
QC_TEST VARCHAR2 (1)
Quality tested (Y/N).
QUEUE_TIME VARCHAR2 (0)
Total time spent in the queue in a batch.
RESH_REASON_CODE VARCHAR2 (0)
Reason for reschedule.
RES_LOOKUP_FK CHAR (6)
Foreign key on the lookup dimension.
REWORK_QTY VARCHAR2 (0)
Rework quantity.
ROUTING VARCHAR2 (32)
Routing used by the job.
ROUTING_REVISION VARCHAR2 (40)
Routing Revision/Version.
RUN_TIME VARCHAR2 (0)
Total time spent for running the tasks in a batch.
SETUP_TIME VARCHAR2 (0)
Total time spent for setup of the tasks in a batch.
SMPL_CNT NUMBER

Count of samples taken from the job.
STD_QTY NUMBER

Standard quantity.
STD_TIME NUMBER

Standard time.
STD_VAL_B NUMBER

This is standard quantity multiplied by cost in set of books.
STD_VAL_G NUMBER

This is standard quantity multiplied by cost in warehouse currency.
STS_LOOKUP_FK VARCHAR2 (57)
Foreign key to lookup dimension.
USER_ATTRIBUTE1 VARCHAR2 (0)
User Defined Attribute1.
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.
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_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.
SEQ_ID NUMBER

Incremental sequence Identifier.
VIEW_ID NUMBER

View Identifier.
STND_HRS_EARNED NUMBER

Standard hours earned with respect to produced quantity.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT JOB_DETAIL_PK
,      LOCATOR_FK
,      ITEM_FK
,      PRD_LINE_FK
,      TRX_DATE_FK
,      SOB_CURRENCY_FK
,      BASE_UOM_FK
,      INSTANCE_FK
,      USER_FK1
,      USER_FK2
,      USER_FK3
,      USER_FK4
,      USER_FK5
,      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
,      CREATION_DATE
,      FST_PASS_YLD
,      JOB_NO
,      JOB_STATUS
,      LAST_UPDATE_DATE
,      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
,      QC_FAIL_QTY
,      QC_TEST
,      QUEUE_TIME
,      RESH_REASON_CODE
,      RES_LOOKUP_FK
,      REWORK_QTY
,      ROUTING
,      ROUTING_REVISION
,      RUN_TIME
,      SETUP_TIME
,      SMPL_CNT
,      STD_QTY
,      STD_TIME
,      STD_VAL_B
,      STD_VAL_G
,      STS_LOOKUP_FK
,      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_MEASURE1
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
,      SEQ_ID
,      VIEW_ID
,      STND_HRS_EARNED
FROM APPS.OPI_EDW_OPM_JOB_DETAIL_FCV;

Dependencies

[top of page]

APPS.OPI_EDW_OPM_JOB_DETAIL_FCV references the following:

SchemaAPPS
PL/SQL PackageEDW_CURRENCY - show dependent code
PL/SQL PackageEDW_ITEMS_PKG - show dependent code
SynonymEDW_LOCAL_INSTANCE
PL/SQL PackageEDW_TIME_PKG - show dependent code
PL/SQL PackageEDW_UTIL - show dependent code
SynonymFM_ROUT_HDR
ViewGEM_LOOKUPS
SynonymGL_PLCY_MST
ViewGL_SETS_OF_BOOKS
PL/SQL PackageGMICUOM - show dependent code
SynonymIC_ITEM_MST
SynonymIC_PLNT_INV
SynonymIC_WHSE_MST
SynonymMTL_SYSTEM_ITEMS
SynonymOPI_EDW_OPM_JOB_DETAIL_INC
PL/SQL PackageOPI_EDW_OPM_PRD_PKG - show dependent code
PL/SQL PackageOPI_OPM_COMMON_PKG - show dependent code
SynonymOPI_PMI_UOMS_MST
SynonymPM_BTCH_HDR
SynonymPM_MATL_DTL
SynonymSY_ORGN_MST
APPS.OPI_EDW_OPM_JOB_DETAIL_FCV is referenced by following:

SchemaAPPS
Package BodyOPI_EDW_OPM_JOB_DETAIL_F_C - show dependent code