APPS.QA_PLAN_ELEMENT_API dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 1424: FROM WMS_LICENSE_PLATE_NUMBERS

1420: id NUMBER;
1421:
1422: CURSOR c (t_id VARCHAR2) IS
1423: SELECT LPN_ID
1424: FROM WMS_LICENSE_PLATE_NUMBERS
1425: WHERE LICENSE_PLATE_NUMBER = t_id;
1426:
1427: BEGIN
1428:

Line 1451: FROM WMS_LICENSE_PLATE_NUMBERS

1447: id NUMBER;
1448:
1449: CURSOR c (t_id VARCHAR2) IS
1450: SELECT LPN_ID
1451: FROM WMS_LICENSE_PLATE_NUMBERS
1452: WHERE LICENSE_PLATE_NUMBER = t_id;
1453:
1454: BEGIN
1455:

Line 3113: FROM wms_license_plate_numbers

3109: -- After Single Scan LOV
3110: wild := value;
3111:
3112: sql_string := 'SELECT license_plate_number, attribute1
3113: FROM wms_license_plate_numbers
3114: WHERE license_plate_number like :1
3115: ORDER BY license_plate_number';
3116:
3117: OPEN x_ref FOR sql_string USING wild;

Line 3143: FROM wms_license_plate_numbers

3139: -- After Single Scan LOV
3140: wild := value;
3141:
3142: sql_string := 'SELECT license_plate_number, attribute1
3143: FROM wms_license_plate_numbers
3144: WHERE license_plate_number like :1
3145: ORDER BY license_plate_number';
3146:
3147: OPEN x_ref FOR sql_string USING wild;