DBA Data[Home] [Help]

APPS.WMS_PURGE_PVT dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 81: AND NOT EXISTS ( SELECT 1 FROM MTL_ONHAND_QUANTITIES_DETAIL

77: AND NOT EXISTS ( SELECT 1 FROM MTL_CYCLE_COUNT_ENTRIES
78: WHERE wlpn.lpn_context = 5
79: AND parent_lpn_id = wlpn.lpn_id
80: AND entry_status_code = 2 )
81: AND NOT EXISTS ( SELECT 1 FROM MTL_ONHAND_QUANTITIES_DETAIL
82: WHERE lpn_id = wlpn.lpn_id )
83: AND NOT EXISTS ( SELECT 1 FROM WMS_LICENSE_PLATE_NUMBERS
84: WHERE outermost_lpn_id = wlpn.outermost_lpn_id
85: AND lpn_context <> wlpn.lpn_context)