VIEW: WIP.WIP_OPERATION_YIELDS#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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