VIEW: APPS.WSHBV_TRIP_STOPS

Source

View Text - Preformatted

SELECT STOP_ID,TRIP_ID ,LOC.SOURCE_LOCATION_ID, '_LA:STATUS_CODE:WSH_LOOKUPS:TRIP_STOP_STATUS:MEANING', STOP_SEQUENCE_NUMBER, PLANNED_ARRIVAL_DATE, ACTUAL_ARRIVAL_DATE, PLANNED_DEPARTURE_DATE,ACTUAL_DEPARTURE_DATE, DEPARTURE_GROSS_WEIGHT,DEPARTURE_NET_WEIGHT, WEIGHT_UOM_CODE,DEPARTURE_VOLUME, VOLUME_UOM_CODE,DEPARTURE_SEAL_CODE, DEPARTURE_FILL_PERCENT ,'_LA:PENDING_INTERFACE_FLAG:FND_LOOKUPS:YES_NO:MEANING' ,wts.CREATION_DATE , wts.CREATED_BY , wts.LAST_UPDATE_DATE , wts.LAST_UPDATED_BY ,wts. LAST_UPDATE_LOGIN, wts.shipments_type_flag FROM WSH_TRIP_STOPS WTS, WSH_LOCATIONS LOC WHERE WTS.STOP_LOCATION_ID = LOC.WSH_LOCATION_ID AND NVL(WTS.SHIPMENTS_TYPE_FLAG, 'O') IN ('O', 'M') WITH READ ONLY

View Text - HTML Formatted

SELECT STOP_ID
, TRIP_ID
, LOC.SOURCE_LOCATION_ID
, '_LA:STATUS_CODE:WSH_LOOKUPS:TRIP_STOP_STATUS:MEANING'
, STOP_SEQUENCE_NUMBER
, PLANNED_ARRIVAL_DATE
, ACTUAL_ARRIVAL_DATE
, PLANNED_DEPARTURE_DATE
, ACTUAL_DEPARTURE_DATE
, DEPARTURE_GROSS_WEIGHT
, DEPARTURE_NET_WEIGHT
, WEIGHT_UOM_CODE
, DEPARTURE_VOLUME
, VOLUME_UOM_CODE
, DEPARTURE_SEAL_CODE
, DEPARTURE_FILL_PERCENT
, '_LA:PENDING_INTERFACE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, WTS.CREATION_DATE
, WTS.CREATED_BY
, WTS.LAST_UPDATE_DATE
, WTS.LAST_UPDATED_BY
, WTS. LAST_UPDATE_LOGIN
, WTS.SHIPMENTS_TYPE_FLAG
FROM WSH_TRIP_STOPS WTS
, WSH_LOCATIONS LOC
WHERE WTS.STOP_LOCATION_ID = LOC.WSH_LOCATION_ID
AND NVL(WTS.SHIPMENTS_TYPE_FLAG
, 'O') IN ('O'
, 'M') WITH READ ONLY