VIEW: APPS.WIP_BIS_PROD_ASSY_YIELD_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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