VIEW: WIP.WIP_SO_ALLOCATIONS_TEMP#

Source

View Text - Preformatted

select ALLOCATION_ID ALLOCATION_ID, WIP_ENTITY_ID WIP_ENTITY_ID, ORGANIZATION_ID ORGANIZATION_ID, DEMAND_SOURCE_HEADER_ID DEMAND_SOURCE_HEADER_ID, DEMAND_SOURCE_LINE DEMAND_SOURCE_LINE, USER_LINE_NUM USER_LINE_NUM, DEMAND_SOURCE_DELIVERY DEMAND_SOURCE_DELIVERY, USER_DELIVERY USER_DELIVERY, QUANTITY_ALLOCATED QUANTITY_ALLOCATED, QUANTITY_COMPLETED QUANTITY_COMPLETED, DEMAND_CLASS DEMAND_CLASS, 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, GROUP_ID GROUP_ID, ACTION_CODE ACTION_CODE, QUANTITY_CHANGED QUANTITY_CHANGED, BOM_REVISION BOM_REVISION, PRIMARY_ITEM_ID PRIMARY_ITEM_ID, REQUIREMENT_DATE REQUIREMENT_DATE, LINE_UOM LINE_UOM from "WIP"."WIP_SO_ALLOCATIONS_TEMP"

View Text - HTML Formatted

SELECT ALLOCATION_ID ALLOCATION_ID
, WIP_ENTITY_ID WIP_ENTITY_ID
, ORGANIZATION_ID ORGANIZATION_ID
, DEMAND_SOURCE_HEADER_ID DEMAND_SOURCE_HEADER_ID
, DEMAND_SOURCE_LINE DEMAND_SOURCE_LINE
, USER_LINE_NUM USER_LINE_NUM
, DEMAND_SOURCE_DELIVERY DEMAND_SOURCE_DELIVERY
, USER_DELIVERY USER_DELIVERY
, QUANTITY_ALLOCATED QUANTITY_ALLOCATED
, QUANTITY_COMPLETED QUANTITY_COMPLETED
, DEMAND_CLASS DEMAND_CLASS
, 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
, GROUP_ID GROUP_ID
, ACTION_CODE ACTION_CODE
, QUANTITY_CHANGED QUANTITY_CHANGED
, BOM_REVISION BOM_REVISION
, PRIMARY_ITEM_ID PRIMARY_ITEM_ID
, REQUIREMENT_DATE REQUIREMENT_DATE
, LINE_UOM LINE_UOM
FROM "WIP"."WIP_SO_ALLOCATIONS_TEMP"