eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_DEVICE_CONFIRMATION_PUB dependencies on DUAL

Line 102: SELECT 1 INTO l_lot_cnt FROM dual WHERE exists

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

Line 136: SELECT 1 INTO l_serial_cnt FROM dual WHERE exists

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

Line 165: SELECT 1 INTO l_serial_cnt FROM dual WHERE exists

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

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

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

Line 395: INTO l_new_txn_temp_id FROM dual ;

391: END IF;
392:
393:
394: SELECT mtl_material_transactions_s.nextval
395: INTO l_new_txn_temp_id FROM dual ;
396:
397:
398: INSERT INTO mtl_material_transactions_temp
399: ( TRANSACTION_HEADER_ID

Line 1148: FROM dual

1144: BEGIN
1145:
1146: SELECT 1
1147: INTO l_loaded
1148: FROM dual
1149: WHERE exists
1150: ( SELECT 1
1151: from mtl_material_transactions_temp
1152: where transaction_header_id

Line 1275: FROM dual

1271: BEGIN
1272:
1273: SELECT 1
1274: INTO l_so_cnt
1275: FROM dual
1276: WHERE exists
1277: (SELECT 1
1278: FROM wms_license_plate_numbers
1279: WHERE lpn_id=p_lpn

Line 1331: SELECT 1 INTO l_item_cnt FROM DUAL WHERE exists

1327: END IF;
1328:
1329: BEGIN
1330:
1331: SELECT 1 INTO l_item_cnt FROM DUAL WHERE exists
1332: ( SELECT 1
1333: FROM wms_lpn_contents wlc
1334: WHERE wlc.parent_lpn_id = p_lpn
1335: AND wlc.organization_id = p_org_id

Line 1360: SELECT 1 INTO l_item_cnt FROM DUAL WHERE exists

1356: --Do this only for lot controlled items
1357:
1358: BEGIN
1359:
1360: SELECT 1 INTO l_item_cnt FROM DUAL WHERE exists
1361: ( SELECT 1
1362: FROM wms_lpn_contents wlc,
1363: mtl_transaction_lots_temp mtlt
1364: WHERE wlc.parent_lpn_id = p_lpn

Line 3041: l_dual_uom_control number;

3037: ll_pr_qty NUMBER;
3038: -- start bUG 8197536
3039: ll_sec_qty NUMBER;
3040: l_secondary_uom varchar2(3);
3041: l_dual_uom_control number;
3042: -- end bUG 8197536
3043: l_txn_hdr_id NUMBER;
3044: l_txn_temp_id NUMBER;
3045: l_lot NUMBER;

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

3195:
3196: SAVEPOINT WMS_DEVICE_REQUESTS_SP_OUTER;
3197:
3198: --this header_id will be used to call TM for the batch
3199: SELECT mtl_material_transactions_s.NEXTVAL INTO l_txn_hdr_id FROM DUAL;
3200:
3201: IF (l_debug = 1) THEN
3202: trace('Inside Device_Confirmation API:p_request_id'||p_request_id);
3203: END IF;

Line 3397: SELECT 1 INTO l_count FROM DUAL WHERE exists

3393: IF l_rec.transfer_loc_id IS NOT NULL THEN --chances are that didn't choose suggestion
3394: IF l_rec.transfer_loc_id <> l_xfer_loc_id THEN--loc discrepancy
3395: l_loc_discrepancy_flag := 1;
3396:
3397: SELECT 1 INTO l_count FROM DUAL WHERE exists
3398: ( SELECT 1
3399: FROM mtl_item_locations_kfv
3400: WHERE organization_id = l_rec.organization_id
3401: AND inventory_location_id = l_rec.transfer_loc_id

Line 4519: select dual_uom_control,secondary_uom_code

4515: trace('Updating MMTT for qty/sub/loc disc');
4516: END IF;
4517:
4518: /* changes for bug 8197536 */
4519: select dual_uom_control,secondary_uom_code
4520: into l_dual_uom_control,l_secondary_uom
4521: FROM mtl_system_items_b
4522: where inventory_item_id = l_inventory_item_id
4523: and organization_id = l_rec.organization_id;

Line 4520: into l_dual_uom_control,l_secondary_uom

4516: END IF;
4517:
4518: /* changes for bug 8197536 */
4519: select dual_uom_control,secondary_uom_code
4520: into l_dual_uom_control,l_secondary_uom
4521: FROM mtl_system_items_b
4522: where inventory_item_id = l_inventory_item_id
4523: and organization_id = l_rec.organization_id;
4524: if(l_dual_uom_control <> 1)

Line 4524: if(l_dual_uom_control <> 1)

4520: into l_dual_uom_control,l_secondary_uom
4521: FROM mtl_system_items_b
4522: where inventory_item_id = l_inventory_item_id
4523: and organization_id = l_rec.organization_id;
4524: if(l_dual_uom_control <> 1)
4525: THEN
4526: ll_sec_qty := INV_Convert.inv_um_convert
4527: (item_id => l_inventory_item_id,
4528: precision => null,