[Home] [Help]
View: 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
Name |
DELIVERY_ID |
NAME |
DELIVERY_TYPE |
DELIVERY_TYPE_MEANING |
ORGANIZATION_ID |
SHIPMENT_DIRECTION |