DBA Data[Home] [Help]

APPS.WSH_INTERFACE_VALIDATIONS_PKG dependencies on WSH_DEL_ASSGN_INTERFACE

Line 351: wsh_del_assgn_interface wda

347: CURSOR delivery_detail_int_cur (p_delivery_id NUMBER)
348: IS
349: SELECT DISTINCT wdd.delivery_detail_id
350: FROM wsh_del_details_interface wdd,
351: wsh_del_assgn_interface wda
352: WHERE wdd.delivery_detail_interface_id = wda.delivery_detail_interface_id
353: AND wdd.container_flag = 'N'
354: AND wda.delivery_id = p_delivery_id
355: AND wda.interface_action_code = '94X_INBOUND'

Line 505: FROM wsh_del_assgn_interface wda, wsh_del_details_interface wdd

501: SELECT DISTINCT wdd.delivery_detail_id, wdd.customer_id, wdd.customer_item_id,
502: wdd.deliver_to_location_id, wdd.intmed_ship_to_location_id,
503: wdd.inventory_item_id, wdd.organization_id,
504: wdd.ship_from_location_id, wdd.ship_to_location_id
505: FROM wsh_del_assgn_interface wda, wsh_del_details_interface wdd
506: WHERE wda.delivery_id = p_delivery_id
507: AND wda.delivery_detail_interface_id = wdd.delivery_detail_interface_id
508: AND wdd.container_flag = 'N'
509: AND WDD.INTERFACE_ACTION_CODE = '94X_INBOUND'