View: WSHFV_TRIPS

Product:	WSH - Shipping Execution
Description:	Full BIS Business View forTrips.
Implementation/DBA Data:	APPS.WSHFV_TRIPS

View Text

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

Columns