APPS.WSH_INBOUND_SHIP_ADVICE_PKG dependencies on WSH_DEL_ASSGN_INTERFACE
Line 80: FROM wsh_del_assgn_interface wdai,
76: and wda.delivery_id IS NOT NULL
77: and wda.delivery_id = l_delivery_id
78: MINUS
79: SELECT wdai.delivery_detail_id 80: FROM wsh_del_assgn_interface wdai, 81: wsh_del_details_interface wddi
82: where wddi.delivery_detail_interface_id = wdai.delivery_detail_interface_id
83: and wddi.container_flag = 'Y'
84: and wdai.parent_delivery_detail_id IS NULL