APPS.INV_RCV_INTEGRATION_APIS dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 2591: from wms_license_plate_numbers wlpn

2587: IF (p_validation_mode = g_exists_only OR p_validation_mode = g_exists_or_create) THEN
2588: BEGIN
2589: select 1, lpn_id
2590: into l_exists, l_lpn_id
2591: from wms_license_plate_numbers wlpn
2592: where wlpn.organization_id = nvl(p_org_id, wlpn.organization_id )
2593: and wlpn.license_plate_number = p_lpn
2594: and wlpn.lpn_id = nvl(p_lpn_id, wlpn.lpn_id)
2595: 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 3097: FROM rcv_supply rs, wms_license_plate_numbers wlpn

3093: SELECT 1
3094: INTO l_exist
3095: FROM dual
3096: WHERE exists (SELECT '1'
3097: FROM rcv_supply rs, wms_license_plate_numbers wlpn
3098: WHERE wlpn.lpn_id = l_lpn_id
3099: AND wlpn.lpn_id = rs.lpn_id
3100: AND rs.location_id <> l_location_id);
3101: ELSE

Line 3106: FROM rcv_supply rs, wms_license_plate_numbers wlpn

3102: SELECT 1
3103: INTO l_exist
3104: FROM dual
3105: WHERE exists (SELECT '1'
3106: FROM rcv_supply rs, wms_license_plate_numbers wlpn
3107: WHERE wlpn.license_plate_number = l_lpn_num
3108: AND wlpn.lpn_id = rs.lpn_id
3109: AND rs.location_id <> l_location_id);
3110: END IF;

Line 3440: (SELECT 1 FROM wms_license_plate_numbers wlpn

3436: FROM rcv_transactions rt
3437: WHERE rt.group_id= p_group_id
3438: AND (rt.wip_entity_id IS NOT NULL
3439: OR(rt.transfer_lpn_id IS NOT NULL AND EXISTS
3440: (SELECT 1 FROM wms_license_plate_numbers wlpn
3441: WHERE wlpn.lpn_id = rt.transfer_lpn_id
3442: AND wlpn.lpn_context = 11)))
3443: AND ROWNUM =1;
3444: IF (l_debug = 1) THEN