APPS.WMS_RFID_DEVICE_PUB dependencies on DUAL

Line 143: SELECT wms_device_requests_s.nextval INTO l_request_id FROM dual;

139: END IF;
140:
141: --populate the WDR table
142: IF l_device_req_id_pkg IS NULL THEN
143: SELECT wms_device_requests_s.nextval INTO l_request_id FROM dual;
144: l_device_req_id_pkg := l_request_id;
145: ELSE
146: l_request_id := l_device_req_id_pkg;
147: END IF;

Line 383: SELECT -1 INTO x_is_last_lpn FROM dual WHERE exists

379:
380:
381: --check whether all the lines in the delivery are loaded
382: begin
383: SELECT -1 INTO x_is_last_lpn FROM dual WHERE exists
384: ( select wlpn.license_plate_number --distinct wlpn.license_plate_number
385: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda, wms_license_plate_numbers lpn,
386: wsh_delivery_details wdd2,wms_license_plate_numbers wlpn
387: where wdd2.delivery_detail_id = wda.parent_delivery_detail_id

Line 419: SELECT -1 INTO x_is_last_lpn FROM dual WHERE exists

415: END IF;
416: --get all the lines of the all deliveries in the trip are loaded
417: begin
418:
419: SELECT -1 INTO x_is_last_lpn FROM dual WHERE exists
420: (
421: select wlpn.license_plate_number --distinct wlpn.license_plate_number
422: from
423: wms_license_plate_numbers lpn,

Line 846: SELECT 1 INTO l_serial_at_issue FROM dual WHERE exists

842:
843: --make sure that the LPN does not have any Serial item which is defined as
844: --"Serials at SO issue
845: begin
846: SELECT 1 INTO l_serial_at_issue FROM dual WHERE exists
847: (SELECT wlpn.lpn_id
848: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn, mtl_system_items msi
849: WHERE wlpn.lpn_id = wlc.parent_lpn_id
850: AND msi.inventory_item_id = wlc.inventory_item_id

Line 1166: SELECT 1 INTO l_serial_at_issue FROM dual WHERE exists

1162:
1163: --make sure that the LPN does not have any Serial item which is defined as
1164: --"Serials at SO issue
1165: begin
1166: SELECT 1 INTO l_serial_at_issue FROM dual WHERE exists
1167: (SELECT wlpn.lpn_id
1168: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn, mtl_system_items msi
1169: WHERE wlpn.lpn_id = wlc.parent_lpn_id
1170: AND msi.inventory_item_id = wlc.inventory_item_id

Line 2361: SELECT wms_device_requests_s.nextval INTO l_request_id FROM dual;

2357: BEGIN
2358:
2359: x_return_status := 'S';
2360:
2361: SELECT wms_device_requests_s.nextval INTO l_request_id FROM dual;
2362: l_device_req_id_pkg := l_request_id; --to be used for the pallet record
2363:
2364:
2365: --By the time this API is called