View: WSH_STOP_DELIVERIES_V

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

View Text

SELECT TO_NUMBER(NULL) TRIP_ID
, TS.STOP_ID
, TO_NUMBER(NULL) DELIVERY_DETAIL_ID
, D.ROW_ID
, D.DELIVERY_ID
, D.NAME
, D.PLANNED_FLAG
, D.STATUS_CODE
, D.STATUS_NAME
, D.INITIAL_PICKUP_DATE
, D.INITIAL_PICKUP_LOCATION_ID
, D.ULTIMATE_DROPOFF_LOCATION_ID
, D.ULTIMATE_DROPOFF_DATE
, D.CUSTOMER_ID
, D.INTMED_SHIP_TO_LOCATION_ID
, D.POOLED_SHIP_TO_LOCATION_ID
, D.FREIGHT_TERMS_CODE
, D.FOB_CODE
, D.FOB_LOCATION_ID
, D.WAYBILL
, D.ACCEPTANCE_FLAG
, D.ACCEPTED_BY
, D.ACCEPTED_DATE
, D.ACKNOWLEDGED_BY
, D.CONFIRMED_BY
, D.ASN_DATE_SENT
, D.ASN_STATUS_CODE
, D.ASN_SEQ_NUMBER
, D.WV_FROZEN_FLAG
, D.GROSS_WEIGHT
, D.TARE_WEIGHT
, D.NET_WEIGHT
, D.WEIGHT_UOM_CODE
, D.VOLUME
, D.VOLUME_UOM_CODE
, D.ADDITIONAL_SHIPMENT_INFO
, D.CONFIRM_DATE
, D.SHIP_METHOD_CODE
, D.DOCK_CODE
, D.DELIVERY_TYPE
, D.CARRIER_ID
, D.CURRENCY_CODE
, D.ORGANIZATION_ID
, D.LOADING_SEQUENCE
, D.LOADING_ORDER_FLAG
, D.CONSOLIDATION_FLAG
, DECODE(TS.STATUS_CODE
, 'OP'
, 'AP'
, 'AR'
, 'AP'
, 'CL'
, 'PU') ACTIVITY_CODE
, D.ATTRIBUTE_CATEGORY
, D.ATTRIBUTE1
, D.ATTRIBUTE2
, D.ATTRIBUTE3
, D.ATTRIBUTE4
, D.ATTRIBUTE5
, D.ATTRIBUTE6
, D.ATTRIBUTE7
, D.ATTRIBUTE8
, D.ATTRIBUTE9
, D.ATTRIBUTE10
, D.ATTRIBUTE11
, D.ATTRIBUTE12
, D.ATTRIBUTE13
, D.ATTRIBUTE14
, D.ATTRIBUTE15
, D.TP_ATTRIBUTE_CATEGORY
, D.TP_ATTRIBUTE1
, D.TP_ATTRIBUTE2
, D.TP_ATTRIBUTE3
, D.TP_ATTRIBUTE4
, D.TP_ATTRIBUTE5
, D.TP_ATTRIBUTE6
, D.TP_ATTRIBUTE7
, D.TP_ATTRIBUTE8
, D.TP_ATTRIBUTE9
, D.TP_ATTRIBUTE10
, D.TP_ATTRIBUTE11
, D.TP_ATTRIBUTE12
, D.TP_ATTRIBUTE13
, D.TP_ATTRIBUTE14
, D.TP_ATTRIBUTE15
, D.GLOBAL_ATTRIBUTE_CATEGORY
, D.GLOBAL_ATTRIBUTE1
, D.GLOBAL_ATTRIBUTE2
, D.GLOBAL_ATTRIBUTE3
, D.GLOBAL_ATTRIBUTE4
, D.GLOBAL_ATTRIBUTE5
, D.GLOBAL_ATTRIBUTE6
, D.GLOBAL_ATTRIBUTE7
, D.GLOBAL_ATTRIBUTE8
, D.GLOBAL_ATTRIBUTE9
, D.GLOBAL_ATTRIBUTE10
, D.GLOBAL_ATTRIBUTE11
, D.GLOBAL_ATTRIBUTE12
, D.GLOBAL_ATTRIBUTE13
, D.GLOBAL_ATTRIBUTE14
, D.GLOBAL_ATTRIBUTE15
, D.GLOBAL_ATTRIBUTE16
, D.GLOBAL_ATTRIBUTE17
, D.GLOBAL_ATTRIBUTE18
, D.GLOBAL_ATTRIBUTE19
, D.GLOBAL_ATTRIBUTE20
, D.CREATION_DATE
, D.CREATED_BY
, D.LAST_UPDATE_DATE
, D.LAST_UPDATED_BY
, D.LAST_UPDATE_LOGIN
, D.PROGRAM_APPLICATION_ID
, D.PROGRAM_ID
, D.PROGRAM_UPDATE_DATE
, D.REQUEST_ID
, D.NUMBER_OF_LPN
, D.COD_AMOUNT
, D.COD_CURRENCY_CODE
, D.COD_REMIT_TO
, D.COD_CHARGE_PAID_BY
, D.PROBLEM_CONTACT_REFERENCE
, D.PORT_OF_LOADING
, D.PORT_OF_DISCHARGE
, D.FTZ_NUMBER
, D.ROUTED_EXPORT_TXN
, D.ENTRY_NUMBER
, D.ROUTING_INSTRUCTIONS
, D.IN_BOND_CODE
, D.SHIPPING_MARKS
, D.SERVICE_LEVEL
, D.MODE_OF_TRANSPORT
, D.ASSIGNED_TO_FTE_TRIPS
, D.BATCH_ID
, D.AP_BATCH_ID
, D.AUTO_SC_EXCLUDE_FLAG
, D.AUTO_AP_EXCLUDE_FLAG
, D.TP_DELIVERY_NUMBER
, D.TP_PLAN_NAME
, D.IGNORE_FOR_PLANNING
, D.PARTY_ID
, D.ROUTING_RESPONSE_ID
, D.RCV_SHIPMENT_HEADER_ID
, D.ASN_SHIPMENT_HEADER_ID
, D.SHIPMENT_DIRECTION
, D.SHIPPING_CONTROL
, D.VENDOR_ID
, D.EARLIEST_PICKUP_DATE
, D.LATEST_PICKUP_DATE
, D.EARLIEST_DROPOFF_DATE
, D.LATEST_DROPOFF_DATE
, D.REASON_OF_TRANSPORT
, D.DESCRIPTION
, D.DELIVERED_DATE
FROM WSH_NEW_DELIVERIES_V D
, WSH_DELIVERY_LEGS DL
, WSH_TRIP_STOPS TS
WHERE D.DELIVERY_ID = DL.DELIVERY_ID
AND TS.STOP_ID = DL.PICK_UP_STOP_ID
AND NVL(D.SHIPMENT_DIRECTION
, 'O') IN ('O'
, 'IO') /*--*/ UNION SELECT TO_NUMBER(NULL)
, TS.STOP_ID
, TO_NUMBER(NULL)
, D.ROW_ID
, D.DELIVERY_ID
, D.NAME
, D.PLANNED_FLAG
, D.STATUS_CODE
, D.STATUS_NAME
, D.INITIAL_PICKUP_DATE
, D.INITIAL_PICKUP_LOCATION_ID
, D.ULTIMATE_DROPOFF_LOCATION_ID
, D.ULTIMATE_DROPOFF_DATE
, D.CUSTOMER_ID
, D.INTMED_SHIP_TO_LOCATION_ID
, D.POOLED_SHIP_TO_LOCATION_ID
, D.FREIGHT_TERMS_CODE
, D.FOB_CODE
, D.FOB_LOCATION_ID
, D.WAYBILL
, D.ACCEPTANCE_FLAG
, D.ACCEPTED_BY
, D.ACCEPTED_DATE
, D.ACKNOWLEDGED_BY
, D.CONFIRMED_BY
, D.ASN_DATE_SENT
, D.ASN_STATUS_CODE
, D.ASN_SEQ_NUMBER
, D.WV_FROZEN_FLAG
, D.GROSS_WEIGHT
, D.TARE_WEIGHT
, D.NET_WEIGHT
, D.WEIGHT_UOM_CODE
, D.VOLUME
, D.VOLUME_UOM_CODE
, D.ADDITIONAL_SHIPMENT_INFO
, D.CONFIRM_DATE
, D.SHIP_METHOD_CODE
, D.DOCK_CODE
, D.DELIVERY_TYPE
, D.CARRIER_ID
, D.CURRENCY_CODE
, D.ORGANIZATION_ID
, D.LOADING_SEQUENCE
, D.LOADING_ORDER_FLAG
, D.CONSOLIDATION_FLAG
, DECODE(TS.STATUS_CODE
, 'OP'
, 'AD'
, 'AR'
, 'AD'
, 'CL'
, 'DO') ACTIVITY_CODE
, D.ATTRIBUTE_CATEGORY
, D.ATTRIBUTE1
, D.ATTRIBUTE2
, D.ATTRIBUTE3
, D.ATTRIBUTE4
, D.ATTRIBUTE5
, D.ATTRIBUTE6
, D.ATTRIBUTE7
, D.ATTRIBUTE8
, D.ATTRIBUTE9
, D.ATTRIBUTE10
, D.ATTRIBUTE11
, D.ATTRIBUTE12
, D.ATTRIBUTE13
, D.ATTRIBUTE14
, D.ATTRIBUTE15
, D.TP_ATTRIBUTE_CATEGORY
, D.TP_ATTRIBUTE1
, D.TP_ATTRIBUTE2
, D.TP_ATTRIBUTE3
, D.TP_ATTRIBUTE4
, D.TP_ATTRIBUTE5
, D.TP_ATTRIBUTE6
, D.TP_ATTRIBUTE7
, D.TP_ATTRIBUTE8
, D.TP_ATTRIBUTE9
, D.TP_ATTRIBUTE10
, D.TP_ATTRIBUTE11
, D.TP_ATTRIBUTE12
, D.TP_ATTRIBUTE13
, D.TP_ATTRIBUTE14
, D.TP_ATTRIBUTE15
, D.GLOBAL_ATTRIBUTE_CATEGORY
, D.GLOBAL_ATTRIBUTE1
, D.GLOBAL_ATTRIBUTE2
, D.GLOBAL_ATTRIBUTE3
, D.GLOBAL_ATTRIBUTE4
, D.GLOBAL_ATTRIBUTE5
, D.GLOBAL_ATTRIBUTE6
, D.GLOBAL_ATTRIBUTE7
, D.GLOBAL_ATTRIBUTE8
, D.GLOBAL_ATTRIBUTE9
, D.GLOBAL_ATTRIBUTE10
, D.GLOBAL_ATTRIBUTE11
, D.GLOBAL_ATTRIBUTE12
, D.GLOBAL_ATTRIBUTE13
, D.GLOBAL_ATTRIBUTE14
, D.GLOBAL_ATTRIBUTE15
, D.GLOBAL_ATTRIBUTE16
, D.GLOBAL_ATTRIBUTE17
, D.GLOBAL_ATTRIBUTE18
, D.GLOBAL_ATTRIBUTE19
, D.GLOBAL_ATTRIBUTE20
, D.CREATION_DATE
, D.CREATED_BY
, D.LAST_UPDATE_DATE
, D.LAST_UPDATED_BY
, D.LAST_UPDATE_LOGIN
, D.PROGRAM_APPLICATION_ID
, D.PROGRAM_ID
, D.PROGRAM_UPDATE_DATE
, D.REQUEST_ID
, D.NUMBER_OF_LPN
, D.COD_AMOUNT
, D.COD_CURRENCY_CODE
, D.COD_REMIT_TO
, D.COD_CHARGE_PAID_BY
, D.PROBLEM_CONTACT_REFERENCE
, D.PORT_OF_LOADING
, D.PORT_OF_DISCHARGE
, D.FTZ_NUMBER
, D.ROUTED_EXPORT_TXN
, D.ENTRY_NUMBER
, D.ROUTING_INSTRUCTIONS
, D.IN_BOND_CODE
, D.SHIPPING_MARKS
, D.SERVICE_LEVEL
, D.MODE_OF_TRANSPORT
, D.ASSIGNED_TO_FTE_TRIPS
, D.BATCH_ID
, D.AP_BATCH_ID
, D.AUTO_SC_EXCLUDE_FLAG
, D.AUTO_AP_EXCLUDE_FLAG
, D.TP_DELIVERY_NUMBER
, D.TP_PLAN_NAME
, D.IGNORE_FOR_PLANNING
, D.PARTY_ID
, D.ROUTING_RESPONSE_ID
, D.RCV_SHIPMENT_HEADER_ID
, D.ASN_SHIPMENT_HEADER_ID
, D.SHIPMENT_DIRECTION
, D.SHIPPING_CONTROL
, D.VENDOR_ID
, D.EARLIEST_PICKUP_DATE
, D.LATEST_PICKUP_DATE
, D.EARLIEST_DROPOFF_DATE
, D.LATEST_DROPOFF_DATE
, D.REASON_OF_TRANSPORT
, D.DESCRIPTION
, D.DELIVERED_DATE
FROM WSH_NEW_DELIVERIES_V D
, WSH_DELIVERY_LEGS DL
, WSH_TRIP_STOPS TS
WHERE D.DELIVERY_ID = DL.DELIVERY_ID
AND TS.STOP_ID = DL.DROP_OFF_STOP_ID
AND NVL(D.SHIPMENT_DIRECTION
, 'O') IN ('O'
, 'IO')

Columns