APPS.INV_RCV_INTEGRATION_APIS dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 2562: from wms_license_plate_numbers wlpn

2558: IF (p_validation_mode = g_exists_only OR p_validation_mode = g_exists_or_create) THEN
2559: BEGIN
2560: select 1, lpn_id
2561: into l_exists, l_lpn_id
2562: from wms_license_plate_numbers wlpn
2563: where wlpn.organization_id = nvl(p_org_id, wlpn.organization_id )
2564: and wlpn.license_plate_number = p_lpn
2565: and wlpn.lpn_id = nvl(p_lpn_id, wlpn.lpn_id)
2566: and ( (p_parent_lpn_id is null ) or ( wlpn.parent_lpn_id = p_parent_lpn_id and p_parent_lpn_id is not null ))

Line 3068: FROM rcv_supply rs, wms_license_plate_numbers wlpn

3064: SELECT 1
3065: INTO l_exist
3066: FROM dual
3067: WHERE exists (SELECT '1'
3068: FROM rcv_supply rs, wms_license_plate_numbers wlpn
3069: WHERE wlpn.lpn_id = l_lpn_id
3070: AND wlpn.lpn_id = rs.lpn_id
3071: AND rs.location_id <> l_location_id);
3072: ELSE

Line 3077: FROM rcv_supply rs, wms_license_plate_numbers wlpn

3073: SELECT 1
3074: INTO l_exist
3075: FROM dual
3076: WHERE exists (SELECT '1'
3077: FROM rcv_supply rs, wms_license_plate_numbers wlpn
3078: WHERE wlpn.license_plate_number = l_lpn_num
3079: AND wlpn.lpn_id = rs.lpn_id
3080: AND rs.location_id <> l_location_id);
3081: END IF;