787: IS
788: SELECT customer_id, initial_pickup_location_id,
789: intmed_ship_to_location_id, organization_id,
790: ultimate_dropoff_location_id
791: FROM wsh_new_del_interface
792: WHERE delivery_id = p_delivery_id
793: AND INTERFACE_ACTION_CODE ='94X_INBOUND';
794:
795: CURSOR delivery_detail_int_cur (p_delivery_id NUMBER)