3725: AND PROCESS_FLAG = 1
3726: AND lpn_id IS NOT NULL
3727: AND NOT EXISTS (
3728: SELECT NULL
3729: FROM wms_license_plate_numbers wlpn
3730: where
3731: wlpn.lpn_id = mti.lpn_id);
3732:
3733:
3751: AND PROCESS_FLAG = 1
3752: AND TRANSFER_LPN_ID IS NOT NULL
3753: AND NOT EXISTS (
3754: SELECT NULL
3755: FROM wms_license_plate_numbers wlpn
3756: where
3757: wlpn.lpn_id = mti.TRANSFER_LPN_ID);
3758:
3759:
3778: AND PROCESS_FLAG = 1
3779: AND CONTENT_LPN_ID IS NOT NULL
3780: AND NOT EXISTS (
3781: SELECT NULL
3782: FROM wms_license_plate_numbers wlpn
3783: where
3784: wlpn.lpn_id = mti.CONTENT_LPN_ID);
3785:
3786: