DBA Data[Home] [Help]

APPS.WSM_LBJ_INTERFACE_PVT dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 9011: from mtl_transaction_lots_temp

9007: -- Check.MMTT
9008: begin
9009: select 1
9010: into l_temp_num
9011: from mtl_transaction_lots_temp
9012: where lot_number = v_wsli(v_wlji_src_line_id(v_idx)).lot_number
9013: and rownum = 1;
9014:
9015: if l_temp_num <>0 then

Line 9042: 'Table: mtl_transaction_lots_temp ');

9038: If l_temp_num <> 0 then
9039: fnd_message.set_name('WSM', 'WSM_PENDING_TXN');
9040: fnd_message.set_token('TABLE','Starting Lot:' ||
9041: v_wsli(v_wlji_src_line_id(v_idx)).lot_number ||
9042: 'Table: mtl_transaction_lots_temp ');
9043: l_error_msg := fnd_message.get;
9044: l_error_code := -1;
9045: handle_error( l_error_code, l_error_msg, l_stmt_num);
9046: l_error_count := l_error_count + 1;

Line 11799: INSERT INTO MTL_TRANSACTION_LOTS_TEMP (

11795: 'Inserted '||SQL%ROWCOUNT||' rows into mmtt');
11796: end if;
11797:
11798: l_stmt_num := 1020;
11799: INSERT INTO MTL_TRANSACTION_LOTS_TEMP (
11800: transaction_temp_id,
11801: last_update_date,
11802: creation_date,
11803: last_updated_by,