View: WSH_TRIPS_OB_GRP_V

Product:	WSH - Shipping Execution
Description:
Implementation/DBA Data:	APPS.WSH_TRIPS_OB_GRP_V

View Text

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')

Columns