[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 |