Product: | OE - Order Entry |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT WDELT.ROWID ROW_ID
, WDELT.DELIVERY_TEMPLATE_ID
, WDELT.NAME
, WDELT.ORGANIZATION_ID
, WDEPT.NAME PLANNED_DEP_TEMPLATE_NAME
, WDELT.PLANNED_DEP_TEMPLATE_ID
, WDELT.LOADING_ORDER_FLAG
, WDELT.SEQUENCE_NUMBER
, WDELT.CUSTOMER_ID
, RC.CUSTOMER_NAME
, WDELT.ULTIMATE_SHIP_TO_ID
, RSUA1.LOCATION ULTIMATE_SHIP_TO
, WDELT.INTERMEDIATE_SHIP_TO_ID
, RSUA2.LOCATION INTERMEDIATE_SHIP_TO
, WDELT.POOLED_SHIP_TO_ID
, RSUA3.LOCATION POOLED_SHIP_TO
, WDELT.WEIGHT_UOM_CODE
, WDELT.VOLUME_UOM_CODE
, WDELT.EXPECTED_ARRIVAL_DAY_OFFSET
, WDELT.EXPECTED_ARRIVAL_HOUR_OFFSET
, WDELT.EXPECTED_ARRIVAL_MIN_OFFSET
, WDELT.PLANNED_FREQUENCY
, WDELT.PLANNED_DAY
, WDELT.PLANNED_TIME
, WDELT.ATTRIBUTE_CATEGORY
, WDELT.ATTRIBUTE1
, WDELT.ATTRIBUTE2
, WDELT.ATTRIBUTE3
, WDELT.ATTRIBUTE4
, WDELT.ATTRIBUTE5
, WDELT.ATTRIBUTE6
, WDELT.ATTRIBUTE7
, WDELT.ATTRIBUTE8
, WDELT.ATTRIBUTE9
, WDELT.ATTRIBUTE10
, WDELT.ATTRIBUTE11
, WDELT.ATTRIBUTE12
, WDELT.ATTRIBUTE13
, WDELT.ATTRIBUTE14
, WDELT.ATTRIBUTE15
, WDELT.GLOBAL_ATTRIBUTE_CATEGORY
, WDELT.GLOBAL_ATTRIBUTE1
, WDELT.GLOBAL_ATTRIBUTE2
, WDELT.GLOBAL_ATTRIBUTE3
, WDELT.GLOBAL_ATTRIBUTE4
, WDELT.GLOBAL_ATTRIBUTE5
, WDELT.GLOBAL_ATTRIBUTE6
, WDELT.GLOBAL_ATTRIBUTE7
, WDELT.GLOBAL_ATTRIBUTE8
, WDELT.GLOBAL_ATTRIBUTE9
, WDELT.GLOBAL_ATTRIBUTE10
, WDELT.GLOBAL_ATTRIBUTE11
, WDELT.GLOBAL_ATTRIBUTE12
, WDELT.GLOBAL_ATTRIBUTE13
, WDELT.GLOBAL_ATTRIBUTE14
, WDELT.GLOBAL_ATTRIBUTE15
, WDELT.GLOBAL_ATTRIBUTE16
, WDELT.GLOBAL_ATTRIBUTE17
, WDELT.GLOBAL_ATTRIBUTE18
, WDELT.GLOBAL_ATTRIBUTE19
, WDELT.GLOBAL_ATTRIBUTE20
, WDELT.CREATION_DATE
, WDELT.CREATED_BY
, WDELT.LAST_UPDATE_DATE
, WDELT.LAST_UPDATED_BY
, WDELT.LAST_UPDATE_LOGIN
, WDELT.PROGRAM_APPLICATION_ID
, WDELT.PROGRAM_ID
, WDELT.PROGRAM_UPDATE_DATE
, WDELT.REQUEST_ID
FROM WSH_DELIVERY_TEMPLATES WDELT
, WSH_DEPARTURE_TEMPLATES WDEPT
, RA_CUSTOMERS RC
, RA_SITE_USES_ALL RSUA1
, RA_SITE_USES_ALL RSUA2
, RA_SITE_USES_ALL RSUA3
WHERE RC.CUSTOMER_ID = WDELT.CUSTOMER_ID AND WDEPT.DEPARTURE_TEMPLATE_ID(+) = WDELT.PLANNED_DEP_TEMPLATE_ID AND RSUA1.SITE_USE_ID = WDELT.ULTIMATE_SHIP_TO_ID AND RSUA2.SITE_USE_ID(+) = NVL(WDELT.INTERMEDIATE_SHIP_TO_ID
, -99) AND RSUA3.SITE_USE_ID(+) = NVL(WDELT.POOLED_SHIP_TO_ID
, -99)