DBA Data[Home] [Help]

VIEW: APPS.WSH_NEW_DELIVERIES_OB_GRP_V

Source

View Text - Preformatted

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')
View Text - HTML Formatted

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')