Order Modification: Saved Conditions

As mentioned in the Order Modification: Workflow topic, the desired agent action may vary depending on the state of the shipment and type of modification. A saved condition may be used with the IF agent action to control which agent action should be used depending on the circumstance. The below saved conditions are included with Oracle Transportation Management and address some of the most common conditions.

OR ON SHIPMENT

OR ON SHIPMENT is a saved condition which uses a saved query ‘OR ON SHIPMENT’ to check if this order release is on a shipment.

select o.order_release_gid from ORDER_RELEASE o, SHIPMENT SHP, SHIPMENT_S_EQUIPMENT_JOIN SSEJ, S_EQUIPMENT_S_SHIP_UNIT_JOIN SESSUJ, S_SHIP_UNIT_LINE SSUL where SHP.SHIPMENT_GID = SSEJ.SHIPMENT_GID AND SSEJ.S_EQUIPMENT_GID = SESSUJ.S_EQUIPMENT_GID AND SESSUJ.S_SHIP_UNIT_GID = SSUL.S_SHIP_UNIT_GID AND SSUL.ORDER_RELEASE_GID IS NOT NULL and (o.order_release_gid=ssul.order_release_gid) and (o.order_release_gid=?)

OR ON SHIPMENT IN TRANSIT

OR ON SHIPMENT IN TRANSIT is a saved condition which used a saved query ‘OR ON SHIPMENT IN TRANSIT’ to check if this order release is on a shipment which the carrier has already started to execute.

select o.order_release_gid from shipment shp,shipment_s_equipment_join ssej,s_equipment_s_ship_unit_join sessuj, s_ship_unit_line ssul,order_release_line orl,order_release o,shipment_status ss,status_value sv where shp.shipment_gid = ssej.shipment_gid and ssej.s_equipment_gid = sessuj.s_equipment_gid and sessuj.s_ship_unit_gid = ssul.s_ship_unit_gid and ssul.or_line_gid = orl.order_release_line_gid and orl.order_release_gid = o.order_release_gid and shp.shipment_gid = ss.shipment_gid and ss.status_value_gid = sv.status_value_gid and sv.status_value_xid in ('ENROUTE_COMPLETED','ENROUTE_DELAYED','ENROUTE_DIVERTED','ENROUTE_ENROUTE','ENROUTE_MERGED','ENROUTE_PARTIAL','ENROUTE_UNLOADED - FULL','ENROUTE_UNLOADED - PARTIAL')

OR ON SHIPMENT WITH RESOURCES TENDERED/SECURED

The OR ON SHIPMENT WITH RESOURCES TENDERED/SECURED is a saved condition which used a saved query ‘OR ON SHIPMENT WITH RESOURCES TENDERED/SECURED’ to check if this order release is on a shipment which has been tendered to a carrier.

select o.order_release_gid from shipment shp, shipment_s_equipment_join ssej, s_equipment_s_ship_unit_join sessuj, s_ship_unit_line ssul,order_release_line orl,order_release o,shipment_status ss,status_value sv where shp.shipment_gid = ssej.shipment_gid and ssej.s_equipment_gid = sessuj.s_equipment_gid and sessuj.s_ship_unit_gid = ssul.s_ship_unit_gid and ssul.or_line_gid = orl.order_release_line_gid and orl.order_release_gid = o.order_release_gid and shp.shipment_gid = ss.shipment_gid and ss.status_value_gid = sv.status_value_gid and sv.status_value_xid in ('SECURE RESOURCES_ACCEPTED','SECURE RESOURCES_BOOKED','SECURE RESOURCES_PICKUP NOTIFICATION','SECURE RESOURCES_TENDERED','SECURE RESOURCES_BOL')