624: wdi.document_instance_id,
625: wdl.delivery_id , --bugfix 3990683
626: wt.name
627: from wsh_delivery_legs wdl,
628: wsh_trip_stops wts1,
629: wsh_trips wt,
630: wsh_document_instances wdi,
631: wsh_doc_sequence_categories wdsc
632: where wdsc.doc_sequence_category_id = wdi.doc_sequence_category_id
646: wdi.document_instance_id,
647: wdl.delivery_id , --bugfix 3990683
648: wt.name
649: from wsh_delivery_legs wdl,
650: wsh_trip_stops wts1,
651: wsh_trip_stops wts2,
652: wsh_trips wt,
653: wsh_document_instances wdi
654: where wdi.entity_id = wdl.delivery_leg_id
647: wdl.delivery_id , --bugfix 3990683
648: wt.name
649: from wsh_delivery_legs wdl,
650: wsh_trip_stops wts1,
651: wsh_trip_stops wts2,
652: wsh_trips wt,
653: wsh_document_instances wdi
654: where wdi.entity_id = wdl.delivery_leg_id
655: AND wdi.entity_name = 'WSH_DELIVERY_LEGS'