VIEW: APPS.WSH_DELIVERABLE_TRIPS_V

Source

View Text - Preformatted

SELECT to_number(null), wda.delivery_detail_id, t.row_id, t.trip_id, t.name, t.planned_flag, t.arrive_after_trip_id, t.status_code, t.status_name, 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, decode(pickup_stop.status_code, 'OP', 'RE', 'AR', 'LO', 'CL', decode(dropoff_stop.status_code, 'OP', 'OB', 'AR', 'UL', 'CL', 'CO')), 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, t.shipments_type_flag, 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, t.trip_wf_process, t.carrier_reference_number, t.consignee_carrier_ac_no from wsh_delivery_assignments_v wda, wsh_new_deliveries nd, wsh_delivery_legs dl, wsh_trip_stops pickup_stop, wsh_trip_stops dropoff_stop, wsh_trips_v t WHERE wda.delivery_id = nd.delivery_id and nd.delivery_id = dl.delivery_id and dl.pick_up_stop_id = pickup_stop.stop_id and dl.drop_off_stop_id = dropoff_stop.stop_id and pickup_stop.trip_id = t.trip_id and nvl(nd.shipment_direction, 'O') IN ('O', 'IO')

View Text - HTML Formatted

SELECT TO_NUMBER(NULL)
, WDA.DELIVERY_DETAIL_ID
, T.ROW_ID
, T.TRIP_ID
, T.NAME
, T.PLANNED_FLAG
, T.ARRIVE_AFTER_TRIP_ID
, T.STATUS_CODE
, T.STATUS_NAME
, 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
, DECODE(PICKUP_STOP.STATUS_CODE
, 'OP'
, 'RE'
, 'AR'
, 'LO'
, 'CL'
, DECODE(DROPOFF_STOP.STATUS_CODE
, 'OP'
, 'OB'
, 'AR'
, 'UL'
, 'CL'
, 'CO'))
, 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
, T.SHIPMENTS_TYPE_FLAG
, 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
, T.TRIP_WF_PROCESS
, T.CARRIER_REFERENCE_NUMBER
, T.CONSIGNEE_CARRIER_AC_NO
FROM WSH_DELIVERY_ASSIGNMENTS_V WDA
, WSH_NEW_DELIVERIES ND
, WSH_DELIVERY_LEGS DL
, WSH_TRIP_STOPS PICKUP_STOP
, WSH_TRIP_STOPS DROPOFF_STOP
, WSH_TRIPS_V T
WHERE WDA.DELIVERY_ID = ND.DELIVERY_ID
AND ND.DELIVERY_ID = DL.DELIVERY_ID
AND DL.PICK_UP_STOP_ID = PICKUP_STOP.STOP_ID
AND DL.DROP_OFF_STOP_ID = DROPOFF_STOP.STOP_ID
AND PICKUP_STOP.TRIP_ID = T.TRIP_ID
AND NVL(ND.SHIPMENT_DIRECTION
, 'O') IN ('O'
, 'IO')