View: WSH_NEW_DELIVERIES_OB_GRP_V

Product:	WSH - Shipping Execution
Description:
Implementation/DBA Data:	APPS.WSH_NEW_DELIVERIES_OB_GRP_V

View Text

SELECT DELIVERY_ID
, NAME
, PLANNED_FLAG
, STATUS_CODE
, INITIAL_PICKUP_DATE
, INITIAL_PICKUP_LOCATION_ID
, ULTIMATE_DROPOFF_LOCATION_ID
, ULTIMATE_DROPOFF_DATE
, CUSTOMER_ID
, INTMED_SHIP_TO_LOCATION_ID
, POOLED_SHIP_TO_LOCATION_ID
, FREIGHT_TERMS_CODE
, FOB_CODE
, FOB_LOCATION_ID
, WAYBILL
, ACCEPTANCE_FLAG
, ACCEPTED_BY
, ACCEPTED_DATE
, ACKNOWLEDGED_BY
, CONFIRMED_BY
, ASN_DATE_SENT
, ASN_STATUS_CODE
, ASN_SEQ_NUMBER
, REASON_OF_TRANSPORT
, DESCRIPTION
, GROSS_WEIGHT
, NET_WEIGHT
, WEIGHT_UOM_CODE
, VOLUME
, VOLUME_UOM_CODE
, ADDITIONAL_SHIPMENT_INFO
, PORT_OF_DISCHARGE
, BOOKING_NUMBER
, COD_AMOUNT
, COD_CURRENCY_CODE
, SERVICE_CONTRACT
, COD_REMIT_TO
, COD_CHARGE_PAID_BY
, PROBLEM_CONTACT_REFERENCE
, BILL_FREIGHT_TO
, CARRIED_BY
, PORT_OF_LOADING
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, TP_ATTRIBUTE_CATEGORY
, TP_ATTRIBUTE1
, TP_ATTRIBUTE2
, TP_ATTRIBUTE3
, TP_ATTRIBUTE4
, TP_ATTRIBUTE5
, TP_ATTRIBUTE6
, TP_ATTRIBUTE7
, TP_ATTRIBUTE8
, TP_ATTRIBUTE9
, TP_ATTRIBUTE10
, TP_ATTRIBUTE11
, TP_ATTRIBUTE12
, TP_ATTRIBUTE13
, TP_ATTRIBUTE14
, TP_ATTRIBUTE15
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, CONFIRM_DATE
, SHIP_METHOD_CODE
, DOCK_CODE
, DELIVERY_TYPE
, CARRIER_ID
, CURRENCY_CODE
, ORGANIZATION_ID
, LOADING_SEQUENCE
, LOADING_ORDER_FLAG
, NUMBER_OF_LPN
, BATCH_ID
, SOURCE_HEADER_ID
, HASH_VALUE
, FTZ_NUMBER
, ROUTED_EXPORT_TXN
, ENTRY_NUMBER
, ROUTING_INSTRUCTIONS
, IN_BOND_CODE
, SHIPPING_MARKS
, SERVICE_LEVEL
, MODE_OF_TRANSPORT
, ASSIGNED_TO_FTE_TRIPS
, AUTO_SC_EXCLUDE_FLAG
, AUTO_AP_EXCLUDE_FLAG
, AP_BATCH_ID
, TP_DELIVERY_NUMBER
, TP_PLAN_NAME
, VENDOR_ID
, EARLIEST_PICKUP_DATE
, LATEST_PICKUP_DATE
, EARLIEST_DROPOFF_DATE
, LATEST_DROPOFF_DATE
, IGNORE_FOR_PLANNING
, PARTY_ID
, ROUTING_RESPONSE_ID
, RCV_SHIPMENT_HEADER_ID
, ASN_SHIPMENT_HEADER_ID
, SHIPMENT_DIRECTION
, SHIPPING_CONTROL
, WV_FROZEN_FLAG
, HASH_STRING
, ITINERARY_COMPLETE
, DELIVERED_DATE
, TMS_VERSION_NUMBER
, TMS_INTERFACE_FLAG
FROM WSH_NEW_DELIVERIES
WHERE NVL(SHIPMENT_DIRECTION
, 'O') IN ('O'
, 'IO')

Columns