DBA Data[Home] [Help]

APPS.WSH_INTERFACE_VALIDATIONS_PKG dependencies on WSH_DEL_ASSGN_INTERFACE

Line 523: wsh_del_assgn_interface wda

519: CURSOR delivery_detail_int_cur (p_delivery_id NUMBER)
520: IS
521: SELECT DISTINCT wdd.delivery_detail_id
522: FROM wsh_del_details_interface wdd,
523: wsh_del_assgn_interface wda
524: WHERE wdd.delivery_detail_interface_id = wda.delivery_detail_interface_id
525: AND wdd.container_flag = 'N'
526: AND wda.delivery_id = p_delivery_id
527: AND wda.interface_action_code = '94X_INBOUND'

Line 652: wsh_del_assgn_interface wda

648: CURSOR delivery_detail_int_cur (p_delivery_id NUMBER)
649: IS
650: SELECT DISTINCT wdd.source_header_number, wdd.delivery_detail_id, wdd.line_direction
651: FROM wsh_del_details_interface wdd,
652: wsh_del_assgn_interface wda
653: WHERE wdd.delivery_detail_interface_id = wda.delivery_detail_interface_id
654: AND wdd.container_flag <> 'Y'
655: AND wda.delivery_interface_id = p_delivery_interface_id
656: AND wda.interface_action_code = '94X_INBOUND'

Line 801: FROM wsh_del_assgn_interface wda, wsh_del_details_interface wdd

797: SELECT DISTINCT wdd.delivery_detail_id, wdd.customer_id, wdd.customer_item_id,
798: wdd.deliver_to_location_id, wdd.intmed_ship_to_location_id,
799: wdd.inventory_item_id, wdd.organization_id,
800: wdd.ship_from_location_id, wdd.ship_to_location_id
801: FROM wsh_del_assgn_interface wda, wsh_del_details_interface wdd
802: WHERE wda.delivery_id = p_delivery_id
803: AND wda.delivery_detail_interface_id = wdd.delivery_detail_interface_id
804: AND wdd.container_flag = 'N'
805: AND WDD.INTERFACE_ACTION_CODE = '94X_INBOUND'