Product: | QA - Quality |
---|---|
Description: | shipping delivery electronic record |
Implementation/DBA Data: | APPS.QA_ERES_WSH_NEW_DELIVERIES_V |
SELECT WNDV.DELIVERY_ID
, WNDV.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, HRORG.NAME
, WNDV.NAME
, WNDV.STATUS_CODE
, WNDV.STATUS_NAME
, WL1.UI_LOCATION_CODE
, WL2.UI_LOCATION_CODE
, WL3.UI_LOCATION_CODE
, WL4.UI_LOCATION_CODE
, WNDV.CUSTOMER_ID
, RAC.CUSTOMER_NAME
, WNDV.SHIP_METHOD_CODE
, WCSMV.SHIP_METHOD_CODE_MEANING
, WNDV.SERVICE_LEVEL
, WLOOK1.MEANING
, WNDV.INITIAL_PICKUP_DATE
, WNDV.ULTIMATE_DROPOFF_DATE
, WNDV.NUMBER_OF_LPN
, WNDV.WAYBILL
, WNDV.CARRIER_ID
, WCV.CARRIER_NAME
, WNDV.MODE_OF_TRANSPORT
, WNDV.ADDITIONAL_SHIPMENT_INFO
, WNDV.ATTRIBUTE1
, WNDV.ATTRIBUTE2
, WNDV.ATTRIBUTE3
, WNDV.ATTRIBUTE4
, WNDV.ATTRIBUTE5
, WNDV.ATTRIBUTE6
, WNDV.ATTRIBUTE7
, WNDV.ATTRIBUTE8
, WNDV.ATTRIBUTE9
, WNDV.ATTRIBUTE10
, WNDV.ATTRIBUTE11
, WNDV.ATTRIBUTE12
, WNDV.ATTRIBUTE13
, WNDV.ATTRIBUTE14
, WNDV.ATTRIBUTE15
, WNDV.ATTRIBUTE_CATEGORY
, WNDV.LAST_UPDATE_DATE
, WNDV.LAST_UPDATED_BY
, WNDV.LAST_UPDATE_LOGIN
, WNDV.CREATION_DATE
, WNDV.CREATED_BY
FROM WSH_NEW_DELIVERIES_V WNDV
, MTL_PARAMETERS MP
, HR_ALL_ORGANIZATION_UNITS_TL HRORG
, WSH_LOCATIONS WL1
, WSH_LOCATIONS WL2
, WSH_LOCATIONS WL3
, WSH_LOCATIONS WL4
, QA_CUSTOMERS_LOV_V RAC
, WSH_CARRIER_SHIP_METHODS_V WCSMV
, WSH_CARRIERS_V WCV
, WSH_LOOKUPS WLOOK1
WHERE WNDV.ORGANIZATION_ID = MP.ORGANIZATION_ID(+)
AND WNDV.ORGANIZATION_ID = HRORG.ORGANIZATION_ID(+)
AND USERENV('LANG') = HRORG.LANGUAGE(+)
AND WNDV.INITIAL_PICKUP_LOCATION_ID = WL1.WSH_LOCATION_ID(+)
AND WNDV.ULTIMATE_DROPOFF_LOCATION_ID = WL2.WSH_LOCATION_ID(+)
AND WNDV.INTMED_SHIP_TO_LOCATION_ID = WL3.WSH_LOCATION_ID(+)
AND WNDV.POOLED_SHIP_TO_LOCATION_ID = WL4.WSH_LOCATION_ID(+)
AND WNDV.CUSTOMER_ID = RAC.CUSTOMER_ID(+)
AND WNDV.ORGANIZATION_ID = WCSMV.ORGANIZATION_ID(+)
AND WNDV.SHIP_METHOD_CODE = WCSMV.SHIP_METHOD_CODE(+)
AND WNDV.CARRIER_ID = WCV.CARRIER_ID(+)
AND WNDV.SERVICE_LEVEL = WLOOK1.LOOKUP_CODE(+)
AND WLOOK1.LOOKUP_TYPE(+) = 'WSH_SERVICE_LEVELS'