Product: | WIP - Work in Process |
---|---|
Description: | Completed/Scrapped quantity for department/operation/date |
Implementation/DBA Data: | APPS.WIP_BIS_PROD_DEPT_YIELD_V |
SELECT WBY.SET_OF_BOOKS_ID
, WBY.SET_OF_BOOKS_NAME
, WBY.LEGAL_ENTITY_ID
, WBY.LEGAL_ENTITY_NAME
, WBY.OPERATING_UNIT_ID
, WBY.OPERATING_UNIT_NAME
, WBY.ORGANIZATION_ID
, WBY.ORGANIZATION_NAME
, WBY.DEPARTMENT_ID
, WBY.DEPARTMENT_CODE
, WBY.LOCATION_ID
, WBY.AREA_CODE
, WBY.AREA_NAME
, WBY.COUNTRY_CODE
, WBY.COUNTRY_NAME
, WBY.REGION_CODE
, WBY.REGION_NAME
, WBY.TRANSACTION_DATE
, WBY.PERIOD_SET_NAME
, WBY.YEAR
, WBY.QUARTER
, WBY.MONTH
, SUM(NVL(WBY.TOTAL_QUANTITY
, 0)) "TOTAL_QUANTITY"
, SUM(NVL(WBY.SCRAP_QUANTITY
, 0)) "SCRAPPED_QUANTITY"
FROM WIP_BIS_PROD_DEPT_YIELD WBY
WHERE WBY.EXISTING_FLAG = 1
AND WBY.TOTAL_QUANTITY IS NOT NULL GROUP BY WBY.SET_OF_BOOKS_ID
, WBY.SET_OF_BOOKS_NAME
, WBY.LEGAL_ENTITY_ID
, WBY.LEGAL_ENTITY_NAME
, WBY.OPERATING_UNIT_ID
, WBY.OPERATING_UNIT_NAME
, WBY.ORGANIZATION_ID
, WBY.ORGANIZATION_NAME
, WBY.DEPARTMENT_ID
, WBY.DEPARTMENT_CODE
, WBY.LOCATION_ID
, WBY.AREA_CODE
, WBY.AREA_NAME
, WBY.COUNTRY_CODE
, WBY.COUNTRY_NAME
, WBY.REGION_CODE
, WBY.REGION_NAME
, WBY.TRANSACTION_DATE
, WBY.PERIOD_SET_NAME
, WBY.YEAR
, WBY.QUARTER
, WBY.MONTH