VIEW: WIP.WIP_BIS_PROD_DEPT_YIELD#

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, DEPARTMENT_CODE DEPARTMENT_CODE, WIP_ENTITY_ID WIP_ENTITY_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, OPERATION_SEQ_NUM OPERATION_SEQ_NUM, 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, TRANSACTION_DATE TRANSACTION_DATE, PERIOD_SET_NAME PERIOD_SET_NAME, YEAR YEAR, QUARTER QUARTER, MONTH MONTH, TOTAL_QUANTITY TOTAL_QUANTITY, SCRAP_QUANTITY SCRAP_QUANTITY, 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, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE from "WIP"."WIP_BIS_PROD_DEPT_YIELD"

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
, DEPARTMENT_CODE DEPARTMENT_CODE
, WIP_ENTITY_ID WIP_ENTITY_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, 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
, TRANSACTION_DATE TRANSACTION_DATE
, PERIOD_SET_NAME PERIOD_SET_NAME
, YEAR YEAR
, QUARTER QUARTER
, MONTH MONTH
, TOTAL_QUANTITY TOTAL_QUANTITY
, SCRAP_QUANTITY SCRAP_QUANTITY
, 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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
FROM "WIP"."WIP_BIS_PROD_DEPT_YIELD"