FND Design Data [Home] [Help]

View: WSHBV_DELIVERY

Product: OE - Order Entry
Description: - Retrofitted
Implementation/DBA Data: ViewAPPS.WSHBV_DELIVERY
View Text

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

Columns

Name
DELIVERY_ID
DELIVERY_NAME
ORGANIZATION_ID
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
REQUEST_ID
DPW_DEPARTURE_ID
SC_DEPARTURE_ID
STATUS_CODE
SOURCE_CODE
DATE_CLOSED
SEQUENCE_NUMBER
CUSTOMER_ID
ULTIMATE_SHIP_TO_ID
INTERMEDIATE_SHIP_TO_ID
POOLED_SHIP_TO_ID
WAYBILL
GROSS_WEIGHT
WEIGHT_UOM_CODE
VOLUME
VOLUME_UOM_CODE
PICKED_BY_ID
PACKED_BY_ID
EXPECTED_ARRIVAL_DATE
REPORT_SET_ID
ASN_DATE_SENT
ASN_SEQ_NUMBER
LOADING_ORDER_FLAG
FREIGHT_CARRIER_CODE
FREIGHT_TERMS_CODE
CURRENCY_CODE
FOB_CODE