View: WIP_BIS_PROD_ASSY_YIELD_V

Product:	WIP - Work in Process
Description:	Total/Scrapped quantity at specific organization/date
Implementation/DBA Data:	APPS.WIP_BIS_PROD_ASSY_YIELD_V

View Text

SELECT WBPAY.SET_OF_BOOKS_ID
, WBPAY.SET_OF_BOOKS_NAME
, WBPAY.LEGAL_ENTITY_ID
, WBPAY.LEGAL_ENTITY_NAME
, WBPAY.OPERATING_UNIT_ID
, WBPAY.OPERATING_UNIT_NAME
, WBPAY.ORGANIZATION_ID
, WBPAY.ORGANIZATION_NAME
, WBPAY.WIP_ENTITY_ID
, WBPAY.CATEGORY_ID
, WBPAY.CATEGORY_NAME
, WBPAY.INVENTORY_ITEM_ID
, WBPAY.INVENTORY_ITEM_NAME
, WBPAY.LOCATION_ID
, WBPAY.AREA_CODE
, WBPAY.AREA_NAME
, WBPAY.COUNTRY_CODE
, WBPAY.COUNTRY_NAME
, WBPAY.REGION_CODE
, WBPAY.REGION_NAME
, WBPAY.TRANSACTION_DATE
, WBPAY.PERIOD_SET_NAME
, WBPAY.YEAR
, WBPAY.QUARTER
, WBPAY.MONTH
, SUM(WBPAY.COMPLETED_QUANTITY) COMPLETED_QUANTITY
, SUM(WBPAY.SCRAP_QUANTITY) SCRAP_QUANTITY
, SUM(WBPAY.COMPLETED_QUANTITY)+SUM(WBPAY.SCRAP_QUANTITY) TOTAL_QUANTITY
FROM WIP_BIS_PROD_ASSY_YIELD WBPAY
WHERE WBPAY.EXISTING_FLAG = 1 GROUP BY WBPAY.SET_OF_BOOKS_ID
, WBPAY.SET_OF_BOOKS_NAME
, WBPAY.LEGAL_ENTITY_ID
, WBPAY.LEGAL_ENTITY_NAME
, WBPAY.OPERATING_UNIT_ID
, WBPAY.OPERATING_UNIT_NAME
, WBPAY.ORGANIZATION_ID
, WBPAY.ORGANIZATION_NAME
, WBPAY.WIP_ENTITY_ID
, WBPAY.CATEGORY_ID
, WBPAY.CATEGORY_NAME
, WBPAY.INVENTORY_ITEM_ID
, WBPAY.INVENTORY_ITEM_NAME
, WBPAY.LOCATION_ID
, WBPAY.AREA_CODE
, WBPAY.AREA_NAME
, WBPAY.COUNTRY_CODE
, WBPAY.COUNTRY_NAME
, WBPAY.REGION_CODE
, WBPAY.REGION_NAME
, WBPAY.TRANSACTION_DATE
, WBPAY.PERIOD_SET_NAME
, WBPAY.YEAR
, WBPAY.QUARTER
, WBPAY.MONTH

Columns