eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: WIP.WIP_OPERATION_YIELDS

Object Details

Object Name:	WIP_OPERATION_YIELDS
Object Type:	TABLE
Owner:	WIP
FND Design Data:	WIP.WIP_OPERATION_YIELDS
Subobject Name:
Status:	VALID

This table keeps all costing information for operation yield costing. This table will have one to one relationship with WIP Periodic balance table. This table has one row for each operation of WSM job. Column applied cost will hold cost applied to an operation in WSM job. Rows will be inserted to this table at the time of creation of WSM job and at the time of creation of an operation of WSM job in Move Transaction Form.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WIP_OPERATION_YIELDS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	WIP_ENTITY_ID ORGANIZATION_ID OPERATION_SEQ_NUM

Columns

Name	Datatype	Length	Mandatory	Comments
WIP_ENTITY_ID	NUMBER	(15)	Yes	WIP job identifier
OPERATION_SEQ_NUM	NUMBER	(15)	Yes	Operation sequence number within a routing
ORGANIZATION_ID	NUMBER	(15)	Yes	Organization Identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
REQUEST_ID	NUMBER			Standard Who column
PROGRAM_APPLICATION_ID	NUMBER			Standard Who column
PROGRAM_ID	NUMBER			Standard Who column
PROGRAM_UPDATE_DATE	DATE			Standard Who column
OPERATION_COST	NUMBER			Total cost applied to an operation
OPERATION_UNIT_COST	NUMBER			Unit cost applied at the operation
CUM_OPERATION_UNIT_COST	NUMBER			Cumulative unit cost applied till the operation
EST_SCRAP_UNIT_COST	NUMBER			Estimated Scrap unit cost at the operation. This is to be used for calculation of operation yield cost at the operation
CUM_EST_PRIOR_UNIT_COST	NUMBER			Cumulative total of Estimated Scrap unit cost till previous operation. This is to be used for calculation of operation yield cost at the operation
EST_SCRAP_QTY_COMPLETED	NUMBER			Estimated quantity completed at the operation. This is to be used for calculation of operation yield cost at the operation
EST_SCRAP_QTY_SCRAPED	NUMBER			Estimated quantity scrapped at the operation. This is to be used for calculation of operation yield cost at the operation
SCRAP_ACCOUNT	NUMBER			Scrap Account for the operation
EST_SCRAP_ABSORB_ACCOUNT	NUMBER			Estimated Scrap Absorption Account for the operation
STATUS	NUMBER			Operation yield processing status
QUANTITY_COMPLETED	NUMBER			Quantity completed
QUANTITY_SCRAPPED	NUMBER			Quantity scrapped

Query Text

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


SELECT WIP_ENTITY_ID
,      OPERATION_SEQ_NUM
,      ORGANIZATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      OPERATION_COST
,      OPERATION_UNIT_COST
,      CUM_OPERATION_UNIT_COST
,      EST_SCRAP_UNIT_COST
,      CUM_EST_PRIOR_UNIT_COST
,      EST_SCRAP_QTY_COMPLETED
,      EST_SCRAP_QTY_SCRAPED
,      SCRAP_ACCOUNT
,      EST_SCRAP_ABSORB_ACCOUNT
,      STATUS
,      QUANTITY_COMPLETED
,      QUANTITY_SCRAPPED
FROM WIP.WIP_OPERATION_YIELDS;

Dependencies

[top of page]

WIP.WIP_OPERATION_YIELDS does not reference any database object

WIP.WIP_OPERATION_YIELDS is referenced by following:

APPS: WIP_OPERATION_YIELDS