APPS.QA_PLAN_ELEMENT_API dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 1443: FROM WMS_LICENSE_PLATE_NUMBERS

1439: id NUMBER;
1440:
1441: CURSOR c (t_id VARCHAR2) IS
1442: SELECT LPN_ID
1443: FROM WMS_LICENSE_PLATE_NUMBERS
1444: WHERE LICENSE_PLATE_NUMBER = t_id;
1445:
1446: BEGIN
1447:

Line 1470: FROM WMS_LICENSE_PLATE_NUMBERS

1466: id NUMBER;
1467:
1468: CURSOR c (t_id VARCHAR2) IS
1469: SELECT LPN_ID
1470: FROM WMS_LICENSE_PLATE_NUMBERS
1471: WHERE LICENSE_PLATE_NUMBER = t_id;
1472:
1473: BEGIN
1474:

Line 3205: FROM wms_license_plate_numbers

3201: -- After Single Scan LOV
3202: wild := value;
3203:
3204: sql_string := 'SELECT license_plate_number, attribute1
3205: FROM wms_license_plate_numbers
3206: WHERE license_plate_number like :1
3207: ORDER BY license_plate_number';
3208:
3209: OPEN x_ref FOR sql_string USING wild;

Line 3235: FROM wms_license_plate_numbers

3231: -- After Single Scan LOV
3232: wild := value;
3233:
3234: sql_string := 'SELECT license_plate_number, attribute1
3235: FROM wms_license_plate_numbers
3236: WHERE license_plate_number like :1
3237: ORDER BY license_plate_number';
3238:
3239: OPEN x_ref FOR sql_string USING wild;