VIEW: APPS.WSHFV_TRIP_STOPS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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