[Home] [Help]
View: ECE_DSNO_DELIVERY_ATTRIBS_V
Product: | EC - e-Commerce Gateway |
Description: | No longer used |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM RA_ADDRESSES_ALL RAD3
, RA_SITE_USES_ALL RSU3
, RA_CUSTOMERS RCU3
, HR_LOCATIONS HRL
, HR_ORGANIZATION_UNITS HOU
, ECE_TP_DETAILS ETD
, ECE_TP_HEADERS ETH
, WSH_DEPARTURES DPT
, WSH_DELIVERIES DLV
WHERE HOU.LOCATION_ID = HRL.LOCATION_ID (+) AND DLV.ORGANIZATION_ID = HOU.ORGANIZATION_ID AND ETD.EDI_FLAG = 'Y' AND ETD.DOCUMENT_ID = 'DSNO' AND RAD3.TP_HEADER_ID = ETD.TP_HEADER_ID AND RAD3.TP_HEADER_ID = ETH.TP_HEADER_ID AND RSU3.ADDRESS_ID = RAD3.ADDRESS_ID AND DLV.ULTIMATE_SHIP_TO_ID = RSU3.SITE_USE_ID AND DLV.CUSTOMER_ID = RCU3.CUSTOMER_ID AND DPT.STATUS_CODE = 'CL' AND DLV.ACTUAL_DEPARTURE_ID = DPT.DEPARTURE_ID AND EXISTS (SELECT DELIVERY_ID
FROM SO_PICKING_LINE_DETAILS PLD
WHERE DLV.DELIVERY_ID = PLD.DELIVERY_ID
AND NVL(PLD.SHIPPED_QUANTITY
, 0) > 0)
Columns
Name |
TP_HEADER_ID |
TP_DETAIL_ID |
DELIVERY_ID |
DEPARTURE_ID |
WAREHOUSE_LOCATION_ID |
DESTINATION_SITE_USE_ID |
DESTINATION_CUSTOMER_ID |
WAREHOUSE_CATEGORY |
WAREHOUSE_ATTRIBUTE1 |
WAREHOUSE_ATTRIBUTE2 |
WAREHOUSE_ATTRIBUTE3 |
WAREHOUSE_ATTRIBUTE4 |
WAREHOUSE_ATTRIBUTE5 |
WAREHOUSE_ATTRIBUTE6 |
WAREHOUSE_ATTRIBUTE7 |
WAREHOUSE_ATTRIBUTE8 |
WAREHOUSE_ATTRIBUTE9 |
WAREHOUSE_ATTRIBUTE10 |
WAREHOUSE_ATTRIBUTE11 |
WAREHOUSE_ATTRIBUTE12 |
WAREHOUSE_ATTRIBUTE13 |
WAREHOUSE_ATTRIBUTE14 |
WAREHOUSE_ATTRIBUTE15 |
WAREHOUSE_ATTRIBUTE16 |
WAREHOUSE_ATTRIBUTE17 |
WAREHOUSE_ATTRIBUTE18 |
WAREHOUSE_ATTRIBUTE19 |
WAREHOUSE_ATTRIBUTE20 |
DESTINATION_CATEGORY |
DESTINATION_ATTRIBUTE1 |
DESTINATION_ATTRIBUTE2 |
DESTINATION_ATTRIBUTE3 |
DESTINATION_ATTRIBUTE4 |
DESTINATION_ATTRIBUTE5 |
DESTINATION_ATTRIBUTE6 |
DESTINATION_ATTRIBUTE7 |
DESTINATION_ATTRIBUTE8 |
DESTINATION_ATTRIBUTE9 |
DESTINATION_ATTRIBUTE10 |
DESTINATION_ATTRIBUTE11 |
DESTINATION_ATTRIBUTE12 |
DESTINATION_ATTRIBUTE13 |
DESTINATION_ATTRIBUTE14 |
DESTINATION_ATTRIBUTE15 |
DESTINATION_ATTRIBUTE16 |
DESTINATION_ATTRIBUTE17 |
DESTINATION_ATTRIBUTE18 |
DESTINATION_ATTRIBUTE19 |
DESTINATION_ATTRIBUTE20 |
DESTINATION_ATTRIBUTE21 |
DESTINATION_ATTRIBUTE22 |
DESTINATION_ATTRIBUTE23 |
DESTINATION_ATTRIBUTE24 |
DESTINATION_ATTRIBUTE25 |
CUSTOMER_CATEGORY |
CUSTOMER_ATTRIBUTE1 |
CUSTOMER_ATTRIBUTE2 |
CUSTOMER_ATTRIBUTE3 |
CUSTOMER_ATTRIBUTE4 |
CUSTOMER_ATTRIBUTE5 |
CUSTOMER_ATTRIBUTE6 |
CUSTOMER_ATTRIBUTE7 |
CUSTOMER_ATTRIBUTE8 |
CUSTOMER_ATTRIBUTE9 |
CUSTOMER_ATTRIBUTE10 |
CUSTOMER_ATTRIBUTE11 |
CUSTOMER_ATTRIBUTE12 |
CUSTOMER_ATTRIBUTE13 |
CUSTOMER_ATTRIBUTE14 |
CUSTOMER_ATTRIBUTE15 |
CUSTOMER_GLOBAL_CATEGORY |
CUSTOMER_GLOBAL_ATTRIBUTE1 |
CUSTOMER_GLOBAL_ATTRIBUTE2 |
CUSTOMER_GLOBAL_ATTRIBUTE3 |
CUSTOMER_GLOBAL_ATTRIBUTE4 |
CUSTOMER_GLOBAL_ATTRIBUTE5 |
CUSTOMER_GLOBAL_ATTRIBUTE6 |
CUSTOMER_GLOBAL_ATTRIBUTE7 |
CUSTOMER_GLOBAL_ATTRIBUTE8 |
CUSTOMER_GLOBAL_ATTRIBUTE9 |
CUSTOMER_GLOBAL_ATTRIBUTE10 |
CUSTOMER_GLOBAL_ATTRIBUTE11 |
CUSTOMER_GLOBAL_ATTRIBUTE12 |
CUSTOMER_GLOBAL_ATTRIBUTE13 |
CUSTOMER_GLOBAL_ATTRIBUTE14 |
CUSTOMER_GLOBAL_ATTRIBUTE15 |
CUSTOMER_GLOBAL_ATTRIBUTE16 |
CUSTOMER_GLOBAL_ATTRIBUTE17 |
CUSTOMER_GLOBAL_ATTRIBUTE18 |
CUSTOMER_GLOBAL_ATTRIBUTE19 |
CUSTOMER_GLOBAL_ATTRIBUTE20 |
DEPARTURE_CATEGORY |
DEPARTURE_ATTRIBUTE1 |
DEPARTURE_ATTRIBUTE2 |
DEPARTURE_ATTRIBUTE3 |
DEPARTURE_ATTRIBUTE4 |
DEPARTURE_ATTRIBUTE5 |
DEPARTURE_ATTRIBUTE6 |
DEPARTURE_ATTRIBUTE7 |
DEPARTURE_ATTRIBUTE8 |
DEPARTURE_ATTRIBUTE9 |
DEPARTURE_ATTRIBUTE10 |
DEPARTURE_ATTRIBUTE11 |
DEPARTURE_ATTRIBUTE12 |
DEPARTURE_ATTRIBUTE13 |
DEPARTURE_ATTRIBUTE14 |
DEPARTURE_ATTRIBUTE15 |
DELIVERY_CATEGORY |
DELIVERY_ATTRIBUTE1 |
DELIVERY_ATTRIBUTE2 |
DELIVERY_ATTRIBUTE3 |
DELIVERY_ATTRIBUTE4 |
DELIVERY_ATTRIBUTE5 |
DELIVERY_ATTRIBUTE6 |
DELIVERY_ATTRIBUTE7 |
DELIVERY_ATTRIBUTE8 |
DELIVERY_ATTRIBUTE9 |
DELIVERY_ATTRIBUTE10 |
DELIVERY_ATTRIBUTE11 |
DELIVERY_ATTRIBUTE12 |
DELIVERY_ATTRIBUTE13 |
DELIVERY_ATTRIBUTE14 |
DELIVERY_ATTRIBUTE15 |