VIEW: WIP.WIP_PERIOD_BALANCES#

Source

View Text - Preformatted

select ACCT_PERIOD_ID ACCT_PERIOD_ID, WIP_ENTITY_ID WIP_ENTITY_ID, REPETITIVE_SCHEDULE_ID REPETITIVE_SCHEDULE_ID, 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, ORGANIZATION_ID ORGANIZATION_ID, CLASS_TYPE CLASS_TYPE, TL_RESOURCE_IN TL_RESOURCE_IN, TL_OVERHEAD_IN TL_OVERHEAD_IN, TL_OUTSIDE_PROCESSING_IN TL_OUTSIDE_PROCESSING_IN, PL_MATERIAL_IN PL_MATERIAL_IN, PL_MATERIAL_OVERHEAD_IN PL_MATERIAL_OVERHEAD_IN, PL_RESOURCE_IN PL_RESOURCE_IN, PL_OVERHEAD_IN PL_OVERHEAD_IN, PL_OUTSIDE_PROCESSING_IN PL_OUTSIDE_PROCESSING_IN, TL_MATERIAL_OUT TL_MATERIAL_OUT, TL_MATERIAL_OVERHEAD_OUT TL_MATERIAL_OVERHEAD_OUT, TL_RESOURCE_OUT TL_RESOURCE_OUT, TL_OVERHEAD_OUT TL_OVERHEAD_OUT, TL_OUTSIDE_PROCESSING_OUT TL_OUTSIDE_PROCESSING_OUT, PL_MATERIAL_OUT PL_MATERIAL_OUT, PL_MATERIAL_OVERHEAD_OUT PL_MATERIAL_OVERHEAD_OUT, PL_RESOURCE_OUT PL_RESOURCE_OUT, PL_OVERHEAD_OUT PL_OVERHEAD_OUT, PL_OUTSIDE_PROCESSING_OUT PL_OUTSIDE_PROCESSING_OUT, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, TL_MATERIAL_VAR TL_MATERIAL_VAR, TL_MATERIAL_OVERHEAD_VAR TL_MATERIAL_OVERHEAD_VAR, TL_RESOURCE_VAR TL_RESOURCE_VAR, TL_OUTSIDE_PROCESSING_VAR TL_OUTSIDE_PROCESSING_VAR, TL_OVERHEAD_VAR TL_OVERHEAD_VAR, PL_MATERIAL_VAR PL_MATERIAL_VAR, PL_MATERIAL_OVERHEAD_VAR PL_MATERIAL_OVERHEAD_VAR, PL_RESOURCE_VAR PL_RESOURCE_VAR, PL_OVERHEAD_VAR PL_OVERHEAD_VAR, PL_OUTSIDE_PROCESSING_VAR PL_OUTSIDE_PROCESSING_VAR, TL_SCRAP_IN TL_SCRAP_IN, TL_SCRAP_OUT TL_SCRAP_OUT, TL_SCRAP_VAR TL_SCRAP_VAR from "WIP"."WIP_PERIOD_BALANCES"

View Text - HTML Formatted

SELECT ACCT_PERIOD_ID ACCT_PERIOD_ID
, WIP_ENTITY_ID WIP_ENTITY_ID
, REPETITIVE_SCHEDULE_ID REPETITIVE_SCHEDULE_ID
, 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
, ORGANIZATION_ID ORGANIZATION_ID
, CLASS_TYPE CLASS_TYPE
, TL_RESOURCE_IN TL_RESOURCE_IN
, TL_OVERHEAD_IN TL_OVERHEAD_IN
, TL_OUTSIDE_PROCESSING_IN TL_OUTSIDE_PROCESSING_IN
, PL_MATERIAL_IN PL_MATERIAL_IN
, PL_MATERIAL_OVERHEAD_IN PL_MATERIAL_OVERHEAD_IN
, PL_RESOURCE_IN PL_RESOURCE_IN
, PL_OVERHEAD_IN PL_OVERHEAD_IN
, PL_OUTSIDE_PROCESSING_IN PL_OUTSIDE_PROCESSING_IN
, TL_MATERIAL_OUT TL_MATERIAL_OUT
, TL_MATERIAL_OVERHEAD_OUT TL_MATERIAL_OVERHEAD_OUT
, TL_RESOURCE_OUT TL_RESOURCE_OUT
, TL_OVERHEAD_OUT TL_OVERHEAD_OUT
, TL_OUTSIDE_PROCESSING_OUT TL_OUTSIDE_PROCESSING_OUT
, PL_MATERIAL_OUT PL_MATERIAL_OUT
, PL_MATERIAL_OVERHEAD_OUT PL_MATERIAL_OVERHEAD_OUT
, PL_RESOURCE_OUT PL_RESOURCE_OUT
, PL_OVERHEAD_OUT PL_OVERHEAD_OUT
, PL_OUTSIDE_PROCESSING_OUT PL_OUTSIDE_PROCESSING_OUT
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, TL_MATERIAL_VAR TL_MATERIAL_VAR
, TL_MATERIAL_OVERHEAD_VAR TL_MATERIAL_OVERHEAD_VAR
, TL_RESOURCE_VAR TL_RESOURCE_VAR
, TL_OUTSIDE_PROCESSING_VAR TL_OUTSIDE_PROCESSING_VAR
, TL_OVERHEAD_VAR TL_OVERHEAD_VAR
, PL_MATERIAL_VAR PL_MATERIAL_VAR
, PL_MATERIAL_OVERHEAD_VAR PL_MATERIAL_OVERHEAD_VAR
, PL_RESOURCE_VAR PL_RESOURCE_VAR
, PL_OVERHEAD_VAR PL_OVERHEAD_VAR
, PL_OUTSIDE_PROCESSING_VAR PL_OUTSIDE_PROCESSING_VAR
, TL_SCRAP_IN TL_SCRAP_IN
, TL_SCRAP_OUT TL_SCRAP_OUT
, TL_SCRAP_VAR TL_SCRAP_VAR
FROM "WIP"."WIP_PERIOD_BALANCES"