View: WSH_TRIPS_V

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

View Text

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

Columns