APPS.GMD_OUTBOUND_APIS_PUB dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 4429: table_list := table_list ||', wms_license_plate_numbers lpn ';

4425: END IF;
4426:
4427: IF p_lpn IS NOT NULL
4428: THEN
4429: table_list := table_list ||', wms_license_plate_numbers lpn ';
4430: where_clause := where_clause ||'AND gs.lpn_id = lpn.lpn_id ';
4431:
4432: gmd_outbound_apis_pub.g_lpn := p_lpn;
4433: where_clause := where_clause||'AND lpn.license_plate_number = :lpn ';

Line 4661: FROM wms_license_plate_numbers

4657: --7027149 Added sql to get LPN from id
4658: IF g_samples_table(i).lpn_id is not NULL
4659: THEN
4660: SELECT license_plate_number into g_samples_table(i).lpn
4661: FROM wms_license_plate_numbers
4662: WHERE lpn_id = g_samples_table(i).lpn_id;
4663: END IF;
4664:
4665: