APPS.WSH_DOCUMENT_SETS dependencies on WSH_DELIVERY_LEGS

Line 191: wsh_delivery_legs dlg,

187: wt.ship_method_code,
188: del.initial_pickup_location_id,
189: wt.name
190: FROM wsh_new_deliveries del,
191: wsh_delivery_legs dlg,
192: wsh_trip_stops st,
193: wsh_trips wt
194: WHERE del.delivery_id = dlg.delivery_id
195: AND dlg.pick_up_stop_id = st.stop_id

Line 1184: WHERE entity_name = 'WSH_DELIVERY_LEGS'

1180:
1181: SELECT count(*)
1182: INTO l_bol_count
1183: FROM wsh_document_instances
1184: WHERE entity_name = 'WSH_DELIVERY_LEGS'
1185: AND entity_id = l_delivery_leg_id
1186: AND status <> 'CANCELLED';
1187:
1188: IF l_bol_count = 0 THEN

Line 1227: , p_entity_name => 'WSH_DELIVERY_LEGS'

1223: , p_validation_level => NULL
1224: , x_return_status => l_return_status
1225: , x_msg_count => l_msg_count
1226: , x_msg_data => l_msg_data
1227: , p_entity_name => 'WSH_DELIVERY_LEGS'
1228: , p_entity_id => l_delivery_leg_id
1229: , p_application_id => 665
1230: , p_location_id => l_pickup_location_id
1231: , p_document_type => 'BOL'