VIEW: WIP.WIP_PAC_PERIOD_BALANCES#

Source

View Text - Preformatted

select PAC_PERIOD_ID PAC_PERIOD_ID, COST_GROUP_ID COST_GROUP_ID, COST_TYPE_ID COST_TYPE_ID, ORGANIZATION_ID ORGANIZATION_ID, WIP_ENTITY_ID WIP_ENTITY_ID, LINE_ID LINE_ID, OPERATION_SEQ_NUM OPERATION_SEQ_NUM, OPERATION_COMPLETED_UNITS OPERATION_COMPLETED_UNITS, RELIEVED_ASSEMBLY_UNITS RELIEVED_ASSEMBLY_UNITS, TL_RESOURCE_IN TL_RESOURCE_IN, TL_RESOURCE_OUT TL_RESOURCE_OUT, TL_OUTSIDE_PROCESSING_IN TL_OUTSIDE_PROCESSING_IN, TL_OUTSIDE_PROCESSING_OUT TL_OUTSIDE_PROCESSING_OUT, TL_OVERHEAD_IN TL_OVERHEAD_IN, TL_OVERHEAD_OUT TL_OVERHEAD_OUT, PL_MATERIAL_IN PL_MATERIAL_IN, PL_MATERIAL_OUT PL_MATERIAL_OUT, PL_RESOURCE_IN PL_RESOURCE_IN, PL_RESOURCE_OUT PL_RESOURCE_OUT, PL_OVERHEAD_IN PL_OVERHEAD_IN, PL_OVERHEAD_OUT PL_OVERHEAD_OUT, PL_OUTSIDE_PROCESSING_IN PL_OUTSIDE_PROCESSING_IN, PL_OUTSIDE_PROCESSING_OUT PL_OUTSIDE_PROCESSING_OUT, PL_MATERIAL_OVERHEAD_IN PL_MATERIAL_OVERHEAD_IN, PL_MATERIAL_OVERHEAD_OUT PL_MATERIAL_OVERHEAD_OUT, TL_RESOURCE_TEMP TL_RESOURCE_TEMP, TL_OUTSIDE_PROCESSING_TEMP TL_OUTSIDE_PROCESSING_TEMP, TL_OVERHEAD_TEMP TL_OVERHEAD_TEMP, PL_MATERIAL_TEMP PL_MATERIAL_TEMP, PL_MATERIAL_OVERHEAD_TEMP PL_MATERIAL_OVERHEAD_TEMP, PL_RESOURCE_TEMP PL_RESOURCE_TEMP, PL_OUTSIDE_PROCESSING_TEMP PL_OUTSIDE_PROCESSING_TEMP, PL_OVERHEAD_TEMP PL_OVERHEAD_TEMP, 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_OUTSIDE_PROCESSING_VAR PL_OUTSIDE_PROCESSING_VAR, PL_OVERHEAD_VAR PL_OVERHEAD_VAR, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, WIP_ENTITY_TYPE WIP_ENTITY_TYPE, PL_MATERIAL_IN_APULL PL_MATERIAL_IN_APULL, PL_MATERIAL_OVERHEAD_IN_APULL PL_MATERIAL_OVERHEAD_IN_APULL, PL_RESOURCE_IN_APULL PL_RESOURCE_IN_APULL, PL_OUTSIDE_PROCESSING_IN_APULL PL_OUTSIDE_PROCESSING_IN_APULL, PL_OVERHEAD_IN_APULL PL_OVERHEAD_IN_APULL, PL_MATERIAL_TEMP_VAR PL_MATERIAL_TEMP_VAR, PL_MATERIAL_OVERHEAD_TEMP_VAR PL_MATERIAL_OVERHEAD_TEMP_VAR, PL_RESOURCE_TEMP_VAR PL_RESOURCE_TEMP_VAR, PL_OVERHEAD_TEMP_VAR PL_OVERHEAD_TEMP_VAR, PL_OUTSIDE_PROCESSING_TEMP_VAR PL_OUTSIDE_PROCESSING_TEMP_VAR, UNRELIEVED_SCRAP_QUANTITY UNRELIEVED_SCRAP_QUANTITY, SCRAP_PULL_MATERIAL SCRAP_PULL_MATERIAL, SCRAP_PULL_MATERIAL_OVERHEAD SCRAP_PULL_MATERIAL_OVERHEAD, SCRAP_PULL_RESOURCE SCRAP_PULL_RESOURCE, SCRAP_PULL_OUTSIDE_PROCESSING SCRAP_PULL_OUTSIDE_PROCESSING, SCRAP_PULL_OVERHEAD SCRAP_PULL_OVERHEAD, RELIEVED_SCRAP_QTY RELIEVED_SCRAP_QTY from "WIP"."WIP_PAC_PERIOD_BALANCES"

View Text - HTML Formatted

SELECT PAC_PERIOD_ID PAC_PERIOD_ID
, COST_GROUP_ID COST_GROUP_ID
, COST_TYPE_ID COST_TYPE_ID
, ORGANIZATION_ID ORGANIZATION_ID
, WIP_ENTITY_ID WIP_ENTITY_ID
, LINE_ID LINE_ID
, OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, OPERATION_COMPLETED_UNITS OPERATION_COMPLETED_UNITS
, RELIEVED_ASSEMBLY_UNITS RELIEVED_ASSEMBLY_UNITS
, TL_RESOURCE_IN TL_RESOURCE_IN
, TL_RESOURCE_OUT TL_RESOURCE_OUT
, TL_OUTSIDE_PROCESSING_IN TL_OUTSIDE_PROCESSING_IN
, TL_OUTSIDE_PROCESSING_OUT TL_OUTSIDE_PROCESSING_OUT
, TL_OVERHEAD_IN TL_OVERHEAD_IN
, TL_OVERHEAD_OUT TL_OVERHEAD_OUT
, PL_MATERIAL_IN PL_MATERIAL_IN
, PL_MATERIAL_OUT PL_MATERIAL_OUT
, PL_RESOURCE_IN PL_RESOURCE_IN
, PL_RESOURCE_OUT PL_RESOURCE_OUT
, PL_OVERHEAD_IN PL_OVERHEAD_IN
, PL_OVERHEAD_OUT PL_OVERHEAD_OUT
, PL_OUTSIDE_PROCESSING_IN PL_OUTSIDE_PROCESSING_IN
, PL_OUTSIDE_PROCESSING_OUT PL_OUTSIDE_PROCESSING_OUT
, PL_MATERIAL_OVERHEAD_IN PL_MATERIAL_OVERHEAD_IN
, PL_MATERIAL_OVERHEAD_OUT PL_MATERIAL_OVERHEAD_OUT
, TL_RESOURCE_TEMP TL_RESOURCE_TEMP
, TL_OUTSIDE_PROCESSING_TEMP TL_OUTSIDE_PROCESSING_TEMP
, TL_OVERHEAD_TEMP TL_OVERHEAD_TEMP
, PL_MATERIAL_TEMP PL_MATERIAL_TEMP
, PL_MATERIAL_OVERHEAD_TEMP PL_MATERIAL_OVERHEAD_TEMP
, PL_RESOURCE_TEMP PL_RESOURCE_TEMP
, PL_OUTSIDE_PROCESSING_TEMP PL_OUTSIDE_PROCESSING_TEMP
, PL_OVERHEAD_TEMP PL_OVERHEAD_TEMP
, 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_OUTSIDE_PROCESSING_VAR PL_OUTSIDE_PROCESSING_VAR
, PL_OVERHEAD_VAR PL_OVERHEAD_VAR
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, WIP_ENTITY_TYPE WIP_ENTITY_TYPE
, PL_MATERIAL_IN_APULL PL_MATERIAL_IN_APULL
, PL_MATERIAL_OVERHEAD_IN_APULL PL_MATERIAL_OVERHEAD_IN_APULL
, PL_RESOURCE_IN_APULL PL_RESOURCE_IN_APULL
, PL_OUTSIDE_PROCESSING_IN_APULL PL_OUTSIDE_PROCESSING_IN_APULL
, PL_OVERHEAD_IN_APULL PL_OVERHEAD_IN_APULL
, PL_MATERIAL_TEMP_VAR PL_MATERIAL_TEMP_VAR
, PL_MATERIAL_OVERHEAD_TEMP_VAR PL_MATERIAL_OVERHEAD_TEMP_VAR
, PL_RESOURCE_TEMP_VAR PL_RESOURCE_TEMP_VAR
, PL_OVERHEAD_TEMP_VAR PL_OVERHEAD_TEMP_VAR
, PL_OUTSIDE_PROCESSING_TEMP_VAR PL_OUTSIDE_PROCESSING_TEMP_VAR
, UNRELIEVED_SCRAP_QUANTITY UNRELIEVED_SCRAP_QUANTITY
, SCRAP_PULL_MATERIAL SCRAP_PULL_MATERIAL
, SCRAP_PULL_MATERIAL_OVERHEAD SCRAP_PULL_MATERIAL_OVERHEAD
, SCRAP_PULL_RESOURCE SCRAP_PULL_RESOURCE
, SCRAP_PULL_OUTSIDE_PROCESSING SCRAP_PULL_OUTSIDE_PROCESSING
, SCRAP_PULL_OVERHEAD SCRAP_PULL_OVERHEAD
, RELIEVED_SCRAP_QTY RELIEVED_SCRAP_QTY
FROM "WIP"."WIP_PAC_PERIOD_BALANCES"