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

VIEW: APPS.OPI_EDW_OPI_JOB_DETAIL_FCV

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

View Type

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


OPI Job Detail Source View.


[View Source]

Columns
Name Datatype Length Mandatory Comments
VIEW_ID NUMBER

View Identifier.
SEQ_ID NUMBER

Incremental sequence Identifier.
JOB_DETAIL_PK VARCHAR2 (198)
Primary key have the structure of PRODTAG is OPI.
ACT_OUT_QTY NUMBER

Actual output quantity of the product from a job in primary UOM of the item.
PLN_OUT_QTY NUMBER

Plan 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 VARCHAR2 (0)
Actual output value of the product from a job in warehouse currency.
PLN_OUT_VAL_B NUMBER

Plan output value of the product from a job in functional currency.
PLN_OUT_VAL_G VARCHAR2 (0)
Plan output value of the product from a job in warehouse currency.
ACT_INP_VAL_B NUMBER

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

Plan input (ingredient and component) value from a job in functional currency.
PLN_INP_VAL_G NUMBER

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

Actual material input value from a job in functional currency.
ACT_MTL_INP_VAL_G VARCHAR2 (0)
Actual material input value from a job in warehouse currency.
PLN_MTL_INP_VAL_B NUMBER

Plan material input value from a job in functional currency.
PLN_MTL_INP_VAL_G VARCHAR2 (0)
Plan material input value from a job in warehouse currency.
ACT_SCR_VAL_B NUMBER

Actual scrap value from a job in functional currency.
ACT_SCR_VAL_G VARCHAR2 (0)
Actual scrap value from a job in warehouse currency.
PLN_SCR_VAL_B NUMBER

Plan scrap value from a job in functional currency.
PLN_SCR_VAL_G NUMBER

Plan scrap value from a job in warehouse currency.
ACT_BPR_VAL_B NUMBER

Actual by-product value from a job in functional currency.
ACT_BPR_VAL_G VARCHAR2 (0)
Actual by-product value from a job in warehouse currency.
PLN_BPR_VAL_B NUMBER

Plan by-product value from a job in functional currency.
PLN_BPR_VAL_G VARCHAR2 (0)
Plan by-product value from a job in warehouse currency.
STANDARD_QTY NUMBER

Standard quantity which can be produced in a standard time. This quantity is not influenced by individual BOM/Formula.
STD_VAL_B NUMBER

This is standard quantity multiplied by cost in functional currency.
STD_VAL_G VARCHAR2 (0)
This is standard quantity multiplied by cost in warehouse currency.
STD_TIME NUMBER

Standard time required to produce standard quantity This time is not influenced by individual routing.
ACT_JOB_TIME NUMBER

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

Difference between plan start and end time of the batch . To calculate this take the shop calendar into consideration.
JOB_NO VARCHAR2 (240)
Code for the job.
JOB_STATUS VARCHAR2 (80)
Status of a batch (Released, WIP, Certified, Closed, Canceled, Rescheduled ).
ACT_STRT_DATE DATE

Actual start date.
PLN_STRT_DATE DATE

Planned start date.
ACT_CMPL_DATE DATE

Actual completed date.
PLN_CMPL_DATE DATE

Planned completed date.
ACT_CNCL_DATE DATE

Actual cancelled date.
MFG_MODE VARCHAR2 (80)
Manufacturing Mode . The mode in which the job has been performed.
PRD_LINE_FK VARCHAR2 (116)
Foreign key on the production line dimension - production-line level.
ROUTING VARCHAR2 (40)
Routing used by the job.
ROUTING_REVISION VARCHAR2 (3)
Routing revision/version.
ITEM_FK VARCHAR2 (4000)
Foreign key on the item dimension - item-organization level.
BASE_UOM_FK VARCHAR2 (4000)
Foreign key on the unit of measure dimension.
TRX_DATE_FK VARCHAR2 (4000)
Foreign key on the time dimension - calendar day level.
LOCATOR_FK VARCHAR2 (39)
Foreign key on the new inventory location dimension - inventory org level for OPI.
SOB_CURRENCY_FK VARCHAR2 (4000)
Foreign key on the currency dimension for SOB currency.
INSTANCE_FK VARCHAR2 (30)
Foreign key on the instance dimension.
LAST_UPDATE_DATE DATE

Standard WHO column.
CREATION_DATE DATE

Standard WHO column.
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_FK1 VARCHAR2 (0)
User defined dimension foreign key.
USER_FK2 VARCHAR2 (0)
User defined dimension foreign key.
USER_FK3 VARCHAR2 (0)
User defined dimension foreign key.
USER_FK4 VARCHAR2 (0)
User defined dimension foreign key.
USER_FK5 VARCHAR2 (0)
User defined dimension foreign key.
USER_MEASURE1 VARCHAR2 (0)
User defined measure.
USER_MEASURE2 VARCHAR2 (0)
User defined measure.
USER_MEASURE3 VARCHAR2 (0)
User defined measure.
USER_MEASURE4 VARCHAR2 (0)
User defined measure.
USER_MEASURE5 VARCHAR2 (0)
User defined measure.
CONVERSION_RATE NUMBER

Conversion rate.
Query Text

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


SELECT VIEW_ID
,      SEQ_ID
,      JOB_DETAIL_PK
,      ACT_OUT_QTY
,      PLN_OUT_QTY
,      ACT_OUT_VAL_B
,      ACT_OUT_VAL_G
,      PLN_OUT_VAL_B
,      PLN_OUT_VAL_G
,      ACT_INP_VAL_B
,      ACT_INP_VAL_G
,      PLN_INP_VAL_B
,      PLN_INP_VAL_G
,      ACT_MTL_INP_VAL_B
,      ACT_MTL_INP_VAL_G
,      PLN_MTL_INP_VAL_B
,      PLN_MTL_INP_VAL_G
,      ACT_SCR_VAL_B
,      ACT_SCR_VAL_G
,      PLN_SCR_VAL_B
,      PLN_SCR_VAL_G
,      ACT_BPR_VAL_B
,      ACT_BPR_VAL_G
,      PLN_BPR_VAL_B
,      PLN_BPR_VAL_G
,      STANDARD_QTY
,      STD_VAL_B
,      STD_VAL_G
,      STD_TIME
,      ACT_JOB_TIME
,      PLN_JOB_TIME
,      JOB_NO
,      JOB_STATUS
,      ACT_STRT_DATE
,      PLN_STRT_DATE
,      ACT_CMPL_DATE
,      PLN_CMPL_DATE
,      ACT_CNCL_DATE
,      MFG_MODE
,      PRD_LINE_FK
,      ROUTING
,      ROUTING_REVISION
,      ITEM_FK
,      BASE_UOM_FK
,      TRX_DATE_FK
,      LOCATOR_FK
,      SOB_CURRENCY_FK
,      INSTANCE_FK
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      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_FK2
,      USER_FK3
,      USER_FK4
,      USER_FK5
,      USER_MEASURE1
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
,      CONVERSION_RATE
FROM APPS.OPI_EDW_OPI_JOB_DETAIL_FCV;

Dependencies

[top of page]

APPS.OPI_EDW_OPI_JOB_DETAIL_FCV references the following:

SchemaAPPS
SynonymBOM_CALENDAR_DATES
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
ViewGL_SETS_OF_BOOKS
SynonymHR_ORGANIZATION_INFORMATION
ViewMFG_LOOKUPS
SynonymMTL_CST_ACTUAL_COST_DETAILS
SynonymMTL_MATERIAL_TRANSACTIONS
SynonymMTL_MATERIAL_TXN_ALLOCATIONS
SynonymMTL_PARAMETERS
SynonymMTL_SYSTEM_ITEMS
SynonymOPI_EDW_OPI_JOB_DETAIL_INC
SynonymWIP_DISCRETE_JOBS
SynonymWIP_ENTITIES
SynonymWIP_FLOW_SCHEDULES
SynonymWIP_PERIOD_BALANCES
SynonymWIP_REPETITIVE_SCHEDULES
SynonymWIP_REQUIREMENT_OPERATIONS
SynonymWIP_SCRAP_VALUES
APPS.OPI_EDW_OPI_JOB_DETAIL_FCV is referenced by following:

SchemaAPPS
Package BodyOPI_EDW_OPI_JOB_DETAIL_F_C - show dependent code