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.INV_DETAIL_UTIL_PVT dependencies on DUAL

Line 370: -- this item is dual UOM

366: /* Start Bug 9172258 */
367: print_debug('inv_cache.item_rec.tracking_quantity_ind '||inv_cache.item_rec.tracking_quantity_ind);
368: print_debug('(1)x_request_line_rec.secondary_quantity '||x_request_line_rec.secondary_quantity);
369: IF (inv_cache.item_rec.tracking_quantity_ind = 'PS') THEN
370: -- this item is dual UOM
371: l_secondary_quantity_to_detail := x_request_line_rec.secondary_quantity;
372: END IF;
373: /* End Bug 9172258 */
374:

Line 381: -- this item is dual UOM

377:
378: l_quantity_to_detail := x_request_line_rec.required_quantity;
379: /* Start Bug 9172258 */
380: IF (inv_cache.item_rec.tracking_quantity_ind = 'PS') THEN
381: -- this item is dual UOM
382: l_secondary_quantity_to_detail := x_request_line_rec.secondary_required_quantity;
383: END IF;
384: /* End Bug 9172258 */
385: END IF;

Line 425: -- this item is dual UOM

421: print_debug('l_secondary_quantity_to_detail '||l_secondary_quantity_to_detail);
422: print_debug('x_request_line_rec.secondary_quantity_detailed '||x_request_line_rec.secondary_quantity_detailed);
423: print_debug('x_request_line_rec.secondary_quantity_delivered '||x_request_line_rec.secondary_quantity_delivered);
424: IF (inv_cache.item_rec.tracking_quantity_ind = 'PS') THEN
425: -- this item is dual UOM
426: x_request_line_rec.secondary_quantity := l_secondary_quantity_to_detail -
427: greatest(NVL(x_request_line_rec.secondary_quantity_detailed ,0),
428: NVL(x_request_line_rec.secondary_quantity_delivered,0));
429: END IF;

Line 3026: FROM dual;

3022: --
3023: -- get the next val of mtl_material_transactions_s
3024: FUNCTION next_temp_id RETURN NUMBER IS
3025: CURSOR l_cursor IS SELECT mtl_material_transactions_s.NEXTVAL
3026: FROM dual;
3027: l_temp_id NUMBER;
3028: BEGIN
3029: OPEN l_cursor;
3030: FETCH l_cursor INTO l_temp_id;

Line 3321: INTO l_txn_header_id FROM DUAL;

3317: -- l_qty_sign := -1;
3318: -- END IF;
3319: l_qty_sign := 1;
3320: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
3321: INTO l_txn_header_id FROM DUAL;
3322: g_transaction_header_id := l_txn_header_id;
3323: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
3324: INTO l_txn_temp_id FROM DUAL;
3325: IF p_request_context.item_lot_control_code = 2 THEN

Line 3324: INTO l_txn_temp_id FROM DUAL;

3320: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
3321: INTO l_txn_header_id FROM DUAL;
3322: g_transaction_header_id := l_txn_header_id;
3323: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
3324: INTO l_txn_temp_id FROM DUAL;
3325: IF p_request_context.item_lot_control_code = 2 THEN
3326: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
3327: INTO l_serial_temp_id FROM DUAL;
3328: END IF;

Line 3327: INTO l_serial_temp_id FROM DUAL;

3323: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
3324: INTO l_txn_temp_id FROM DUAL;
3325: IF p_request_context.item_lot_control_code = 2 THEN
3326: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
3327: INTO l_serial_temp_id FROM DUAL;
3328: END IF;
3329: l_mmtt_tbl_size := 0;
3330: l_mtlt_tbl_size := 0;
3331: l_msnt_tbl_size := 0;

Line 3598: print_debug('process output before mtlt update inside if residual, l_lot_temp_qty_txn_uom '||l_lot_temp_qty_txn_uom);

3594: print_debug('process output before mtlt update , l_mmtt_tbl(l_mmtt_tbl_size).wms_task_type '||p_request_context.wms_task_type );
3595:
3596: IF(abs(l_lot_ten_temp_qty - l_lot_temp_qty) <> 0 AND abs(l_lot_ten_temp_qty - l_lot_temp_qty) < 0.00005 ) THEN --14192711
3597: l_lot_temp_qty_txn_uom := p_request_line_rec.quantity;
3598: print_debug('process output before mtlt update inside if residual, l_lot_temp_qty_txn_uom '||l_lot_temp_qty_txn_uom);
3599: END IF;
3600:
3601: l_mtlt_tbl(l_mtlt_tbl_size).transaction_quantity := l_qty_sign * l_lot_temp_qty_txn_uom;
3602:

Line 3745: print_debug('process output before mtlt update inside if residual, l_txn_temp_qty_txn_uom '||l_txn_temp_qty_txn_uom);

3741: print_debug('process output before mmtt update , l_mmtt_tbl(l_mmtt_tbl_size).wms_task_type '||p_request_context.wms_task_type );
3742:
3743: IF(abs(l_ten_temp_qty - l_txn_temp_qty) <> 0 AND abs(l_ten_temp_qty - l_txn_temp_qty) < 0.00005 ) THEN --14192711
3744: l_txn_temp_qty_txn_uom := p_request_line_rec.quantity;
3745: print_debug('process output before mtlt update inside if residual, l_txn_temp_qty_txn_uom '||l_txn_temp_qty_txn_uom);
3746: END IF;
3747:
3748: l_mmtt_tbl(l_mmtt_tbl_size).transaction_quantity := l_qty_sign * l_txn_temp_qty_txn_uom; --10067944
3749: l_mmtt_tbl(l_mmtt_tbl_size).transaction_uom := p_request_context.transaction_uom_code;

Line 3955: INTO l_serial_temp_id FROM DUAL;

3951: -- see whether we need a new l_serial_temp_id
3952: IF p_request_context.item_serial_control_code IN (2,5,6) THEN
3953: -- get the serial temp id if serial control is yes
3954: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
3955: INTO l_serial_temp_id FROM DUAL;
3956: END IF;
3957: END IF;
3958: IF p_request_context.item_lot_control_code = 2 THEN
3959: -- lot control is yes

Line 3974: INTO l_txn_temp_id FROM DUAL;

3970: -- reset the quantity for the next mmtt record
3971: l_txn_temp_qty := 0;
3972: l_sec_txn_temp_qty := 0;
3973: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
3974: INTO l_txn_temp_id FROM DUAL;
3975: END IF;
3976: -- accumulate the quantity from g_output_process_tbl(l_index)
3977: -- for the next mmtt record
3978: l_txn_temp_qty := l_txn_temp_qty

Line 4329: SELECT 'Y' into l_status_return FROM DUAL WHERE EXISTS(

4325: -- Allocation is across loose and packed material.
4326:
4327: BEGIN
4328:
4329: SELECT 'Y' into l_status_return FROM DUAL WHERE EXISTS(
4330: SELECT 1 FROM mtl_onhand_quantities_detail moqd
4331: WHERE moqd.organization_id = p_organization_id
4332: AND moqd.inventory_item_id = p_inventory_item_id
4333: AND moqd.subinventory_code = p_subinventory_code