select TRANSACTION_TEMP_ID TRANSACTION_TEMP_ID, REPETITIVE_SCHEDULE_ID REPETITIVE_SCHEDULE_ID, ORGANIZATION_ID ORGANIZATION_ID, TRANSACTION_DATE TRANSACTION_DATE, COMPLETION_TRANSACTION_ID COMPLETION_TRANSACTION_ID, PRIMARY_QUANTITY PRIMARY_QUANTITY, TRANSACTION_QUANTITY TRANSACTION_QUANTITY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_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_MTL_ALLOCATIONS_TEMP"
SELECT TRANSACTION_TEMP_ID TRANSACTION_TEMP_ID
, REPETITIVE_SCHEDULE_ID REPETITIVE_SCHEDULE_ID
, ORGANIZATION_ID ORGANIZATION_ID
, TRANSACTION_DATE TRANSACTION_DATE
, COMPLETION_TRANSACTION_ID COMPLETION_TRANSACTION_ID
, PRIMARY_QUANTITY PRIMARY_QUANTITY
, TRANSACTION_QUANTITY TRANSACTION_QUANTITY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_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_MTL_ALLOCATIONS_TEMP"
|
|
|