APPS.WMS_DEVICE_CONFIRMATION_PUB dependencies on DUAL

Line 101: SELECT 1 INTO l_lot_cnt FROM dual WHERE exists

97:
98: IF (l_lot_code >1) THEN--means LOT CONTROLLED
99:
100: IF l_child_rec.lot_number IS NOT NULL THEN
101: SELECT 1 INTO l_lot_cnt FROM dual WHERE exists
102: (SELECT lot_number FROM mtl_transaction_lots_temp
103: WHERE transaction_temp_id = p_txn_temp_id
104: AND lot_number = l_child_rec.lot_number );
105:

Line 135: SELECT 1 INTO l_serial_cnt FROM dual WHERE exists

131: /* -- Serial Not supported, Will be done later
132: IF (l_serial_code >1 AND l_serial_code<>6) THEN --both lot and serial controlled
133:
134: IF l_child_rec.serial_number IS NOT NULL THEN
135: SELECT 1 INTO l_serial_cnt FROM dual WHERE exists
136: (SELECT fm_serial_number--What if RANGE serials ??
137: FROM mtl_serial_numbers_temp msnt,
138: mtl_transaction_lots_temp mtlt
139: WHERE mtlt.transaction_temp_id = p_txn_temp_id

Line 164: SELECT 1 INTO l_serial_cnt FROM dual WHERE exists

160:
161: ELSIF (l_serial_code >1 AND l_serial_code<>6) THEN --serial controlled only
162:
163: IF l_child_rec.serial_number IS NOT NULL THEN
164: SELECT 1 INTO l_serial_cnt FROM dual WHERE exists
165: (SELECT fm_serial_number
166: FROM mtl_serial_numbers_temp msnt
167: WHERE msnt.transaction_temp_id = p_txn_temp_id
168: AND msnt.fm_serial_number = l_child_rec.serial_number);

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

246:
247: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
248: BEGIN
249:
250: SELECT wms_device_requests_s.nextval INTO l_request_id FROM dual;
251: IF (l_debug = 1) THEN
252: trace('Inside populate_History: New request_id for all records:'||l_request_id);
253: END IF;
254:

Line 629: FROM dual

625: BEGIN
626:
627: SELECT 1
628: INTO l_loaded
629: FROM dual
630: WHERE exists
631: ( SELECT 1
632: from mtl_material_transactions_temp
633: where transaction_header_id

Line 756: FROM dual

752: BEGIN
753:
754: SELECT 1
755: INTO l_so_cnt
756: FROM dual
757: WHERE exists
758: (SELECT 1
759: FROM wsh_delivery_details
760: WHERE lpn_id=p_lpn

Line 811: SELECT 1 INTO l_item_cnt FROM DUAL WHERE exists

807: END IF;
808:
809: BEGIN
810:
811: SELECT 1 INTO l_item_cnt FROM DUAL WHERE exists
812: ( SELECT 1
813: FROM wms_lpn_contents wlc
814: WHERE wlc.parent_lpn_id = p_lpn
815: AND wlc.organization_id = p_org_id

Line 840: SELECT 1 INTO l_item_cnt FROM DUAL WHERE exists

836: --Do this only for lot controlled items
837:
838: BEGIN
839:
840: SELECT 1 INTO l_item_cnt FROM DUAL WHERE exists
841: ( SELECT 1
842: FROM wms_lpn_contents wlc,
843: mtl_transaction_lots_temp mtlt
844: WHERE wlc.parent_lpn_id = p_lpn

Line 2668: SELECT mtl_material_transactions_s.NEXTVAL INTO l_txn_hdr_id FROM DUAL;

2664:
2665: SAVEPOINT WMS_DEVICE_REQUESTS_SP_OUTER;
2666:
2667: --this header_id will be used to call TM for the batch
2668: SELECT mtl_material_transactions_s.NEXTVAL INTO l_txn_hdr_id FROM DUAL;
2669:
2670: IF (l_debug = 1) THEN
2671: trace('Inside Device_Confirmation API:p_request_id'||p_request_id);
2672: END IF;

Line 2852: SELECT 1 INTO l_count FROM DUAL WHERE exists

2848: IF l_rec.transfer_loc_id IS NOT NULL THEN --chances are that didn't choose suggestion
2849: IF l_rec.transfer_loc_id <> l_xfer_loc_id THEN--loc discrepancy
2850: l_loc_discrepancy_flag := 1;
2851:
2852: SELECT 1 INTO l_count FROM DUAL WHERE exists
2853: ( SELECT 1
2854: FROM mtl_item_locations_kfv
2855: WHERE organization_id = l_rec.organization_id
2856: AND inventory_location_id = l_rec.transfer_loc_id