View: WIP_BIS_UTZ_CAT_V

Product:	WIP - Work in Process
Description:	Resource Utilization with Product Category and Inventory Item
Implementation/DBA Data:	APPS.WIP_BIS_UTZ_CAT_V

View Text

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
, INVENTORY_ITEM_ID
, INVENTORY_ITEM_NAME
, NVL(APPLIED_HOURS_UTZ
, 0)
, AVAILABLE_HOURS
, PERIOD_SET_NAME
, YEAR
, QUARTER
, MONTH
FROM WIP_BIS_PROD_INDICATORS
WHERE EXISTING_FLAG = 1

Columns