VIEW: APPS.WIP_BIS_UTZ_CATNOITEM_V

Source

View Text - Preformatted

SELECT SET_OF_BOOKS_ID , SET_OF_BOOKS_NAME , LEGAL_ENTITY_ID , LEGAL_ENTITY_NAME , OPERATING_UNIT_ID , OPERATING_UNIT_NAME , ORGANIZATION_ID , ORGANIZATION_NAME , DEPARTMENT_ID , DEPARTMENT_CODE , RESOURCE_ID , RESOURCE_CODE , LOCATION_ID , AREA_CODE , AREA_NAME , COUNTRY_CODE , COUNTRY_NAME , REGION_CODE , REGION_NAME , TRANSACTION_DATE , CATEGORY_ID , CATEGORY_NAME , SUM(NVL(APPLIED_HOURS_UTZ,0)) , AVAILABLE_HOURS , PERIOD_SET_NAME , YEAR , QUARTER , MONTH FROM WIP_BIS_PROD_INDICATORS WHERE EXISTING_FLAG = 1 GROUP BY SET_OF_BOOKS_ID , SET_OF_BOOKS_NAME , LEGAL_ENTITY_ID , LEGAL_ENTITY_NAME , OPERATING_UNIT_ID , OPERATING_UNIT_NAME , ORGANIZATION_ID , ORGANIZATION_NAME , DEPARTMENT_ID , DEPARTMENT_CODE , RESOURCE_ID , RESOURCE_CODE , LOCATION_ID , AREA_CODE , AREA_NAME , COUNTRY_CODE , COUNTRY_NAME , REGION_CODE , REGION_NAME , TRANSACTION_DATE , CATEGORY_ID , CATEGORY_NAME , AVAILABLE_HOURS , PERIOD_SET_NAME , YEAR , QUARTER , MONTH

View Text - HTML Formatted

SELECT SET_OF_BOOKS_ID
, SET_OF_BOOKS_NAME
, LEGAL_ENTITY_ID
, LEGAL_ENTITY_NAME
, OPERATING_UNIT_ID
, OPERATING_UNIT_NAME
, ORGANIZATION_ID
, ORGANIZATION_NAME
, DEPARTMENT_ID
, DEPARTMENT_CODE
, RESOURCE_ID
, RESOURCE_CODE
, LOCATION_ID
, AREA_CODE
, AREA_NAME
, COUNTRY_CODE
, COUNTRY_NAME
, REGION_CODE
, REGION_NAME
, TRANSACTION_DATE
, CATEGORY_ID
, CATEGORY_NAME
, SUM(NVL(APPLIED_HOURS_UTZ
, 0))
, AVAILABLE_HOURS
, PERIOD_SET_NAME
, YEAR
, QUARTER
, MONTH
FROM WIP_BIS_PROD_INDICATORS
WHERE EXISTING_FLAG = 1 GROUP BY SET_OF_BOOKS_ID
, SET_OF_BOOKS_NAME
, LEGAL_ENTITY_ID
, LEGAL_ENTITY_NAME
, OPERATING_UNIT_ID
, OPERATING_UNIT_NAME
, ORGANIZATION_ID
, ORGANIZATION_NAME
, DEPARTMENT_ID
, DEPARTMENT_CODE
, RESOURCE_ID
, RESOURCE_CODE
, LOCATION_ID
, AREA_CODE
, AREA_NAME
, COUNTRY_CODE
, COUNTRY_NAME
, REGION_CODE
, REGION_NAME
, TRANSACTION_DATE
, CATEGORY_ID
, CATEGORY_NAME
, AVAILABLE_HOURS
, PERIOD_SET_NAME
, YEAR
, QUARTER
, MONTH