View: WSH_DELIVERIES_BOL_RDF_V

Product:	WSH - Shipping Execution
Description:
Implementation/DBA Data:	APPS.WSH_DELIVERIES_BOL_RDF_V

View Text

SELECT DELIVERY_ID
, NAME
, DELIVERY_TYPE
, DECODE(DELIVERY_TYPE
, 'STANDARD'
, NULL
, LKP.MEANING) DELIVERY_TYPE_MEANING
, ORGANIZATION_ID
, SHIPMENT_DIRECTION
FROM WSH_NEW_DELIVERIES WND
, FND_LOOKUP_VALUES_VL LKP
WHERE WND.DELIVERY_TYPE=LKP.LOOKUP_CODE
AND LKP.LOOKUP_TYPE = 'WSH_DELIVERY_TYPE'

Columns