DBA Data[Home] [Help]

APPS.WSH_INTERFACE_VALIDATIONS_PKG dependencies on WSH_DELIVERY_DETAILS

Line 406: FROM wsh_delivery_details wdd,

402: FOR delivery_detail_int_rec IN delivery_detail_int_cur (p_delivery_id) LOOP
403: BEGIN
404: SELECT 'X'
405: INTO x_delivery_detail_exists
406: FROM wsh_delivery_details wdd,
407: wsh_delivery_assignments_v wda
408: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
409: AND wdd.delivery_detail_id = delivery_detail_int_rec.delivery_detail_id
410: AND wda.delivery_id = p_delivery_id;

Line 487: FROM wsh_delivery_details

483: SELECT DISTINCT delivery_detail_id, customer_id, customer_item_id,
484: deliver_to_location_id, intmed_ship_to_location_id,
485: inventory_item_id, organization_id, ship_from_location_id,
486: ship_to_location_id
487: FROM wsh_delivery_details
488: WHERE delivery_detail_id = p_delivery_detail_id;
489:
490: CURSOR delivery_int_cur
491: IS