DBA Data[Home] [Help]

APPS.WSH_BOLS_PVT dependencies on WSH_TRIP_STOPS

Line 628: wsh_trip_stops wts1,

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

Line 650: wsh_trip_stops wts1,

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

Line 651: wsh_trip_stops wts2,

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'