APPS.WSH_INBOUND_SHIP_ADVICE_PKG dependencies on WSH_DEL_ASSGN_INTERFACE
Line 75: FROM wsh_del_assgn_interface wdai,
71: and wda.delivery_id IS NOT NULL
72: and wda.delivery_id = l_delivery_id
73: MINUS
74: SELECT wdai.delivery_detail_id 75: FROM wsh_del_assgn_interface wdai, 76: wsh_del_details_interface wddi
77: where wddi.delivery_detail_interface_id = wdai.delivery_detail_interface_id
78: and wddi.container_flag = 'Y'
79: and wdai.parent_delivery_detail_id IS NULL