View: WSHBV_TRIPS

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

View Text

SELECT WST.TRIP_ID
, WST.NAME
, WST.ARRIVE_AFTER_TRIP_ID
, '_LA:STATUS_CODE:WSH_LOOKUPS:TRIP_STATUS:MEANING'
, WST.VEHICLE_ITEM_ID
, '_KF:INV:MSTK:MSI'
, WST.VEHICLE_NUMBER
, '_LA:SHIP_METHOD_CODE:FND_LOOKUP_VALUES_VL:SHIP_METHOD:MEANING'
, WST.ROUTING_INSTRUCTIONS
, WST.CREATION_DATE
, WST.CREATED_BY
, WST.LAST_UPDATE_DATE
, WST.LAST_UPDATED_BY
, WST.LAST_UPDATE_LOGIN
, '_LA:PLANNED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, WST.CARRIER_ID
, WST.ROUTE_ID
, WST.VEHICLE_ORGANIZATION_ID
, WST.VEHICLE_NUM_PREFIX
, WST.SHIPMENTS_TYPE_FLAG
FROM WSH_TRIPS WST
, MTL_SYSTEM_ITEMS MSI
WHERE WST.VEHICLE_ITEM_ID = MSI.INVENTORY_ITEM_ID(+)
AND WST.VEHICLE_ORGANIZATION_ID = MSI.ORGANIZATION_ID(+)
AND '_SEC:WST.VEHICLE_ORGANIZATION_ID' IS NOT NULL
AND NVL(WST.SHIPMENTS_TYPE_FLAG
, 'O') IN ('O'
, 'M') WITH READ ONLY

Columns