VIEW: APPS.WSHBV_TRIPS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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