DBA Data[Home] [Help]

APPS.WMS_PURGE_PVT dependencies on MTL_TRANSACTIONS_INTERFACE

Line 69: AND NOT EXISTS ( SELECT 1 FROM MTL_TRANSACTIONS_INTERFACE

65: FROM WMS_LICENSE_PLATE_NUMBERS wlpn, WMS_TXN_CONTEXT_TEMP wtct
66: WHERE wtct.txn_source_name = 'WMS_LPN_PURGE'
67: AND wlpn.lpn_id = wtct.line_id
68: AND wlpn.lpn_context IN (4, 5)
69: AND NOT EXISTS ( SELECT 1 FROM MTL_TRANSACTIONS_INTERFACE
70: WHERE lpn_id = wlpn.lpn_id
71: OR content_lpn_id = wlpn.lpn_id
72: OR transfer_lpn_id = wlpn.lpn_id )
73: AND NOT EXISTS ( SELECT 1 FROM MTL_MATERIAL_TRANSACTIONS_TEMP