select SUBCONTRACT_PO_SHIPMENT_ID SUBCONTRACT_PO_SHIPMENT_ID, SHIKYU_COMPONENT_ID SHIKYU_COMPONENT_ID, REPLENISHMENT_SO_LINE_ID REPLENISHMENT_SO_LINE_ID, ALLOCATED_QUANTITY ALLOCATED_QUANTITY, UOM UOM, REQUEST_ID REQUEST_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, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID from "JMF"."JMF_SHIKYU_ALLOCATIONS"
SELECT SUBCONTRACT_PO_SHIPMENT_ID SUBCONTRACT_PO_SHIPMENT_ID
, SHIKYU_COMPONENT_ID SHIKYU_COMPONENT_ID
, REPLENISHMENT_SO_LINE_ID REPLENISHMENT_SO_LINE_ID
, ALLOCATED_QUANTITY ALLOCATED_QUANTITY
, UOM UOM
, REQUEST_ID REQUEST_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
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
FROM "JMF"."JMF_SHIKYU_ALLOCATIONS"
|
|
|