VIEW: APPS.WSHBV_DELIVERY

Source

View Text - Preformatted

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

View Text - HTML Formatted

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