VIEW: APPS.QA_ERES_WSH_NEW_DELIVERIES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'