DBA Data[Home] [Help]

APPS.WSH_DOCUMENT_SETS dependencies on WSH_DELIVERY_LEGS

Line 178: wsh_delivery_legs dlg,

174: wt.ship_method_code,
175: del.initial_pickup_location_id,
176: wt.name
177: FROM wsh_new_deliveries del,
178: wsh_delivery_legs dlg,
179: wsh_trip_stops st,
180: wsh_trips wt
181: WHERE del.delivery_id = dlg.delivery_id
182: AND dlg.pick_up_stop_id = st.stop_id

Line 1144: WHERE entity_name = 'WSH_DELIVERY_LEGS'

1140:
1141: SELECT count(*)
1142: INTO l_bol_count
1143: FROM wsh_document_instances
1144: WHERE entity_name = 'WSH_DELIVERY_LEGS'
1145: AND entity_id = l_delivery_leg_id
1146: AND status <> 'CANCELLED';
1147:
1148: IF l_bol_count = 0 THEN

Line 1187: , p_entity_name => 'WSH_DELIVERY_LEGS'

1183: , p_validation_level => NULL
1184: , x_return_status => l_return_status
1185: , x_msg_count => l_msg_count
1186: , x_msg_data => l_msg_data
1187: , p_entity_name => 'WSH_DELIVERY_LEGS'
1188: , p_entity_id => l_delivery_leg_id
1189: , p_application_id => 665
1190: , p_location_id => l_pickup_location_id
1191: , p_document_type => 'BOL'