VIEW: WIP.WIP_BIS_PROD_INDICATORS#

Source

View Text - Preformatted

select SET_OF_BOOKS_ID SET_OF_BOOKS_ID, SET_OF_BOOKS_NAME SET_OF_BOOKS_NAME, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, LEGAL_ENTITY_NAME LEGAL_ENTITY_NAME, OPERATING_UNIT_ID OPERATING_UNIT_ID, OPERATING_UNIT_NAME OPERATING_UNIT_NAME, ORGANIZATION_ID ORGANIZATION_ID, ORGANIZATION_NAME ORGANIZATION_NAME, DEPARTMENT_ID DEPARTMENT_ID, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, DEPARTMENT_CODE DEPARTMENT_CODE, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, RESOURCE_ID RESOURCE_ID, RESOURCE_CODE RESOURCE_CODE, LOCATION_ID LOCATION_ID, AREA_CODE AREA_CODE, AREA_NAME AREA_NAME, COUNTRY_CODE COUNTRY_CODE, COUNTRY_NAME COUNTRY_NAME, REGION_CODE REGION_CODE, REGION_NAME REGION_NAME, CATEGORY_ID CATEGORY_ID, CATEGORY_NAME CATEGORY_NAME, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, INVENTORY_ITEM_NAME INVENTORY_ITEM_NAME, PERIOD_SET_NAME PERIOD_SET_NAME, WIP_ENTITY_ID WIP_ENTITY_ID, TRANSACTION_DATE TRANSACTION_DATE, YEAR YEAR, QUARTER QUARTER, MONTH MONTH, OPERATION_SEQ_NUM OPERATION_SEQ_NUM, TOTAL_QUANTITY TOTAL_QUANTITY, SCRAP_QUANTITY SCRAP_QUANTITY, STANDARD_HOURS STANDARD_HOURS, APPLIED_HOURS_PRD APPLIED_HOURS_PRD, APPLIED_HOURS_UTZ APPLIED_HOURS_UTZ, AVAILABLE_HOURS AVAILABLE_HOURS, EXISTING_FLAG EXISTING_FLAG, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_ID PROGRAM_ID, INDICATOR_TYPE INDICATOR_TYPE, SHARE_FROM_DEPT_ID SHARE_FROM_DEPT_ID from "WIP"."WIP_BIS_PROD_INDICATORS"

View Text - HTML Formatted

SELECT SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, SET_OF_BOOKS_NAME SET_OF_BOOKS_NAME
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, LEGAL_ENTITY_NAME LEGAL_ENTITY_NAME
, OPERATING_UNIT_ID OPERATING_UNIT_ID
, OPERATING_UNIT_NAME OPERATING_UNIT_NAME
, ORGANIZATION_ID ORGANIZATION_ID
, ORGANIZATION_NAME ORGANIZATION_NAME
, DEPARTMENT_ID DEPARTMENT_ID
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, DEPARTMENT_CODE DEPARTMENT_CODE
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, RESOURCE_ID RESOURCE_ID
, RESOURCE_CODE RESOURCE_CODE
, LOCATION_ID LOCATION_ID
, AREA_CODE AREA_CODE
, AREA_NAME AREA_NAME
, COUNTRY_CODE COUNTRY_CODE
, COUNTRY_NAME COUNTRY_NAME
, REGION_CODE REGION_CODE
, REGION_NAME REGION_NAME
, CATEGORY_ID CATEGORY_ID
, CATEGORY_NAME CATEGORY_NAME
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, INVENTORY_ITEM_NAME INVENTORY_ITEM_NAME
, PERIOD_SET_NAME PERIOD_SET_NAME
, WIP_ENTITY_ID WIP_ENTITY_ID
, TRANSACTION_DATE TRANSACTION_DATE
, YEAR YEAR
, QUARTER QUARTER
, MONTH MONTH
, OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, TOTAL_QUANTITY TOTAL_QUANTITY
, SCRAP_QUANTITY SCRAP_QUANTITY
, STANDARD_HOURS STANDARD_HOURS
, APPLIED_HOURS_PRD APPLIED_HOURS_PRD
, APPLIED_HOURS_UTZ APPLIED_HOURS_UTZ
, AVAILABLE_HOURS AVAILABLE_HOURS
, EXISTING_FLAG EXISTING_FLAG
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_ID PROGRAM_ID
, INDICATOR_TYPE INDICATOR_TYPE
, SHARE_FROM_DEPT_ID SHARE_FROM_DEPT_ID
FROM "WIP"."WIP_BIS_PROD_INDICATORS"