VIEW: APPS.WSH_TRIPS_OB_GRP_V

Source

View Text - Preformatted

SELECT TRIP_ID , NAME , PLANNED_FLAG , ARRIVE_AFTER_TRIP_ID , STATUS_CODE , VEHICLE_ITEM_ID , VEHICLE_NUMBER , CARRIER_ID , SHIP_METHOD_CODE , ROUTE_ID , ROUTING_INSTRUCTIONS , ATTRIBUTE_CATEGORY , ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , ATTRIBUTE10, ATTRIBUTE11 , ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14 , ATTRIBUTE15 , CREATION_DATE , CREATED_BY , LAST_UPDATE_DATE , LAST_UPDATED_BY , LAST_UPDATE_LOGIN , PROGRAM_APPLICATION_ID , PROGRAM_ID , PROGRAM_UPDATE_DATE , REQUEST_ID , VEHICLE_ORGANIZATION_ID, VEHICLE_NUM_PREFIX , SERVICE_LEVEL , MODE_OF_TRANSPORT , FREIGHT_TERMS_CODE , CONSOLIDATION_ALLOWED , LOAD_TENDER_STATUS , ROUTE_LANE_ID , LANE_ID , SCHEDULE_ID , BOOKING_NUMBER , LOAD_TENDER_NUMBER , VESSEL , VOYAGE_NUMBER , PORT_OF_LOADING , PORT_OF_DISCHARGE , WF_NAME , WF_PROCESS_NAME , WF_ITEM_KEY , CARRIER_CONTACT_ID , SHIPPER_WAIT_TIME , WAIT_TIME_UOM , LOAD_TENDERED_TIME , CARRIER_RESPONSE , SEAL_CODE , IGNORE_FOR_PLANNING , TP_PLAN_NAME , TP_TRIP_NUMBER , SHIPMENTS_TYPE_FLAG, OPERATOR from wsh_trips WHERE NVL(SHIPMENTS_TYPE_FLAG,'O') IN ('O','M')

View Text - HTML Formatted

SELECT TRIP_ID
, NAME
, PLANNED_FLAG
, ARRIVE_AFTER_TRIP_ID
, STATUS_CODE
, VEHICLE_ITEM_ID
, VEHICLE_NUMBER
, CARRIER_ID
, SHIP_METHOD_CODE
, ROUTE_ID
, ROUTING_INSTRUCTIONS
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, VEHICLE_ORGANIZATION_ID
, VEHICLE_NUM_PREFIX
, SERVICE_LEVEL
, MODE_OF_TRANSPORT
, FREIGHT_TERMS_CODE
, CONSOLIDATION_ALLOWED
, LOAD_TENDER_STATUS
, ROUTE_LANE_ID
, LANE_ID
, SCHEDULE_ID
, BOOKING_NUMBER
, LOAD_TENDER_NUMBER
, VESSEL
, VOYAGE_NUMBER
, PORT_OF_LOADING
, PORT_OF_DISCHARGE
, WF_NAME
, WF_PROCESS_NAME
, WF_ITEM_KEY
, CARRIER_CONTACT_ID
, SHIPPER_WAIT_TIME
, WAIT_TIME_UOM
, LOAD_TENDERED_TIME
, CARRIER_RESPONSE
, SEAL_CODE
, IGNORE_FOR_PLANNING
, TP_PLAN_NAME
, TP_TRIP_NUMBER
, SHIPMENTS_TYPE_FLAG
, OPERATOR
FROM WSH_TRIPS
WHERE NVL(SHIPMENTS_TYPE_FLAG
, 'O') IN ('O'
, 'M')