Product: | OE - Order Entry |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.WSHBV_DELIVERY |
SELECT DEL.DELIVERY_ID DELIVERY_ID
, DEL.NAME DELIVERY_NAME
, DEL.ORGANIZATION_ID
, DEL.CREATION_DATE
, DEL.CREATED_BY
, DEL.LAST_UPDATE_DATE
, DEL.LAST_UPDATED_BY
, DEL.LAST_UPDATE_LOGIN
, DEL.PROGRAM_APPLICATION_ID
, DEL.PROGRAM_ID
, DEL.PROGRAM_UPDATE_DATE
, DEL.REQUEST_ID
, DEL.PLANNED_DEPARTURE_ID DPW_DEPARTURE_ID
, DEL.ACTUAL_DEPARTURE_ID SC_DEPARTURE_ID
, DEL.STATUS_CODE STATUS_CODE
, DEL.SOURCE_CODE
, DEL.DATE_CLOSED
, DEL.SEQUENCE_NUMBER
, DEL.CUSTOMER_ID
, DEL.ULTIMATE_SHIP_TO_ID
, DEL.INTERMEDIATE_SHIP_TO_ID
, DEL.POOLED_SHIP_TO_ID
, DEL.WAYBILL
, DEL.GROSS_WEIGHT
, DEL.WEIGHT_UOM_CODE
, DEL.VOLUME
, DEL.VOLUME_UOM_CODE
, DEL.PICKED_BY_ID
, DEL.PACKED_BY_ID
, DEL.EXPECTED_ARRIVAL_DATE
, DEL.REPORT_SET_ID
, DEL.ASN_DATE_SENT
, DEL.ASN_SEQ_NUMBER
, DEL.LOADING_ORDER_FLAG
, DEL.FREIGHT_CARRIER_CODE
, DEL.FREIGHT_TERMS_CODE
, DEL.CURRENCY_CODE
, DEL.FOB_CODE
FROM WSH_DELIVERIES DEL